Record ID after Insert

What database are you using? In a PostgreSQL database I use, we use the following SQL to return the just-inserted primary key from the table: SELECT currval('tbl_ifq_rs_user_ser_id_seq') AS NewID; - where the the parameter to the currval function is the sequence that tracks the value of the primary key for the table.

"Ken Pollard" <webforumsuser@macromedia.com> wrote in message
news:fv52h9$10p$1@forums.macromedia.com...
>I have a form that inserts a record, the user is then redirected to a
>second
> page to upload images so I need to recall the record that was just posted.
> How
> can I capture the record ID of the record just inserted so I can use it to
> filter the recordset on the second page. - Thanks

Ken, just curious why you don't upload the images at the same time the
record is inserted?

Hi yea,
You never mentioned what server type your using.

I am an asp/vb user and usually use tom mucks dw extension for this.
http://www.tom-muck.com/extensions/help/insertretrieve/

it is a commercial extension but it is very useful.


Tom also has the same extension for php users and its free.

http://www.tom-muck.com/extensions/help/InsertRetrievePHP/

regards

k