ASP的重复判断语句怎么写啊

显示全部楼层 · 2012-3-7 17:19:11

在sql="select user,qq,email,content,data,nr from main"前加入：qq=request.form("qq")qqUse=true'qq没有重复sql="select count(*) as c from main where qq='"&qq&"'"rs.open sql,conn,1,1if not rs.eof then c=rs("c") if c>0 then
qqUse=false end ifend ifrs.close后面跟进qqUse判断吧...

千问 · 2012-3-7 17:19:11

不用这么麻烦.用你的代码就行了,注意这一段改成我的.set rs=server.createobject("adodb.recordset")sql="select user,qq,email,content,data,nr from main"rs.open sql,conn,1,3=================改成.set r...

千问 · 2012-3-7 17:19:11

sql="select user,qq,email,content,data,nr from main where qq = '" & qq & "'"rs.open sql,conn,1,3If rs.EOF=true then rs.addnewendifuser=request.form("user")qq=request....