Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

Question

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'storage_name=''302仓库''' 中。
/仓库管理系统/all.asp, 第 65 行

all.asp部分代码如下
<%
if request.cookies("guestok")="" then
response.redirect "relogin.asp"
end if
showtitle(title)

sql="select * from storage order by storage_name"
rs.open sql,conn,1,1
dim cangku_list
cangku_list="[ <a href=all.asp>所有仓库</a> "
if not rs.eof then
do while not rs.eof
cangku_list=cangku_list+" | <a href=all.asp?storage_name='"&rs("storage_name")&"'&type_name='"&request("type_name")&"'>"&rs("storage_name")&"</a>"
rs.movenext
loop
else
cangku_list=cangku_list+" | <font color=red>无仓库分类</font>"
end if
cangku_list=cangku_list+" ]"
rs.close
response.write "<b>仓库分类：</b>"+cangku_list&"<hr size=1>"

sql="select * from type order by type_name"
rs.open sql,conn,1,1
cangku_list="[ <a href=all.asp?storage_name='"&request("storage_name")&"'>所有类别</a> "
if not rs.eof then
do while not rs.eof
cangku_list=cangku_list+" | <a href=all.asp?type_name='"&rs("type_name")&"'&storage_name='"&request("storage_name")&"' >"&rs("type_name")&"</a>"
rs.movenext
loop
else
cangku_list=cangku_list+" | <font color=red>无物品分类</font>"
end if
cangku_list=cangku_list+" ]"
rs.close
response.write "<b>物品分类：</b>"+cangku_list

%>
<hr size=1>
<font color=blue>
<%
response.write session("username")&"</font>"
if request("storage_name")="" then
response.write " 查看仓库: [ <font color=red>所有仓库</font> ]"
else
sql="select * from storage where storage_name='"&request("storage_name")&"'"
rs.open sql,conn,3,2（这是第65行）
if not rs.eof then
response.write " 查看仓库: [ <font color=red>"&rs("storage_name")&"</font> ]"
else
response.write " 查看仓库: [ <font color=red>未知仓库</font> ]"
end if
rs.close
end if

if Request("type_name")="" then
response.write " 查看类别: [ <font color=red>所有类别</font> ]"
else
sql="select * from type where type_name='"&Request.querystring("type_name")&"'"

rs.open sql,conn,3,2
if not rs.eof then
response.write " 查看类别: [ <font color=red>"&rs("type_name")&"</font> ]"
else
response.write " 查看类别: [ <font color=red>未知类别</font> ]"
end if
rs.close
end if
%>

Answer 1

你地址栏或者是post传入的值不符合要求.含有引号.

Answer 2

有单引号的时候换成双引号就可以了。单引号需要转义字符。
用string.replace("'","''")，存到数据库里就还是单引号。呵呵