女系家族1 3百度云:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver]

来源：百度文库 编辑：高校问答 时间：2024/04/29 21:25:51
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'storage_id=' 中

66行 sub GetStorage(cur_storage)
67行 sql="select * from storage where storage_id="&cur_storage
68行 rs.open sql,conn,3,2
69行 if not rs.eof then
70行 response.write "<font color=blue>"&session("username")&"</font> 所在仓库: [ <font color=red>"&rs("storage_name")&"</font> ]"
71行 else
72行 response.write "<font color=blue>"&session("username")&"</font> 所在仓库: [ <font color=red>没有发现仓库（错误）</font> ]"
73行 end if
74行 rs.close
75行 end sub
么高手吗?

cur_storage是空值
你在执行SQL语句前 先做一下判断~
if cur_storage=empty or not isnumeric(cur_storage) then cur_storage=0

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for SQL Server 求救~~ Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Service Components 错误 '8000ffff' Microsoft OLE DB Service Components 错误 '8000ffff' Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F) Microsoft OLE DB Provider for ODBC Drivers (0x80004005)