下面是我的代码,为什么每次写进去的都是true啊,大家帮忙看一下啊
sql1="select email from book where email="&trim(request(SenderEmail))
rs.open sql1,conn,1,3
if not(rs.bof and rs.eof)then
rs("Title")="true"
else rs("Title")="false"
end if
...全文
25621打赏收藏
数据写入问题
下面是我的代码,为什么每次写进去的都是true啊,大家帮忙看一下啊 sql1="select email from book where email="&trim(request(SenderEmail)) rs.open sql1,conn,1,3 if not(rs.bof and rs.eof)then rs("Title")="true" else rs("Title")="false" end if
set rs=server.CreateObject("adodb.recordset")
set rs1=server.CreateObject("adodb.recordset")
rs.open"select * from book ",conn,1,3
rs.addnew
dim SenderEmail
SenderEmail=trim(request.Form("SenderEmail"))
sql1="select email from book where email="&trim(request("SenderEmail"))
rs1.open sql1,conn,1,3
if not(rs1.bof and rs1.eof)then
rs("Title")="true"
else rs("Title")="false"
end if
rs("Somane")=Somane
rs("email")=email
rs("content")=content
rs("Comane")=Product_Id
rs("time")=now()
rs("q1")=q1
rs("q2")=q2
rs("Country")=Country
rs("Phone")=member
rs.update
set rs=server.CreateObject("adodb.recordset")
rs.open"select * from book ",conn,1,3
rs.addnew
dim SenderEmail
SenderEmail=trim(request.Form("SenderEmail"))
sql1="select email from book where email="&trim(request("SenderEmail"))
rs.open sql1,conn,1,3
if not(rs.bof and rs.eof)then
rs("Title")="true"
else rs("Title")="false"
end if
rs("Somane")=Somane
rs("email")=email
rs("content")=content
rs("Comane")=Product_Id
rs("time")=now()
rs("q1")=q1
rs("q2")=q2
rs("Country")=Country
rs("Phone")=member
rs.update
这是我要写入数据库的完整代码,不知道这样是不是不行啊
重看一次.发现.
sql1="select email,title from book where email='"&trim(request("SenderEmail"))&"'"
rs.open sql1,conn,1,3
if not(rs.bof and rs.eof) then
rs("Title")=true
else
rs("Title")=false
end if
rs.update
rs.close
sql1="select email from book where email='"&trim(request("SenderEmail"))&"'"
rs.open sql1,conn,1,3
if not(rs.bof and rs.eof) then
rs("Title")=true
else
rs("Title")=false
end if
rs.update
rs.close
sql1="select email from book where email='"&trim(request(SenderEmail))&"'"
rs.open sql1,conn,1,3
if not(rs.bof and rs.eof) then
rs("Title")=true
else
rs("Title")=false
end if
rs.update
rs.close
set rs = conn.execute(sql1="select email from book where email= '" & SenderEmail & "'")
if not(rs.eof or rs.bof) then
response.write "有"
else
respnse.write "没有"
end if
sql1="select email from book where email= '" & SenderEmail & "'"
rs.open sql1,conn,1,3
if not(rs.bof and rs.eof)then
rs("Title")="true"
else
rs("Title")="false"
end if