<%
rq = Now()
jztel=Request.Form("jztel")
pingbi = Request.Form("pingbi")
heimingdan = Request.Form("heimingdan")
mishu=Request.Form("mishu")
if jztel <> "" then
sql="insert into tab1 (受理时间,工号,电话号码,屏蔽的号码明细,黑名单明细,秘书) values ('"&rq&"','"&Session("username")&"','"&jztel&"','"&pingbi&"','"&heimingdan&"','"&mishu&"')"
conn.execute(sql)
Response.Redirect("main.asp")
Response.End()
end if
%>
请帮忙修改,谢谢!
------解决方案--------------------
sql="insert into tab1 (受理时间,工号,电话号码,屏蔽的号码明细,黑名单明细,秘书) values ('"&rq&"','"&Session("username")&"','"&jztel&"','"&pingbi&"','"&heimingdan&"','"&mishu&"')"
response.write sql
response.End
'conn.execute(sql)
'Response.Redirect("main.asp")
'Response.End()
看看sql语句对不对