Hi.
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.
Hope someone can figure this out. Thanks!!!
------------------------------------------------------------------------------
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.