exce="select * from gyxx "
Set rs2 = Server.CreateObject("ADODB.RecordSet")
rs2.Open exce,conn,1,3
rs2.addnew
rs2("q1")=server.HTMLEncode(request.form("q1"))
rs2("q2")=server.HTMLEncode(request.form("q2"))
rs2("q3")=server.HTMLEncode(request.form("q3"))
rs2("q4")=server.HTMLEncode(request.form("q4"))
rs2("q33")=server.HTMLEncode(request.form("q33"))
rs2("q44")=server.HTMLEncode(request.form("q44"))
rs2("q5")=cint(request.form("q5"))
rs2("q6")=server.HTMLEncode(request.form("q6"))
rs2("q7")=server.HTMLEncode(request.form("q7"))
if len(request.form("q7"))>0 then
rs2("imgyesno")=1
else
rs2("imgyesno")=0
end if
rs2("q8")=server.HTMLEncode(request.form("q8"))
'rs2("q9")=server.HTMLEncode(request.form("q9"))
rs2("q10")=server.HTMLEncode(request.form("q10"))
rs2("q11")=server.HTMLEncode(request.form("q11"))
rs2("q12")=server.HTMLEncode(request.form("q12"))
rs2("username")=server.HTMLEncode(request.form("user"))
rs2.update
rs2.close
set rs2=nothing
conn.close
set conn=nothing
exce9="select * from test "
Set rs9 = Server.CreateObject("ADODB.RecordSet")
rs9.Open exce9,conn,1,3
rs9.addnew
rs9("lxrname")=server.HTMLEncode(request.form("lxrname"))
rs9("usertel")=server.HTMLEncode(request.form("usertel"))
rs9("phone")=server.HTMLEncode(request.form("phone"))
rs9("xxid")=server.HTMLEncode(request.form("q44"))
rs9("qq")=server.HTMLEncode(request.form("qq"))
rs9("mail")=server.HTMLEncode(request.form("mail"))
rs9("dizhi")=server.HTMLEncode(request.form("dizhi"))
rs9("ip")=Request.ServerVariables("HTTP_X_FORWARDED_FOR")
rs9("user")=server.HTMLEncode(request.form("user"))
rs9.update
rs9.close
set rs9=nothing
conn.close
set conn=nothing
session("xg")="yes"
response.redirect Request.ServerVariables("HTTP_REFERER")
2个exce只保留任意一个都可以发布成功,但是放到一起就出错了,请帮忙解决下谢谢啦!