February 20th, 2004, 08:17 AM
Shop Cart-Problem w/ Unique Order No
I have a shopping cart and just don't get the session variable thing to pass from one page to the other. In my Access DB I have a table with order numbers and get the MAX ID + 1 ok but need to update that table so next user gets a different order number.
If someone could show me how to set up the application.cfm page and then pass the #session.token# in the pages to keep it unique I would love to use it.
-----Here is application page code-------
<cfparam name="application.ds" default="store_biz1usa_com">
-----Here is query in first page getting MAX ID-------
<!--------Gets Order ID from DB-------->
<cfquery name="getorderid" datasource="#application.ds#">
Max(OrderNO+1) as Orderid
I have tried to update table with
When I do this there is no update to the record.
This would place a value in a field in this record so that the next unique request would get the next max orderno
Any help greatly appreciated.
February 20th, 2004, 11:21 AM
First, you don't have to manually build up a variable to hold the id and token. CF generates one already, called "session.urltoken". So in all your links and form posts, you do:
Next, as far as I can tell this is just wrong:
Without a WHERE clause, this will update ALL rows in your table. And I guess I'm still unclear what you are trying to do. Do you want to insert the newest id and company into the odernumbers table?