sqlstr="insert into Facultyman(facultyManName,facultyManName2,faculty,subject,suosu1,suosu2,suosu3,zhichen,TEL,FAX,mail,URL,field,study1,
study2,study3,study4,study5)values('"&name1&"','"&name2&"','"&faculty&"','"&subject&"','"&suosu1&"','"&suosu2&"','"&suosu3&"','"&zhichen&"','"&tel&"','"&fax&"','"&mail&"','"&url&"','"&fie&"','"&study1&"','"&study2&"','"&study3&"','"&study4&"','"&study5&"')"
rs.open sqlstr,conn,1,1
set rs=nothing
response.Write("<script language='javascript'>alert('添加成功!');location.href='facultycheck.asp';</script>") 错误类型 Microsoft VBScript 编译器错误 (0s800A0409) 未结束的字符串常量(提示的就是insert into 那)
study2,study3,study4,study5)values('"&name1&"','"&name2&"','"&faculty&"','"&subject&"','"&suosu1&"','"&suosu2&"','"&suosu3&"','"&zhichen&"','"&tel&"','"&fax&"','"&mail&"','"&url&"','"&fie&"','"&study1&"','"&study2&"','"&study3&"','"&study4&"','"&study5&"')"
rs.open sqlstr,conn,1,1
set rs=nothing
response.Write("<script language='javascript'>alert('添加成功!');location.href='facultycheck.asp';</script>") 错误类型 Microsoft VBScript 编译器错误 (0s800A0409) 未结束的字符串常量(提示的就是insert into 那)
"study2,study3,study4,study5)values('"&name1&"','"&name2&"','"&faculty&"','"&subject&"','"&suosu1&"','"&suosu2&"','"&suosu3&"','"&zhichen&"','"&tel&"','"&fax&"','"&mail&"','"&url&"','"&fie&"','"&study1&"','"&study2&"','"&study3&"','"&study4&"','"&study5&"')"
写到一行上来!
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html