0$房天下问答|数据库查询后出错$https://m.fang.com/ask/ask_1502933.html$https://static.soufunimg.com/common_m/m_public/201511/images/asksharedefault.png
packc/pages/ask/detail/detail?askid=1502933
-
数据库查询后出错
Shape = request("Shape")sql = "select * from drill "if Shape <> "" thensql = sql &"and Shape in ("&Shape&") "end ifsql = sql &"order by ID desc"Set Rs1 = Server.CreateObject("Adodb.RecordSet")Rs1.Open sql,conn,1,1上面的是源代码Shape是从复选框里面读出来的。提示Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)ODBC 驱动程序不支持所需的属性。数据库里的Shape是文本,应该是字符串格式,可能是类型不匹配。大大们帮帮忙吧!真不知道怎么办了。
更多
共1个回答
-
-
-
wz527463
丨Lv 4
Shape = request("Shape")sql = "select * from drill "if Shape <> "" thensql = sql &"and Shape in ('"&Shape&"') "end ifsql = sql &"order by ID desc"Set Rs1 = Server.CreateObject("Adodb.RecordSet")Rs1.Open sql,conn,1,1
免责声明:问答内容均来源于互联网用户,房天下对其内容不负责任,如有版权或其他问题可以联系房天下进行删除。

关注成功