Diplaying database table info after an insert statement with asp
Posted on 2005-02-28
My goal is to display on the screen a confirmation number after submitting/inserting data to the database (just an Access db). This is what I currently have:
asp page 1
gets data from user to insert into table, and a submit button.
asp page 2
1. open connection to db
2. execute insert statement
3. close connection
4. display "Data submitted."
One of my table columns is called "num", and it's and AutoNumber data type that's unique (it increments each new row by one).
My question is, how would I display back with "Data submitted" on the screen "Your confirmation number is: " then have the "num" value for that insert statement as the confirmation number?
Thanks for any help.