request and session question! thanks

[99percent]

Set rstobj = Server.CreateObject ("ADODB.Recordset")
if request("t0")<>"0" and request("t1")<>"" and request("t2")<>"" and request("t3")<>"" then
session("t0")=request("t0")
session("t1")=request("t1")
session("t2")=request("t2")
session("t3")=request("t3")
abc="select * from produce_brand where(producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%' and 颜色 like '%" & Trim(session("t3")) & "%' and brand like '%" & Trim(session("t1")) & "%')"
end if
if request("t0")<>"0" and request("t1")="" and request("t2")<>"" and request("t3")="" then
session("t0")=request("t0")
session("t2")=request("t2")
abc="select * from produce_brand where producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%') "
end if
rstobj.open abc,cnndb,3,1
为什么不行啊？
如果我将最后的if条件部分全删除就行如果不是的话rstobj.open abc,cnndb,3,1话有问题搞了很久请教。
如果不用这种方法那么我用or来表示这两种条件怎么联起来？
先谢。

[arclala]

abc="select * from produce_brand where (producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%') "

你最好将你的sql语句response.write 出来看看

[99percent]

who can help me look about!!!

[flyinweb]

同意楼上的,跟踪一下SQL语句,看有无错误

[99percent]

哦好象都有错啊。
那怎么改啊？

[99percent]

abc="select * from produce_brand where producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%'"
这句我多了一边括号现在省去也是这样。

[laughingrat]

将你的request("t0")、request("t1")、request("t2")、request("t3")和
sql都用response.write写出来，看一下是否符合。

另外可以用trim（）将空格去掉。

[99percent]

Set rstobj = Server.CreateObject ("ADODB.Recordset")
if request("t0")<>"0" and request("t1")<>"" and request("t2")<>"" and request("t3")<>"" then
session("t0")=request("t0")
session("t1")=request("t1")
session("t2")=request("t2")
session("t3")=request("t3")
abc="select * from produce_brand where producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%' and 颜色 like '%" & Trim(session("t3")) & "%' and brand like '%" & Trim(session("t1")) & "%'"
response.write abc
response.end
end if
if request("t0")<>"0" and request("t1")="" and request("t2")<>"" and request("t3")="" then
session("t0")=request("t0")
session("t2")=request("t2")
abc="select * from produce_brand where producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%') "
response.write abc
response.end
end if
------------------------------------------------------
每一句都能response.write出来

如果我去掉了
response.write abc
response.end
它说：

rstobj.open abc,cnndb,3,1
出错
why???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????/>

[iperfect]

Set rstobj = Server.CreateObject ("ADODB.Recordset")
if request("t0")<>"0" and request("t1")<>"" and request("t2")<>"" and request("t3")<>"" then
session("t0")=request("t0")
session("t1")=request("t1")
session("t2")=request("t2")
session("t3")=request("t3")
abc="select * from produce_brand where producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%' and 颜色 like '%" & Trim(session("t3")) & "%' and brand like '%" & Trim(session("t1")) & "%'"
rstobj.open abc,cnndb,3,1
end if
你试试这样行不行!

[iperfect]

Set rstobj = Server.CreateObject ("ADODB.Recordset")
if request("t0")<>"0" and request("t1")<>"" and request("t2")<>"" and request("t3")<>"" then
session("t0")=request("t0")
session("t1")=request("t1")
session("t2")=request("t2")
session("t3")=request("t3")
abc="select * from produce_brand where(producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%' and 颜色 like '%" & Trim(session("t3")) & "%' and brand like '%" & Trim(session("t1")) & "%')"
rstobj.open abc,cnndb,3,1
elseif request("t0")<>"0" and request("t1")="" and request("t2")<>"" and request("t3")="" then
session("t0")=request("t0")
session("t2")=request("t2")
abc="select * from produce_brand where producesort='"& session("t0")&"' and 规格 like '%" & Trim(session("t2")) & "%') "
rstobj.open abc,cnndb,3,1
else
response.write abc
response.end
end if