语句结构问题
ewai 2003-08-22 04:15:32 <%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("new/data/ewai.asp")
buyao=request.form("buyao")
comment=request.form("comment")
strsql="select * from user1 where comment='"&comment&"'"
set rs=server.createobject("adodb.recordset")
rs.open strsql,conn,3,3
if rs.RecordCount>0 and buyao=("订阅") then
%>
<strong><font color="#FF0000"> 此邮箱已经订阅此项服务!! </font> </strong>
<%
response.end
else
set rs1=server.CreateObject("adodb.recordset")
sql1="select * from user1 where comment='"&comment&"'"
rs1.open sql1,conn,3,3
if rs1.RecordCount>0 and buyao=("取消") then
rs("buyao")=buyao
rs.update
end if
else **********加了这个出问题********
sql="insert into user1(comment,buyao)values('"+comment+"','"+buyao+"') "
conn.execute sql
end if
%>
结构哪错了?