问一下sql语法的问题？

[xfyz]

sql="select * from route where oldprice < '"+replace(result_oldprice,"'","''")+"' order by routeid"

在查询中，我想从数据库中，显示比result_oldprice低的价格的所有记录，该怎么写呢？谢谢

[ChinaOk]

sql="select * from route where oldprice < "+replace(result_oldprice,"'","''")+" order by routeid"
oldprice是什么类型？

http://www.hqtcn.com
Sql语法

[xfyz]

数字！

[ChinaOk]

数字类型就不用再replace了。
因为如果含有'那就输入错误了。

sql="select * from route where oldprice < "+result_oldprice+" order by routeid"

[cmsoft]

字段类型与输入数据类型不配

[superauu]

sql="select * from route where oldprice < " & cint(result_oldprice) & " order by routeid"

[chonboy]

你必须保证比较的数据是数字，否则别执行这条语句。

[shadowkiss]

类型自己要清楚才行

[spgoal]

oldprice=clng(replace(result_oldprice,"'","''"))
sql="select * from route where oldprice < "+oldprice+" order by routeid"