You're not doing anything wrong, any system that tries to import the CSV will automatically assume that every comma is a field delimiter, just like it's supposed to do. If you have content with commas in, you'll have to pick a different field delimiter, like Tab or pipe (|).
Example with pipes: <cfsavecontent variable="csv"> "Email Address"|"First Name"|"Last Name"|"Company"|"Address Line 1"|"Address Line 2"|"City"|"State"|"Postal Code" <cfoutput query="myQ">"#RTRIM(EMAIL)#"|"#RTRIM(FIRSTNAME)#"|"#RTRIM(LASTNAME)#"|"#RTRIM(COMPANY)#"|"#RTRIM(ADDRESS1)#"|"#RTRIM(ADDRESS2)#"|"#RTRIM(CITY)#"|"#RTRIM(STATE)#"|"#RTRIM(ZIP)#"</cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
