Question

asp问题 语法错误 (操作符丢失) 在查询表达式 'F_ID=' 中。

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'F_ID=' 中。
/News/ShowNews.asp, 第 9 行

下面是代码：
<%
m_ID = Request.Querystring("ID")
m_SQL = "SELECT F_Title,F_Contents,F_Image,F_Addtime,F_Hits,F_CategoryID FROM T_News where F_ID="&m_ID //这行出错
Set rs = conn.Execute(m_SQL)
If Not rs.Eof then
m_Title = Trim(rs(0))

我查了一下改来改去还是不行？是什么原因呢

Answer 1

m_ID = Request.Querystring("ID")
response.write m_ID
response.end

应该是ID参数没传递过来，加这两行调试看m_ID有没有输出。

Answer 2

m_SQL = "SELECT F_Title,F_Contents,F_Image,F_Addtime,F_Hits,F_CategoryID FROM T_News where F_ID="&m_ID
把这可改成
m_SQL = "SELECT F_Title,F_Contents,F_Image,F_Addtime,F_Hits,F_CategoryID FROM T_News where F_ID='"&m_ID&"'"
这样试试看

Answer 3

m_SQL = "SELECT F_Title,F_Contents,F_Image,F_Addtime,F_Hits,F_CategoryID FROM T_News where F_ID="&m_ID
改为
m_SQL = "SELECT F_Title,F_Contents,F_Image,F_Addtime,F_Hits,F_CategoryID FROM T_News where F_ID='"&m_ID

Answer 4

m_SQL = "SELECT F_Title,F_Contents,F_Image,F_Addtime,F_Hits,F_CategoryID FROM T_News where F_ID="&m_ID
改为这个
m_SQL = "SELECT F_Title,F_Contents,F_Image,F_Addtime,F_Hits,F_CategoryID FROM T_News where F_ID='"&m_ID

Answer 5

m_SQL = "SELECT