语法错误 (操作符丢失) 在查询表达式 '''ii''' 中。

[zhangvi111]

运行时出现以下错误：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '''ii''' 中。

/gform2.asp，行 23
该行为：
conn.execute "insert into guestbook (name,email,subject,memo) values('"&sqlstr(name) &"','"&sqlstr(email)&"','"&sqlstr(subject)&"','"&sqlstr(memo)&"')"
以下为完整的代码：
<%
dim name
dim email
dim subject
dim memo
function sqlstr(data)
sqlstr="'"&replace(data,"'","''")&"'"
end function

name=request.form("name")
email=request.form("email")
subject=request.form("subject")
memo=request.form("memo")

name=trim(name)
email=trim(email)
subject=trim(subject)

set conn=server.createobject("adodb.connection")
dbpath=server.mappath("gbook.mdb")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&dbpath
conn.execute "insert into guestbook (name,email,subject,memo) values('"&sqlstr(name) &"','"&sqlstr(email)&"','"&sqlstr(subject)&"','"&sqlstr(memo)&"')"
conn.close
set conn=nothing
response.write "success!<a href=""gform.htm"">返回</a>"
%>

[叮咚叮咚叮叮咚]

conn.execute "insert into guestbook (name,email,subject,memo) values('"&sqlstr(name) &"','"&sqlstr(email)&"','"&sqlstr(subject)&"','"&sqlstr(memo)&"')"

sqlstr是个什么样的函数?response.write "insert into guestbook (name,email,subject,memo) values('"&sqlstr(name) &"','"&sqlstr(email)&"','"&sqlstr(subject)&"','"&sqlstr(memo)&"')"这个看看是否正确
一般出这错误应该是没有取得值好像,你的values和(之间应该空一个空格
"insert into guestbook (name,email,subject,memo) values ('"&sqlstr(name) &"','"&sqlstr(email)&"','"&sqlstr(subject)&"','"&sqlstr(memo)&"')"

[SaySorry]

response.write "driver={microsoft access driver (*.mdb)};dbq="&dbpath
conn.execute "insert into guestbook (name,email,subject,memo) values('"&sqlstr(name) &"','"&sqlstr(email)&"','"&sqlstr(subject)&"','"&sqlstr(memo)&"')"
response.end
自己调一下看看语句

[woodywjl]

你这样写的话，如果某个变量里边有'那么替换为“之后整个sql字符串就提前结束了，或许你应该试一试其他的方法，但愿没有误导你:)

[叮咚叮咚叮叮咚]

没有出现ii阿

[zhangvi111]

ii 是我在表单中输入的。为了测试，我把name,email,subject,memo 全输入ii。以上错误就是这样产生的。