Display unique SQL table ID on ASP page

I have an ASP page which collects data for an SQL table. The SQL table
assigns a unique ID for each new record. Once the user submits the data, I
display a confirmation page with the data entered. I would also like to
display the unique ID on this confirmation page.

Is that possible? I am not able to get to it in the Form Properties in
Frontpage but I am sure some has some code to solve this problem.

Thanks.

Re: Display unique SQL table ID on ASP page

Ken D. wrote:
> I have an ASP page which collects data for an SQL table. The SQL
> table assigns a unique ID for each new record. Once the user submits
> the data, I display a confirmation page with the data entered. I
> would also like to display the unique ID on this confirmation page.
>
> Is that possible? I am not able to get to it in the Form Properties
> in Frontpage but I am sure some has some code to solve this problem.
>
> Thanks.
http://www.aspfaq.com/show.asp?id=2174
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"