<body> 先建立一个表单: <form name="form1" method="post" action="example5.asp"> name <input type="text" name="name"><br> tel <input type="text" name="tel"><br> message <input type="text" name="message" value=""><br> <input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" value="重置"> </form> 表单提交到example5.asp,下面是example5.asp的代码: <% set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb") name=request.form("name") tel=request.form("tel") message=request.form("message") exe="insert into guestbook(name,tel,message) values('"+name+"',"+tel+",'"+message+"')" conn.Execute(exe) conn.close set conn=nothing response.write "记录添加成功!" %> </body>
题示错误是
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/post/example5.asp,行26
请高手指点,谢谢了