请帮我看下这段代码为什么不能取得值？
Dim city,pingyin
Set rs_s=Server.CreateObject( "Adodb.RecordSet ")
sql= "select top 1 pinyin,city from city_py where "&ip_city& "=city order by id desc "
rs_s.open sql,conn,1,1
if rs_s.eof then
pinyin= "bj "
city= "北京 "
else
pinyin=rs_s(0)
city=rs_s(1)
end if
说明：ip_city已经测试可取得值， <%=ip_city%> 得到的结果是有值得；现在的情况是如上这段代码不能取得值，每次都是空，pinyin的值取得的是在空的情况下所赋的bj，很是纳闷，请大家指点下！ip_city和city的值都为中文，字段为文本属性。
[解决办法]
sql= "select top 1 pinyin,city from city_py where city= ' "&ip_city& " ' order by id desc "
[解决办法]
city如不是int的改成如下
' "&ip_city& " '=city
[解决办法]
sql= "select top 1 pinyin,city from city_py where city= ' "&ip_city& " ' order by id desc "
' ' 'sql= "select top 1 pinyin,city from city_py where trim(city)= ' "&trim(ip_city)& " ' order by id desc "
[解决办法]
如果字段是city的话
sql= "select top 1 pinyin,city from city_py where "&ip_city& "= 'city ' order by id desc "
否则的话可能是
sql= "select top 1 pinyin,city from city_py where "&ip_city& "= 'city ' order by id desc "
