hey guys wanted to know if anyone can help me
i just added a set of items using the addnew property
and i want to get the autonumber/identity field of the inputed record.
i tried calling it after the update statement with no luck
any clues on why its not picking up the value?

kj

strSQL ="SELECT * FROM SHPRULE"
Set objConn = Server.CreateObject("ADODB.Connection")
Set objCmd = Server.CreateObject("ADODB.Command")
Set objRS = Server.CreateObject("ADODB.Recordset")
objConn.Open strConnString
objCmd.ActiveConnection = objConn
objCmd.CommandText = strSQL

'-- Cursor Type, Lock Type

'-- ForwardOnly 0 - ReadOnly 1
'-- KeySet 1 - Pessimistic 2
'-- Dynamic 2 - Optimistic 3
'-- Static 3 - BatchOptimistic 4
objRS.Open objCmd, , 3, 3
objRS.Addnew
objRS.Fields("SRNAME") = request("field01")
objRS.Fields("MIN") = request("field03")
objRS.Fields("MAX") = request("field04")
objRS.Fields("SHPAMT") = request("field05")
objRS.Fields("SUPER") = request("field07")
objRS.Fields("PRIORITY") = request("field08")
objRS.Fields("SHPMETH") = request("field02")
objRS.Update


response.write objRS("SHPRULEID")

in global.asa
-------------
<SCRIPT LANGUAGE=VBScript RUNAT=Server>

Sub Application_OnStart
        Application("Con_ConnectionString") = "DSN=dsnname;DBQ=d:\database\databasename.mdb;Driv erId=281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"
        Application("Con_ConnectionTimeout") = 15
        Application("Con_CommandTimeout") = 30
        Application("Con_CursorLocation") = 3
        Application("Con_RuntimeUserName") = ""
        Application("Con_RuntimePassword") = ""
End Sub

</SCRIPT>
------------------------------
<%
set cnn=Server.CreateObject("ADODB.Connection")
cnn.Open Application("Con_ConnectionString")
set rs=Server.CreateObject("ADODB.Recordset")
''''select com''''''
sql="SELECT * FROM SHPRULE"
rs.Open sql,cnn,1,3
response.write rs("SHPRULEID")
''''add com''''''''
sql="Insert into SHPRULE(your fields name) values(perticular values)"
cnn.Execute sql
''''update com '''''
same as above
use update command
%>


surendran

Not sure if this is closed out, but try calling the Id field before your update.