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

[Newsgroup_User]

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.

[Newsgroup_User]

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.
>
>
>

[ferrarikid123]

Paul, could you be a bit more specific for me, I'm trying to perform a similar task. If you have two pages, and using Lee's example, how would you set this up? Thanks

[Newsgroup_User]

I have another thread open on the general Macromeda group but the theme of
it over there involves using store procedures and the @@identity thing.

I don't know if you're in the same situation but I am playing a LOT of catch
up right now and don't have time to learn some of these fundamentals in
order to do this.

Tom Muck has an extension that will do this but it uses aging technology.
It's only $15 and I'm thinking of getting it until I have the time to spend
learning this "new" stuff that has presented itself to me.

Once again we have to dump our knowledge base and re-tool.

Get so tired of that.

Anyways, let me know if you find out anything that you think will help.
Thanks

[Newsgroup_User]

It depends upon which method that you intend to use but in terms of the
@@identity you create a recordset on the insert page (after the actual
insert and before the redirection that is something like this

Select @@identity as NewID from tablename

Then you would assign this to a session variable. On the second page you
simply grab the session variable and use it to filter the field.

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

Valleybiz Internet Design
www.valleybiz.net

"ferrarikid123" <webforumsuser@macromedia.com> wrote in message
news:e3ptgh$mi0$1@forums.macromedia.com...
> Paul, could you be a bit more specific for me, I'm trying to perform a
> similar task. If you have two pages, and using Lee's example, how would
> you set this up? Thanks