[cfaussie] RE: CFMX ODBC Access driver error

[George Lu]

Ok, thank you John and Steve.   George >>> [EMAIL PROTECTED] 17/07/03 15:16:31 >>> ****************************************************************   This e-mail is subject to the disclaimer contained at the bottom of this message.   ***************************************************************** : 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/ :   ******************************************************************* The information transmitted in this message and attachments (if any) 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.  If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses and cleared by MailMarshal. ******************************************************************** : --- 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/