[cfaussie] RE: CFMX ODBC Access driver error

[George Lu]

Hi Joel,   Sorry, It's just a text field.   George >>> [EMAIL PROTECTED] 17/07/03 15:34:14 >>> Hi,   i assume the costCentre  field is of type decimal or currency (haven't touched Access for years)   check how many decimal places are allowed for it in the DB..   looks like you are inserting 23.45678 (number with 5 decimal places) when it can only except 23.456 (number with 3 decimal places)     hth joel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of George Lu Sent: Thursday, 17 July 2003 2:52 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/ 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/