服务器asp的Update语句问题(视情况追加分数)

2025-02-23 20:13:06
推荐回答(2个)
回答1:

<%
数据库连接...
dim pa:set pa=conn.execute("select * from [table] where A like '%"&a&"%'")
if pa.eof and pa.bof then
conn.execute("insert into A (a) values('"&a&"')")
else
conn.execute("update A set A='"&a&"'")
end if
pa.close
set pa=nothing
%>

回答2:

sql = "select * from [table] where A like '%"&a&"%"
set rs = server.createobject("ADODB.Recordset")
rs.open sql,conn,3,2
if rs.eof and rs.bof then
rs.addnew
rs("name") = a /*insert */
else
rs("name") = a /*update*/
end if
rs.update
rs.close