嚣张宝贝黑道妈夜焰:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

来源：百度文库编辑：杭州交通信息网时间：2024/04/28 22:26:50

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'id =' 中。
/06/edituserchk.asp, 第 15 行

15行：sql="select * from user where id = "&id&" "

这么简单的一句，我怎么就看不出来错呢？

id是不是为空呀....看看吧...
或者sql="select * from [user] where [id] = "&id&" "
不确定
但是id空的可能性较大

sql="select * from [user] where [id] = "&cint(id)

"&id&" 要用单引号

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)