yes, you need to either change your export routine to enclose all 'fields' in double quotes, or change your export format to, say, tab-delimited file instead of comma-delimited. most databases have built-in routines and functions to automate import of data from text files, in which you can usually specify how your data is delimited and what values are enclosed with. you can keep cf completely out of the importing data routine if you are sure of the data quality. otherwise, you can parse the data in the file with cf and, depending on your business logic, either reject the import completely if the data does not conform to your requirements, or only import the rows that do conform, and notify the user of the rows that were not imported.
hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Michael Grove wrote: > I am trying to figure out how to update a sql table using a CSV file that has > commas in the data fields. The long and Short of it, is that we have a SEO > company rewriting our keywords, meta descriptions and titles for our product > database. We were able to build a simple CSV export so that they could add > the new info. Now we need a way to import it back into the systm and update > all of the records based on the productID, wich is in the csv file. > > The developer we are using says it can be done, but we cannot have commas in > any of the fields. We can wrap the columns in double quotes on an export, > cant we do this on the import? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
