I am not sure I fully understand. Do you want to output the article name
and then underneath that output each Byline???  


......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-----Original Message-----
From: Taryn Regish [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 25, 2007 3: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:2464
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