Here's my code <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> If there is a comma within the Address Line 1 field such as 1728 W. Elm, #303, then it creates a separate column with the #303 in it. What am I doing wrong? Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
