请帮我看下这段代码为什么不能取得值？
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 "