源码:
<!--#include file="conn.asp" -->
<%
set rs=server.createobject("adodb.recordset")
id1=request("id")
if request("text1")="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('请输入学号!');" & "history.back()" & "</script>"
Response.End
end if
number=request("text1")
name=request("text2")
testnumber=request("text3")
idnumber=request("text4")
sex=request("text5")
time0=request("text6")
city=request("text7")
area=request("text8")
address=request("text9")
postcode=request("text10")
homephone=request("text11")
bedroomphone=request("text12")
mobilephoe=request("text13")
major=request("text14")
class0=request("text15")
collogetestach=request("text16")
rp=request("text17")
info=request("text18")
sql="update st_info set user_number='"&number&"',user_name='"&name&"',user_testnumber='"&testnumber&"',user_idnumber='"&idnumber&"',user_sex='"&sex&"',user_time='"&time0&"',user_city='"&city&"',user_area='"&area&"',user_address='"&address&"',user_postcode='"&postcode&"',user_homehpone='"&homephone&"',user_bedroomphone='"&bedroomphone&"',user_mobilephoe='"&mobilephoe&"',user_major='"&major&"',user_class='"&class0&"',user_collogetestach='"&collogetestach&"',user_rp='"&rp&"',user_info='"&info&"' where id="+id1
rs.Open sql,conn,1,3
response.write "<script language=JavaScript>" & chr(13) & "alert('记录信息修改成功!');"&"window.location.href = 'add_manager.asp'"&" </script>"
set rs=nothing
%>
提示错误:
rs.Open sql,conn,1,3
response.write "
<SCRIPT language=JavaScript>"
\" & chr(13) & \"alert('记录信息修改成功!');\"&\"window.location.href = 'add_manager.asp'\"&\"
</script>
set rs=nothing
[0]Script error detected at line 39,col[0].
Description: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。