This topic is locked

Pass parameter value to next page

9/16/2005 10:05:39 AM
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.