语法错误 (操作符丢失) 在查询表达式 'news_id=' 中。
<%
news_id=trim(request( "news_id "))
set rs=server.CreateObject( "adodb.recordset ")
sql= "select * from news where news_id= " &clng(news_id)
rs.open sql,conn,1,1
if rs.eof then
response.write "错误的ID号 "
rs.close
set rs=nothing
conn.close
set conn = nothing
response.end
eles
%>
提示我错误类型：
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'news_id= ' 中。
请高手指点 '
[解决办法]
<%
news_id=trim(request( "news_id "))
if news_id= " " then news_id=0
set rs=server.CreateObject( "adodb.recordset ")
sql= "select * from news where news_id= " &clng(news_id)
rs.open sql,conn,1,1
if rs.eof then
response.write "错误的ID号 "
rs.close
set rs=nothing
conn.close
set conn = nothing
response.end
eles
%>
