我做一个查询不知道那里错了，请高手帮我指点一下: ------------------------------------------------------------------- qidian=session("qidian") zhongdian=session("zhongdian") session("qidian")=replace(request.Form("qidian"),"'","''") session("zhongdian")=replace(request.Form("zhongdian"),"'","''") if(session("qidian")="") then session("qidian")=qidian session("zhongdian")=zhongdian end if set rec=server.CreateObject("adodb.recordset") rec.open "select * from huowu where (qidian like '%"+session("qidian")+"%' and zhongdian like '%"+session("zhongdian")+"%' and beizhu is null) or (beizhu like'%"+session("qidian")+"%' and beizhu like '%"+session("zhongdian")+"%') order by qidian",conn,1,3 ------------------------------------------------------------------- 就是如果备注(beizhu)字段是空的话选择起点(qidian)和终点(zhongdian)与查询内容一致的记录,否则选择备注(beizhu)字段里面包含(qidian)和(zhongdian)内容的记录. 但是这个查询总是查询不到记录.请高手指点

用这么多次Session，你的程序一定运行得很慢吧！

请不要重复使用同一用Session语句，我宁可使用变量来传递，也比它快得多！

response.write "select * from huowu where (qidian like '%"+session("qidian")+"%' and zhongdian like '%"+session("zhongdian")+"%' and beizhu is null) or (beizhu like'%"+session("qidian")+"%' and beizhu like '%"+session("zhongdian")+"%') order by qidian"

再放到查询分析器中看看