set rs=server.createobject("adodb.recordset")
sql="select * from table1 where aaa= 's' "
rs.open sql,conn,3,3
if rs.recordcount=0 then
rs.addnew
rs("aaa")=s
rs.update
end if
rs.close
...全文
1413打赏收藏
没有该记录才插入怎么实现
我用recordcount判断,结果仍然插入了 set rs=server.createobject("adodb.recordset") sql="select * from table1 where aaa= 's' " rs.open sql,conn,3,3 if rs.recordcount=0 then rs.addnew rs("aaa")=s rs.update end if rs.close