Find Saved Produdct ID Number from Database ?

[Fary4u]

Hi

i've got Product ID is Autonumber in MS Access database & Primary Key
& it's save the record into the database

but only problem is

how to find that following record save into database in which following Product ID ?

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open . . . .
set objrs = server.createObject("ADODB.RecordSet")
objrs.open "Select * from products",objConn,Adopendynamic,Adlockoptimistic
if objrs.eof then
 
categ=Trim(request("txtcat"))
objrs.Addnew
    objrs("catalogID")=categ
objrs.update
 
???
 

in advance thanks for reply back.

[Fary4u]

is that possible ? to get some thing like this output ?

[jhardman]

is that possible ? to get some thing like this output ?

I've had this problem before as well. I believe I had to search for it:

"SELECT id FROM table WHERE field1 = xx AND field2 = 'xxx'"

Now I look at it and think there has to be a better way. Perhaps asking for it immediately after updating?

rs.update
response.write rs("id")

I haven't tested this, but this is what I would try. I know the previous example works, but I feel there should be a better way.

Jared

[Fary4u]

i've try the 2nd way but giving me this error

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.


i think so the 1st way is the batter well i found the check the prod ID with the last & add 1 extra and pass the value to the next page that's i've done the job

nice to reply from you after a long time

regards
Fary