Hi Everyone.

So I'm totally new to ASP, but I've done some VBS simple vbs coding and therefore I'm semi comfortable with asp. I'm currently working on a shopping cart and I'm pretty much done with the basic functionality (ie. adding products to cart, calculating coupons, removing products and updating quantities.) Pretty much what I'm currently stuck on is saving the order to an access DB and getting back the order ID, (primary key) for the new record created. How is this done?

Thanks for all the support.

Assuming you are using an Autonumber field for your primary key, one easy way to do this is to use an ADODB.Recordset to add the new record instead of an insert statement. You must open a recordset (an empty recordset will do) with all the fields that are required. Add a new record and set all the required fields, and Update it. The Id field will contain the new ID.

Cheers,

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems