Hi Richard, you can also use my DataTypeConvert CFC. With it converts any data to CSV without thinking about commas. You can find the CFC on my Blog www.newsight.de or download it directy here http://download.newsight.de/com/DataTypeConvert.zip.
Cheers, Artur -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:43 PM To: CF-Talk Subject: removing trailing comma in CSV row I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): <cfquery .> select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location </cfquery> <cfloop from="1" to="#get_result.recordcount#" index="i" step="1"> <cfoutput query="get_result" group="spdinput_id"> #spdinput_id#, <cfoutput>#score#,</cfoutput> <p> </cfoutput> </cfloop> Any ideas appreciated. Rick. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223805 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
