日期:2014-05-17  浏览次数:20816 次

request.QueryString获取的值怎么转换成数字型?(急)
category = request.QueryString("id")
if category = "" then
categoryid = 45
else
categoryid = cint(category)
end if
Sql="select * from user_news where categoryID="categoryid" order by posttime desc"

这段代码一直报错,把"categoryid"改成数字45就能正常运行

这个Sql到底该怎么写?

------解决方案--------------------
Sql="select * from user_news where categoryID="&categoryid&" order by posttime desc"