names=Split(session("city"),"|")
i=0
set rs=server.createobject("adodb.recordset")
sql="select * from qizu where sf like '%"&session("sf")&"%' and recycle=1 and("
for each name in names
sql=sql+"City like '%"&names(i)&"%' or "
i=i+1
sql=left(sql,len(sql)-4) &") order by id desc"
i=0
set rs=server.createobject("adodb.recordset")
sql="select * from qizu where sf like '%"&session("sf")&"%' and recycle=1 and("
for each name in names
sql=sql+"City like '%"&names(i)&"%' or "
i=i+1
sql=left(sql,len(sql)-4) &") order by id desc"
我又改了一下代码,把那去了or的条件先变成变量hao但再括号中我又不知道如何放hao这个变量,再请求邹建老师。
<%
names=Split(session("city"),"|")
i=0
for each name in names
hao=hao&"City like '%"&names(i)&"%' or "
i=i+1
next
hao=left(hao,len(hao)-4)
set rs=server.createobject("adodb.recordset")
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
sql="select * from qyhy_1798 where sf like '%"&session("sf")&"%' and recycle=1 and ( hao )"
sql=sql &"order by id desc"我这个是一个分页程序
i=0
set rs=server.createobject("adodb.recordset")
sql="select * from qizu where sf like '%"&session("sf")&"%' and recycle=1 and("
for each name in names
sql=sql+"City like '%"&names(i)&"%' or "
i=i+1
next
sql=left(sql,len(sql)-4) &") order by id desc"我这样处理程序会出现错误!
for each name in names
sql=sql+"City like '%"&names(i)&"%' or "
i=i+1
next
sql=left(sql,len(sql)-4) &") order by id desc"
1、如果你不用like + 通配符的话
可以这样
a = repleace(session("city"),"|",",") '将“|”替换成“,”
select * from qizu where sf like '%广东%' and recycle=1 and city in("&a&")2、有通配符的话参照楼上的我建议可以这样修改
sql="select * from qizu where sf like '%"&session("sf")&"%' and recycle=1 and(1=1"
for each name in names
sql = sql & " or City like '%"&names(i)&"%'"
i = i + 1
next
sql=sql &") order by id desc"修改的目的可以避免最后的去掉"or"
不知道如何!
sql="select * from qizu where sf like '%"&session("sf")&"%' and recycle=1 and(1=1"
for each name in names
sql = sql & " or City like '%"&names(i)&"%'"
i = i + 1
next
sql=sql &") order by id desc"修改的目的可以避免最后的去掉"or"
这样好像不行吧!