将数据类型 varchar 转换为 numeric 时出错 怎么解决 急急急
<%sql= "Select top 1 * From ce_rank where PostingCountMin <= ' "&jifen+SiteSettings( "integralreg ")& " 'order by PostingCountMin Desc "
Set UserRank=Conn.Execute(sql)
if UserRank.eof then
RankName= "未知等级 "
RankIconUrl= "images/level/MemberCode0.gif "
else
RankName=UserRank( "RankName ")
RankIconUrl=UserRank( "RankIconUrl ")
end if
Set UserRank = Nothing %>


[解决办法]
order前面有个空格，加上一个空格

如果不行的话，索性把sql打印出来看看
sql= "Select top 1 * From ce_rank where PostingCountMin <= "&jifen+SiteSettings( "integralreg ")& " order by PostingCountMin Desc "
Response.write sql
Response.end