学生组别有许多ID号,做搜索时
如果学生组别号
if request(stugroupid)='' then
把1,2,3,4,5这五ID赋值给stugroupid
做全部搜索,
请教怎么样把这五个ID赋值给stugroupid,以便做
select * from student where stugroup like '%"&stugroupid&"%' order by id desc
问题点数：10、回复次数：6Top
1 楼ne_rush（）回复于 2006-12-02 09:48:56 得分 5
select * from student where stugroupid becneen 1 and 5 order by id desc
是不是这个？
搜索的是ID1到5之间的
Top
2 楼ne_rush（）回复于 2006-12-02 09:50:10 得分 5
或者
select * from student where stugroupid>=1 and stugroupid<=5 order by id descTop
3 楼makoshen（）回复于 2006-12-02 09:55:41 得分 0
是这样的,组别ID号有34,56,12,67,等等
现在希望是,如果组别ID为某一值时,就搜索这个值的组别学生,
如果组别ID为空的,我希望搜索全部组别的学生Top
4 楼yalan（）回复于 2006-12-03 02:11:32 得分 0
if request("grpid")="" then
sql="select * from student where grpid<>''" '====如果参数id为空那么搜索所有组别id不为空的学生信息===
else
sql="select * from student where grpid="&request("grpid")&""
end ifTop
5 楼rqrq（）回复于 2006-12-03 02:55:51 得分 0
SELECT * FROM student WHERE grpid IN(1,2,3,4,5)Top
6 楼makoshen（）回复于 2006-12-04 14:12:59 得分 0
dim city,sf,anclassid,nclassid,keyword,sql
keyword=request("searchword")
city=request("city")
sf=request("sf")
if anclassid=0 then
sql="article=0 "
else
sql="anclassid="&request("anclassid")&" "
end if
if nclassid=0 then
sql=sql
else
sql=sql&" nclassid="&request("nclassid")&" "
end if
if szshi="" then
sql=sql
else
sql=sql&"szshi="&cstr(city)&" "
end if
if szsheng="" then
sql=sql
else
sql=sql&" szsheng="&cstr(sf)&" "
end if
if keyword="" then
sql="select * from shjia where "&sql&" order by shjiaid desc"
else
sql="select * from shjia where "&sql&" and name like '%"&request("searchword")&"%' order by shjiaid desc"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof thenTop
