«

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

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


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

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

<jake @ yono.com (Jake)> wrote in message
news:...
> 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

Thaks to all !

On Thu, 25 Sep 2003 10:12:52 +0100, "only_me" <>
wrote:

>see http://www.aspfaq.com/show.asp?id=2174
>Shame you can't have 'sticky' posts in a newsgroup
>
><jake @ yono.com (Jake)> wrote in message
>news:...
>> 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
>
>