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/
---