很菜的一个问题,但是做不出不能回家睡觉!
<%
if Request.Form("sub")<>"" then
audienceCompany=cstr(trim(Request.Form("audience_company")))
audienceName=cstr(trim(Request.Form("audience_name")))
audienceTitle=cstr(trim(Request.Form("audience_title")))
audienceTel=cstr(trim(Request.Form("audience_tel")))
audienceFax=cstr(trim(Request.Form("audience_fax")))
audienceAddress=cstr(trim(Request.Form("audience_address")))
audiencePostNo=cstr(trim(Request.Form("audience_postNo")))
audienceNature=cstr(trim(Request.Form("audienceNature")))
audienceProduct=cstr(trim(Request.Form("audienceProduct")))
audienceDemo=cstr(trim(Request.Form("audience_demo")))
set rs=server.CreateObject("adodb.recordset")
rs="insert into "&sndApplyAudience&" (此表名已经在CONFIG中定义成了一个变量)(audienceCompany,audienceName,audienceTitle,audienceTel,audienceFax,audienceAdress,audiencePostNo,audienceNature,audienceProduct,audienceDemo,audienceDate) values('"&audienceCompany&"','"&audienceName&"','"&audienceTitle&"','"&audienceTel&"','"&audienceFax&"','"&audienceAddress&"','"&audiencePostNo&"','"&audienceNature&"','"&audienceProduct&"','"&audienceDemo&"','"&now()&"')"
rs.Open s,conn,3,2,1
if Err.number=0 then
%>
<script language="javascript">
alert("您的专业观众申请已经提交!");
window.location.href="index.asp"
</script>
<%
end if
end if
%>
没有提示任何语法错误,但是不能向数据库提交
完不成就不能回家睡觉!救命啊!