我的ASP程序为什么不能将数据添加到数据库？

zgiw 2004-02-10 10:11:05

代码如下：
<%@ language="vbscript" %><%

productid=request.form("productID")
empolderid=request.form("empolderID")
projectman=request.form("projectman")
empolderman=request.form("empolderman")
electricparameter=request.form("electricparameter")
engineparameter=request.form("engineparameter")
applybound=request.form("applybound")
status=request.form("status")
subsequence=request.form("subsequence")
productimage=request.form("productimage")
productdrawing=request.form("productdrawing")
if productid="" then
response.write "产品型号不能为空，请输入产品型号"
response.end
end if
if empolderid="" then
response.write "开发单号不能为空，请输入开发单号"
response.end
end if
if projectman="" then
response.write "负责人不能为空，请重新输入"
response.end
end if
if empolderman="" then
response.write "开发负责人不能空，请重新输入"
response.end
end if

%>
<html>
<body>
<% set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq=" & server.mappath("..\database\comax.mdb")
sql="select * from newproduct "
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
rs.addnew
rs("productid")=productid
rs("empolderid")=empolderid
rs("projectman")=projectman
rs("empolderman")=empolderman
rs("electricparameter")=electricparameter
rs("engineparameter")=engineparameter
rs("applybound")=applybound
rs("status")=status
rs("subsequence")=subsequence
rs("productimage")=productimage
rs("productdrawing")=productdrawing

rs.update
rs.close
response.write "成功输入"
%></body></html>
在上一个表单页面中按提交后就调用这个程序来添加新数据到数据库中，但现在在调用这个程序后一直停在这个ASP的页面中没反应，这是什么错误？

...全文