names=Split(session("city"),"|")i=0
条件中带又带多个or 查询语句
sql="select * from qizu where 字段 like ''''%"&session("字段")&"%'''' and recycle=1 and("for each name in namessql=sql+"City like ''''%"&names(i)&"%'''' or "i=i+1nextsql=left(sql,len(sql)-4) &") order by id desc"
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18