多条件SQL查询语句中,怎样去掉多余的"order by"

一.程序
A=request.form("A")
B=request.form("B")
C=request.form("C")
D=request.form("D")

sql="Select * from DB where kind=1"
if A<>"" then sql=sql&" and A like '%"&A&"%' order by Date desc"
if B<>"" then sql=sql&" and B='"&B&"' order by Date desc"
if C<>"" then sql=sql&" and C=#"&C&"# order by Date desc"
if D<>"" then sql=sql&" and D=#"&D&"# order by Date desc"

rs.open sql,conn,1,1
二.问题
上述语句中,单个条件查询可以正常运行,但是当条件两个以上不为空时,就查不到数据了,
三,请好心朋友帮忙解决,谢谢!

A=request.form("A")
B=request.form("B")
C=request.form("C")
D=request.form("D")

sql="Select * from DB where kind=1"
if A<>"" then sql=sql &" and A like '%"& A &"%' "
if B<>"" then sql= sql &" and B='" & B & "'"
if C<>"" then sql= sql &" and C=#" & C & "# "
if D<>"" then sql= sql &" and D=#" & D & "# "
sql=sql & " order by Date desc"

rs.open sql,conn,1,1

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息