That's the funny thing. I don't have any numeric fields in the form. They are all text fields. I do have hidden date fields that I pass through the form, but since the form works 90% of the time, I don't think they are the problem.
>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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2692 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
