Question

asp中准备插入多条记录，结果变成一条记录了！紧急求救

sqljl="select * from kaohejilu "
set rsjl= Server.CreateObject("adodb.recordset")
rsjl.open sqljl,conn,1,3
if rsjl.bof and rsjl.eof then
rsjl.addnew
rsjl("userid")=id
rsjl("timuid")=timuid
rsjl("leibie")="kao"
rsjl("nianfen")=year(now)
rsjl("yuefen")=month(now)
rsjl("riqi")=day(now)
rsjl("xzfen")=xzfen
rsjl("beizhu")=beizhu
rsjl.update
else
rsjl("userid")=id
rsjl("timuid")=timuid
rsjl("leibie")="kao"
rsjl("nianfen")=year(now)
rsjl("yuefen")=month(now)
rsjl("riqi")=day(now)
rsjl("xzfen")=xzfen
rsjl("beizhu")=beizhu
rsjl.update
end if
rsjl.close
set rsjl=nothing

Answer 1

sqljl="select * from kaohejilu "
set rsjl= Server.CreateObject("adodb.recordset")
rsjl.open sqljl,conn,1,3
rsjl.addnew
rsjl("userid")=id
rsjl("timuid")=timuid
rsjl("leibie")="kao"
rsjl("nianfen")=year(now)
rsjl("yuefen")=month(now)
rsjl("riqi")=day(now)
rsjl("xzfen")=xzfen
rsjl("beizhu")=beizhu
rsjl.update
rsjl.close
set rsjl=nothing

这样你的目的就达到了