你可以在你的列表框中的每一个选项的代码中用select case 多项来判断用户的选择来进行计算啊 因为列表框的属性用数组来表示
dim price as string price="100-200" strsql="select * from t where rate between" & replace(price,"-"," and ")
create proc prc_getprice( @var_price varchar(32) ) as begin declare @var_cmd varchar(256) set @var_cmd='select * from t where rate between' + replace(price,'-',' and ') exec @var_cmd end
create proc prc_getprice( @var_price varchar(32) ) as begin declare @var_cmd varchar(256) set @var_cmd='select * from t where rate between' + replace(@var_price ,'-',' and ') exec @var_cmd end
应该把前台的条件建表create table 下拉列表 ( s varchar(20), l int, h int ) goinsert 下拉列表 values ('100-200',100,200) insert 下拉列表 values ('200-400',200,400) ...go这样就好查询了select *,t.s from 数据表 a,下拉列表 t where a.rate between t.l and t.h
price="100-200"
strsql="select * from t where rate between" & replace(price,"-"," and ")
@var_price varchar(32)
) as begin
declare @var_cmd varchar(256)
set @var_cmd='select * from t where rate between' + replace(price,'-',' and ')
exec @var_cmd
end
@var_price varchar(32)
) as begin
declare @var_cmd varchar(256)
set @var_cmd='select * from t where rate between' + replace(@var_price ,'-',' and ')
exec @var_cmd
end
s varchar(20),
l int,
h int
)
goinsert 下拉列表 values ('100-200',100,200)
insert 下拉列表 values ('200-400',200,400)
...go这样就好查询了select *,t.s from 数据表 a,下拉列表 t
where a.rate between t.l and t.h