Thanks... I think I found an invalid value in the DB, but have no idea how it got there ... we're using cfqueryparam
-----Original Message----- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 3:10 PM To: CF-Talk Subject: Re: "invalid precsion" error Ummm... haven't seen it. I'm guessing it would be an invalid value, like an out-of-range value, against an integer column... perhaps a non-numerical value trying to insert into a number column? I've found that quoting values like this: "insert table (column) ('1')" can result in odd responses. That's why I've really embraced cqueryparam... no escaping, consistent typing, blah blah blah. It works pretty well... so maybe that's your answer. J On Fri, 11 Mar 2005 15:13:44 -0500, Tim Laureska <[EMAIL PROTECTED]> wrote: > Has anybody ever experienced this type of error when inserting into a > access DB? If so, what might it mean? > > Tim Laureska > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198487 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
