Detecting ID of just written DB entry !

[Jake]

I have a DB with 3 fields.
ID
Name
EMail

If I write an entry into this DB, Name and EMail, the ID is auto
increment.

How can I detect what ID has been created ?

I want a user to submit details to me, they get the ID as a ticket
number ?

How can I do this ?

Thanks

 

[Bertrand]

once the table has been updated, you can run a query with
with Max(ID ) to retrieve the highest (and therefor last)
ID entered in the ID ... because more than one user can
add themselves, there is a chance that the answer is
actually not correct ... so you need to first retrieve the
Max ID then check that the name + email match the ones for
that ID and if not then just do Max(ID) - 1 or -2 etc
until you find the right combination ...
or you could just run a query bla bla Where Name =
request.form("Name") AND Email = request.form("Email") ...
the odds of 2 users with same name + same email is very
slim of course ... so the second solution is proably
better ...

HTH,

Bertrand

 

[only_me]

see http://www.aspfaq.com/show.asp?id=2174
Shame you can't have 'sticky' posts in a newsgroup

 

[Jake]

Thaks to all !

see http://www.aspfaq.com/show.asp?id=2174
Shame you can't have 'sticky' posts in a newsgroup