2. ASPRunnerPro General questions
  3. Pass parameter value to next page
This topic is locked

Pass parameter value to next page

 		9/16/2005 10:05:39
ASPRunnerPro General questions
R
 razvan author

I am using an "Add" page for users to input new data only.

There is a filed called REQUEST_ID that I'd like to carry onto a confirmation page: Your Request Number {REQUEST_ID} has been received....

Note that REQUEST_ID field is auto-generated and not created until the record was saved.

Thanks.
Sergey Kornilov admin 9/19/2005

If you use MS Access you can execute the following query after record was added:

select max(REQUEST_ID) from TableName


In SQL Server you can use @@IDENTITY for this purpose.
R
 		razvan author 9/19/2005

Thank you for the instructions - what would I use for Oracle?
Sergey Kornilov admin 9/19/2005

In Oracle you can use MAX(REQUEST_ID) to retrieve added record id.