SQL ...Asp problem

[ptran]

I have the following code, within the same ASP session, I can't seem to get the InvID after I add it into the SQLServer. Is there Anyway I can get the value of InvID without futher coding?

Thanks

Set rsContact = CreateObject("ADODB.Recordset")
Set rsContact.ActiveConnection = objConn
rsContact.Locktype = 2
rsContact.AddNew
rsContact.Update

InvID = rsContact("InvID")

[ShIzO]

what are u trying to do?

get the next id from the database?