查找出了问题！帮帮我！

[1007]

大家帮我看一下　下边的　程序　那里出错！　如果我不选择　条件的话！没有问题 选择了

条件就出错！帮帮忙！　

sql="select * from y_yf where 1=1 order by id desc"

if id<>"" then
sql=sql & " and id=" & id
end if
if ycity<>"不限" then
sql=sql & " and ycity='" & ycity & "'"
end if
if ystyle<>"不限" then
sql=sql & " and ystyle='" & ystyle &"'"
end if
if ymoney<>"不限" then
sql=sql & " and ymoney between " & replace(ymoney,"-"," and ")
end if
if yarea<>"不限" and isnumeric(yarea) then
tmp=cint(yarea)
if tmp>=6 then
sql=sql & " and yarea>=200"
else
sql=sql & " and yarea between " & (tmp-1)*40 & " and " & tmp*40
end if
end if
rs.open sql,cn,3,2
if rs.eof and rs.bof then


————————————

错误提示！
——————————————————————

Microsoft JET Database Engine 错误 '80040e14'

ORDER BY 子句语法错误。

/web_site/new/g_yfcha_ok.asp，行67

[myvicy]

sql_order=" order by id desc"
sql="select * from y_yf where 1=1"

if id<>"" then
sql=sql & " and id=" & id
end if
if ycity<>"不限" then
sql=sql & " and ycity='" & ycity & "'"
end if
if ystyle<>"不限" then
sql=sql & " and ystyle='" & ystyle &"'"
end if
if ymoney<>"不限" then
sql=sql & " and ymoney between " & replace(ymoney,"-"," and ")
end if
if yarea<>"不限" and isnumeric(yarea) then
tmp=cint(yarea)
if tmp>=6 then
sql=sql & " and yarea>=200"
else
sql=sql & " and yarea between " & (tmp-1)*40 & " and " & tmp*40
end if
end if
sql=sql+sql_order
'这里再组合order
rs.open sql,cn,3,2
if rs.eof and rs.bof then

[mayi545]

up

[yestoyes]

学习

[cncca]

order by 不能房在条件后.

[spec_lc]

嗯，order by要放到where的后面
myvicy(在线解决:你的问题我来解决(因为我不会骗人，所以我最) 说的对

[街头小贩]

偶同意: myvicy(在线解决:你的问题我来解决(因为我不会骗人，所以我最)
的作法

[kkkbs]

Up

[1007]

谢谢各位！特别是　"myvicy"

[richwong]

同意楼上