That worked. Thank you. Thanks, Mark
-----Original Message----- From: Tim Do [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 2:34 PM To: CF-Talk Subject: RE: Comma Delimted list from CFLoop Mark... try this <CFLOOP QUERY="qPayment"> <CFOUTPUT> #Trim(paymentName)#<CFIF #currentrow# NEQ #qPayment.recordCount#>, </CFIF> </CFOUTPUT> </CFLOOP -----Original Message----- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 11:22 AM To: CF-Talk Subject: RE: Comma Delimted list from CFLoop 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 > > ______________________________________________________________________ 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
