> What I want to do is this: query the db. If there is a record that is
> comma-delimited within the field, remove the commas and output each
> entry on a separate line.
>
> Since the Replace statement merely replaces the comma with a CRLF and
> doesn't output each entry on a separate line, it looks like I
> would need
> to do a loop within a loop. If that is so, then my question is how?
<CFQUERY NAME="MyQuery" ...>
SELECT Field1
FROM Table1
</CFQUERY>
<CFLOOP QUERY="MyQuery">
<CFIF ListLen(Field1)>
<CFLOOP LIST="#Field1#" INDEX="Item">
<BR><CFOUTPUT>#Item#</CFOUTPUT>
</CFLOOP>
</CFIF>
</CFLOOP>
Chris Lofback
Sr. Web Developer
TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL 33761
www.trxi.com
______________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
