大家帮忙解决啊 。///

[mmiiaaoo]

我第一也传值到另一页
dim m,n,p,q as string
response.redirect("viewcccard.aspx?m="+textbox1.text+"&n="+dropdownlist1.selecteditem.text+"&p="+dropdownlist2.selecteditem.text+"&q="+dropdownlist3.selecteditem.text)
另一页接受
dim m,n,p,q as string
m=request("m")
n=request("n")
p=request("p")
q=request("q")
response.write(p)


mysql = "select * from user_table where "
mysql1 = "select count(*) as id from user_table where "
if m<>"" then
mysql=mysql & " and cname like '%"+m+"%'"
mysql1=mysql1 & "and cname like '%"+m+"%'"

end if
if n<>全部 then
mysql=mysql & " and suoshuxingye='"+n+"'"
mysql1=mysql1 & " and suoshuxingye='"+n+"'"
end if
if p<>全部 then
mysql=mysql & " and jingyingmoshi='"+p+"'"
mysql1=mysql1 & " and jingyingmoshi='"+p+"'"
end if
if q<>全部 then
mysql=mysql & " and sheng='"+q+"'"
mysql1=mysql1 & " and sheng='"+q+"'"
end if
mysql = mysql & " order by uid desc"
mysql = replace(mysql,"where and","where")
mysql = replace(mysql,"where order","order")

mysql1 = replace(mysql1,"where and","where")
mysql1 = replace(mysql1,"where order","order")


if m="" and n="全部" and p="全部" and q="全部" then
mysql = "select * from user_table order by uid desc"
mysql1 = "select count(*) as id from user_table "
end if

提示我错误
其中的全部是dropdownlist的第一项 表示查询全部
提示错误
全部没有申明
还要申明吗
请大家帮忙啊！！！！！！！！！！！

[mmiiaaoo]

response.wtite(p)是没有的啊

[mmiiaaoo]

其中的mysql是查询用的啊
mysql1是分页是的总数啊

[guoyan19811021]

是不是前页dropdownlist有问题！！

[mmiiaaoo]

那里没有问题啊

[mmiiaaoo]

前页就这一句
我已经写出来了啊

[sumysong]

我来了，呵呵，我是水样年华。恭喜你解决了问题。