How come I can't get the commas (which will separate the values) to work? I've tried both adding the delimiters statement to both the Valuelist statement and/or to the loop statement with no results.
Help! 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 > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
