Yes, value List - why didn't I think of that? (Don't answer that question ;o)
Many Thanks, Mark -----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 12:55 PM To: CF-Talk Subject: Re: Comma Delimted list from CFLoop <cfquery name="qPayment" datasource="dbo.your_datasource"> select paymentName from table </cfquery> <cfset pay_list = valuelist(qPayment.paymentName)> <cfoutput> <cfloop index="loop_pay" list="#pay_list#"> #trim(loop_pay)# </cfloop> </cfoutput> That work? At 12:39 PM 7/10/2002 -0400, Mark Leder wrote: >Is it possible to separate values returned from a CFLOOP QUERY, as in >the following example: > ><CFLOOP QUERY="qPayment"> > <CFOUTPUT> > #Trim(paymentName)# > </CFOUTPUT> > >Records returned from the query could be VISA MC AMEX > >How would it be done? > >Thanks, >Mark > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
