<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
