Which record is causing it to bomb? I've found that the following sort of record causes the most problems with CSV tags:
OK Field 1, 2, "3 - This is, perhaps reasonable so, OK", "4-This tends to ""Blow Up"", many times". Field 4 tends to end up as 2 or more fields, and if your tag doesn't fix this bombs out the insert/update. Andy -----Original Message----- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 12:47 PM To: CF-Talk Subject: invalid precision value I'm uploading a csv file into Access in a loop using the CSV2Data custom tag- adding new records and I get the following error: ODBC Error Code = S1104 (Invalid precision value) I've uploaded ten csv files that all worked well but this one blows up... What can cause this error message? One of my fields contains a lot of text (importing it into a Memo field, and there's commas inside the contents of the field but I was under the impression that this is acceptable in such a tag. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
