主题:求助:语句未结束的问题
下面是向数据库里添加数据的一段
[color=0000FF]<%
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")
exec="insert into guestbook(name,tel,message)values('" name "'," tel ",'" message "')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>[/color]
在服务器上总是出错
说是:
[color=blue]Microsoft VBScript 编译器错误 错误 '800a0401'
语句未结束
/t/example5.asp,行 7
exec="insert into guestbook(name,tel,message)values('" name "'," tel ",'" message "')"
-------------------------------------------------------^[/color]
应该是[color=FF0000]values('" name "'," tel ",'" message "')"[/color]这一段出了问题吧,可是怎么也找不出错误哦,哪位朋友能帮帮偶啊,谢谢了~~~
[color=0000FF]<%
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")
exec="insert into guestbook(name,tel,message)values('" name "'," tel ",'" message "')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>[/color]
在服务器上总是出错
说是:
[color=blue]Microsoft VBScript 编译器错误 错误 '800a0401'
语句未结束
/t/example5.asp,行 7
exec="insert into guestbook(name,tel,message)values('" name "'," tel ",'" message "')"
-------------------------------------------------------^[/color]
应该是[color=FF0000]values('" name "'," tel ",'" message "')"[/color]这一段出了问题吧,可是怎么也找不出错误哦,哪位朋友能帮帮偶啊,谢谢了~~~