asp update语句

2025-02-25 23:30:44

推荐回答（1个）

回答1：

if bid <>"" and isnumeric(bid) then
stsql="select * from pic where leixing ="&bid&" order by id"
else
if jdkeyword<>"" then
stsql="select * from pic where name like '%"&jdkeyword&"%' order by id"
else
stsql="select * from pic order by id"

修改为：

if bid <>"" and isnumeric(bid) then
stsql="select * from pic where leixing ="&bid&" order by id desc"
else
if jdkeyword<>"" then
stsql="select * from pic where name like '%"&jdkeyword&"%' order by id desc"
else
stsql="select * from pic order by id desc"