Insert into database and get newly added info on next page?

If the site is low volume then you could use the @@identity function to grab
the newly created record, however a very simple technique is to grab the
contents of one of the fields that is likely to be unique, set the value
into a session variable and then use this to filter the records on the
display page.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"lee" <lfairban_nospam@amep.com> wrote in message
news:e3fmis$isa$1@forums.macromedia.com...
>I have a mail form that adds a few text boxes to a database and redirects
>to
> a new page where the the person's name is displayed. How do I pull in the
> users information from the row in the database that was just added?
>
> I don't know why I can't get my head around this one... I swear I've done
> it before...frustrating.
>
>
>