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
