Hey George,
gotta agree with Steve... a 'proper' sql insert query is always preferred over a CFINSERT. But you've got a valid point, why does this not work for just one user?
1) Either this user is entering something funky into the form that submits to this page that is breaking the CFINSERT
2) I vaguely remember something to do with this error that had to do with TEXT columns in MS Access and inserting data of a certain length into the columns.... but a Google didn't really show up anything useful.
I'd rewrite this as a proper insert query, and see if that fixes the problem... and if not, talk to the user and find out exactly what they're entering into the form that's causing this to break.
hth,
jb :)
_____________________________________________
From: [EMAIL PROTECTED]@AUS On Behalf Of "George Lu" <[EMAIL PROTECTED]>
Sent: Thursday, July 17, 2003 3:09 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: CFMX ODBC Access driver error
But it's working fine for all other users.
>>> [EMAIL PROTECTED] 17/07/03 15:04:50 >>>
First thing I would be doing it getting rid of the CFINSERT and do a proper CFQUERY insert
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of George Lu
Sent: Thursday, 17 July 2003 2:52 PM
To: CFAussie Mailing List
Subject: [cfaussie] CFMX ODBC Access driver error
Hi,
�
I've got a shopping cart style internal ordering system. The system works fine for most users but there was one user who couldn't go through the Check Out page (she's tried many times). Here is the error she's got:
�
Error.Template /Intranet/Support/Stock_Order2/Checkout/orderconfirm.cfm
Error.DateTime 16/07/2003
Error.Diagnostics Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value
The error occurred on line 5.
�
Here is my code (note: line 5 is the 'formfields' line):
**************************************************************
<!--- save order details into db --->
<cftransaction>
�
<cfinsert datasource="#request.app.dsn#" tablename="tblOrders"
formfields="orderDate,orderFrom,Area,Email,deliveryAddr,costCentre,Details,byDate">
�
<!--- get order id. --->
<CFQUERY NAME="Findlastid" DATASOURCE="#request.app.dsn#">
SELECT �MAX(orderID) AS lastid
FROM tblOrders
</CFQUERY>
�
</cftransaction>
****************************************************************
�
Has anyone got any ideas what's wrong with it? Please help.
�
Thanks.
�
George
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
AMES (Adult Multicultural Education Services)
www.ames.net.au
Disclaimer
**********************************************************************
This email and any attachments may be confidential.
If received in error, please contact us and delete all copies.
Before opening or using attachments you should check them for viruses
or defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments.
Any representations or opinions expressed are those of the individual
sender, and not necessarily those of Adult Multicultural Education
Services (AMES).
**********************************************************************
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/ ---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/ ---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
is intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information, by persons or entities
other than the intended recipient is prohibited.
e-mail and associated material from any computer.
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.
:
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
