怎么用ASP程序从Access数据库中搜索满足两个条件的内容?

lishiguang 发布于 2008-04-02 09:44， 1654 次点击

请教一下高手.
怎么用ASP程序从Access数据库中搜索满足两个条件的内容?
比如:NAME=lishiguang 的同时以升序或降序显示所有满足条件的内容.
那位高手帮帮我~~~~

9 回复

Kettyjin19832008-04-02 11:00

select * from biao where name = "lishiguang " order by id desc
不行吗?

skybirdzw2008-04-02 11:04

select * from biao where name = "lishiguang " order by id desc

lishiguang2008-04-03 19:25

各位高手们的方法我试过了.不行啊.有没有别的办法呀?
请赐教~~~~~~~~~~~

lishiguang2008-04-03 19:30

"select * from biao order by id desc where id="&ids
有里有什么问提呀?请赐教~~~~~~~~~~~

skybirdzw2008-04-03 20:55

select * from biao where id="&ids&" order by id desc "

zl芊芊zl2008-04-03 21:42

select * from biao where name ='"&ids&" ' order by id desc

skybirdzw2008-04-03 22:00

ids这里如果是数值的话就不用加单引号

lishiguang2008-04-10 15:23

谢谢各位高手.我平时要上班,很忙.所以
很抱歉不能及时回复你们的指导.
谢谢，谢谢各位高手．我这就去试试你们教的方法．

#10

lishiguang2008-04-14 09:32

谢谢各位高手们.我的问提解决了．
谢谢各位了．