初级问题,相信大家应该都会的!给30分吧!
我刚开始学ASP,写下面一段代码,但运行后提示出错,找不出问题所在,所以请各位高手帮忙了!
代码如:
<%
dbpath=server.mappath("sbgl.mdb")
myDSN="driver={microsoft access driver (*.mdb)};dbq=" & dbpath & ""
set conn=server.createobject("adodb.connection")
conn.open myDSN
zjid=request.form("id")
zjxh=request.form("zjxh")
xsqxh=request.form("xsqxh")
xsqid=request.form("xsqID")
wwsb=request.form("wwsb")
ip=request.form("Ip")
syks=request.form("syks")
syr=request.form("syr")
bz=request.form("bz")
exec="insert into shebei(主机型号,主机ID,显示器型号,显示器ID,设备属性,IP,使用科室,使用人,备注)values('"+zjxh+"','"+zjid+"','"+xsqxh+"','"+xsqid+"','"+wwsb+"','"+ip+"','"+syks+"','"+syr+"','"+bz+"')"
conn execute (exec)
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
错误提示:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft VBScript 编译器错误 错误 '800a0401'
语句未结束
/addrecord.asp,行16