Did you have data validation routine built for your web application? It sounds like, according to the error message, some end users put in wrong data type in some fields, e.g. character in numeric field.
Nathan Chen -----Original Message----- From: L Schaff [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 3:47 PM To: CF-Newbie Subject: MS Access Error - sometimes Hi, I have a form on our Web site where visitors enter data. We are running Coldfusion MX7. I use cfinsert to insert this data into an MS access table. Most of the time, this form works. However, I occassionally get the following error: Error Executing Database Query. Application uses a value of the wrong type for the current operation. I am unable to duplicate the error myself, and have no idea why I only get this error sporadically. Any ideas? Thank you! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2691 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
