It seems that you had a table design(data modeling) issue when the table
was crated. Since an article can have multiple byline, you should have a
separate table to store the bylines, making it.  Is my assumption
correct?

Nathan Chen

-----Original Message-----
From: Taryn Regish [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 25, 2007 1:25 PM
To: CF-Newbie
Subject: Query Help

Hi Everyone-

I need some help with a query problem. I am stumped about how to even
start
this problem that I have been playing around with all day. I have
article
data that I am trying to pull which includes:

Article Name, Topic, Byline1 and Byline2

I am running into issues because the Byline1 field can have multiples
allowed. Meaning that I can have more than one Byline in a Row of data.
So
the columns become Byline11, Byline 12, Byline13 all the way to Byline
110
because there can be 10 bylines attached to this one article all in the
same
Row of the table.

What I am trying to do is display the Byline in different rows. I need
to be
able to sort them by name and right now it only sorts by the Byline11
because that is the one that appears first in the row. Is there anyway
that
I can get Byline11, Byline12, etc to appear in separate rows.

I hope I explained this so it make some sort of sense. Any help or
direction
would be appreciated.

Thanks!




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2462
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15

Reply via email to