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