大家帮忙解决啊 。///
我第一也传值到另一页
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的第一项 表示查询全部
提示错误
全部没有申明
还要申明吗
请大家帮忙啊!!!!!!!!!!!