Dwayne Cole, MS in MIS, MBA
Florida A&M University
Certified Advanced ColdFusion Developer
850-591-0212
"It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all "sound and fury, signifying nothing." The Fifth Discipline - Peter Senge
---------- Original Message ----------------------------------
From: "Pascal Peters" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Sun, 28 Mar 2004 11:44:43 +0200
>If you have one column of a recordset you want to convert to an array,
>you can do
>
>ListToArray(Valuelist(qQuery.Column,"~"),"~")
>
>> -----Original Message-----
>> From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
>> Sent: zondag 28 maart 2004 1:56
>> To: CF-Talk
>> Subject: Query Output in a cfscript
>>
>> I have an object for an apparel item. This item may come in
>> 10 different colors. I have a db table which will have an
>> entry for each color associated with an item (referenced by
>> the item id and the color id).
>> When initializing my apparel item I want to have a property
>> of colors.
>> This would be an array of color objects. I can easily query
>> the db to get the recordsets associated with the item, but
>> how would I loop through the recordset within a <cfscript>
>> block? Can you place a <cfoutput> tag inside a <cfscript> block?
>>
>> Cutter
>>
>>
>>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
