|
对于access和Sql server 数据库下面方法可以得到刚刚插入记录的自动编号值 得到刚刚插入的记录的自动编号值 dim connrs set conn=ServerCreateObject(ADODBConnection) connOpen Provider=MicrosoftJetOLEDB;Jet OLEDB:Database Password=;Data Source= & ServerMapPath(windowsmdb) set rs=ServerCreateObject(ADODBRecordset) sql=select * from [table] where ID is null 自动编号字段为id rsopen sqlconn rsaddnew rs(Name) = Requestform(Name) rs(Name) = Requestform(Name) rsupdate responsewrite ID值<strong color:red;> & rs(ID) & </strong> 得刚刚插入记录的自动编号的值 rsclose set rs = nothing connclose set conn = nothing |
