I agree with you completely. It is in a Content Management System and this
is the only way we are able to set it up (and how they wanted us to set it
up) unless we do separate fields for each and every byline so have Byline 1,
Byline 2, Byline 3, etc. Plus we have approxmiately 950 records which would
need to be updated by hand to change.

Is there anyway to display the data in the manner I described, without
having to update everything by hand?




On 1/25/07, Nathan Chen <[EMAIL PROTECTED]> wrote:
>
> 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:2463
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