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:2461
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