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
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
