Microsoft JET Database Engine 错误 标准表达式中数据类型不匹配。

Question

<%
Dim XMID,pages2,xyz

XMID = request("XMID")
pages = request("pages")
pages2 = request("pages2")
xyz= request("xyz")
Dim Rs2
Set Rs2 = oConn.Execute("SELECT top 1 * FROM [ACollect] WHERE ID = "&XMID&"")

数据库里面的XMID是长整型， 给它强制转换过了，Set Rs2 = oConn.Execute("SELECT top 1 * FROM [ACollect] WHERE ID = "&XMID&"") 这里也将ID加过[ ID ]，'"&XMID"'这样也还是错误。

Answer 1

找到啦。。。。哈哈
Set Rs2 = oConn.Execute("SELECT top 1 * FROM [ACollect] WHERE ID = "&cint(XMID))
这样就好啦