UC知道asp查询access数据库时加order by后不能返回数据?
来源：百度知道 编辑：UC知道 时间：2024/05/18 08:50:10
sql= "select * from abc where abc_key=1 and abc_key1=1 and abc_key2=1 and (abc_title like '%"&word&"%') or (abc_content like '%"&word&"%')"
这样能正常返回结果
sql= "select * from abc where abc_key=1 and abc_key1=1 and abc_key2=1 and (abc_title like '%"&word&"%') or (abc_content like '%"&word&"%') order by abc_id"
加了order by后返回的结果始终是空,请高手帮忙看看
感谢各位，上面几种我都一一试过了，还是一样，abc_id值也正常，这个字段是唯一序列字段
sql= "select * from abc where abc_key=1 and abc_key1=1 and abc_key2=1 and ((abc_title like '*"&word&"*') or (abc_content like '*"&word&"*')) order by abc_id"
-----------------------------------------
我记得Access中，like不能用%,要用*
sql= "select * from abc where abc_key=1 and abc_key1=1 and abc_key2=1 and (abc_title like '*"&word&"*') or (abc_content like '*"&word&"*') order by abc_id"
sql= "select * from abc where abc_key=1 and abc_key1=1 and abc_key2=1 and ((abc_title like '%"&word&"%') or (abc_content like '%"&word&"%')) order by abc_id"
这样看看吧。
order by abc_id desc//按abc_id的降序排列
order by abc_id asc //按abc_id的升序排列
sql= "select * from abc where abc_key=1 and abc_key1=1 and abc_key2=1 and (abc_title like '%"&word&"%') or (abc_content like '%"&word&"%')"
这