database problem

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

 michael wrote:

For page one you write a Stored Procedure that inserts the data as required into table one. After the insert statement you do a simple select like 
Select Scope_Identity() as myNewPK
In asp, run a query (sql) to get this value and write it to a session, cookie or whatever you prefer.
Then redirect to page 2 and read the cookie there. 

ah yes, got that to work fine, thank you very much