Hi Greg,
>I've got a problem. I'm building a site that lets users order products, and
>when one orders something, the info about the order gets inserted into my
>access database. Now, I have one column called "Order_ID", which is set in
>Access to be an random autonumber data type. On my "thank you for your
>order" page, I want to be able to display the order number so that customers
>can track their orders. How do I get cf to display the autonumber that was
>just generated for that order? I can't just do a select orders where
>name=<customer's name> because I want to make it possible for one customer
>to make multiple orders.
You should be able to repeat your database insert as a select, same items,
etc. not just the customer name, and get back the autonumber just generated.
We do not ever use autonumbering, it is not worth the effort, most times
you have to read straight back from the database to get the number you just
generated. Use a table with your IDs/Refs/whatever in it and you always
know where you are. You are in control, not the database.....
--
Yours,
Kym
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
