奇怪：select case为什么不成功？

[alexander_lin]

语句如下：
select case session("webmisuserregion")
case "所有"
sqlCust="select * from Customers order by addtime desc"
case "上海"
sqlCust="select * from Customers where region='上海' order by addtime desc"
case else
sqlCust="select * from Customers where region='" & webmisuserregion & "' order by addtime desc"

end select

sql server数据表中region字段的类型为nchar, 值为 上海，武汉，所有 等。。
可我以region="上海"的用户登陆后，输出的sqlCust却为空？ 为什么？

[yonghengdizhen]

简单问题自己多动动脑筋..

学会自己调试..ASP调试就那么三板斧..
Response.Write
Response.End
或设置调试器断点到各分支,是男是女验名正身

[alexander_lin]

老兄，这我知道。。

问题解决了
用Cint(session("webmisuserregion")) 就可以匹配了
但我不知道为什么。。？？

[palmkey]

关键是session("webmisuserregion")的值是不是"上海"

[alexander_lin]

sorry,我没说完整
session("webmisuserregion") 的值是上海

response.write "session webmisuserregion is-"& session（"webmisuserregion")
select case session("webmisuserregion")
case "所有"
sqlCust="select * from Customers order by addtime desc"
case "上海"
sqlCust="select * from Customers where region='上海' order by addtime desc"
case else
sqlCust="select * from Customers where region='" &webmisuserregion & "' order by addtime desc"
end select
response.write "<br>sqlCust is--"&sqlCust

我以region="所有"的用户登陆后，session("webmisuserregion") 输出的是所有。但sqlCust="select * from Customers where region='所有 ' order by addtime desc "??