这样order by 都会出错？

[mchowie]

exec="select * from article where claz="&request.querystring("claz") order by time desc

提示：
错误类型：
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束

[zming]

如果 request.querystring("claz") 是字符串，则

exec="select * from article where claz='" & request.querystring("claz") & "' order by [time] desc" 

如果 request.querystring("claz") 是整数，则

exec="select * from article where claz=" & request.querystring("claz") & " order by [time] desc" 

[nadyxcj]

楼上都说了。。我就不说了
我就说个格式
exec="select * from 表 where 字段="&字段的数值类型是整数类型&" order by time desc"
还有一种
exec="select * from 表 where 字段='"&字段的数值类型非整数类型&"' order by time desc"

[凡夫与俗子]

你的order by都没用引号。。。正确写法参考2楼

[number123456]

exec="select * from article where claz="&request.querystring("claz")&" order by time desc"

少了红色部分

[暴走的车轮]

[Quote=引用 2 楼 zming 的回复:]
如果 request.querystring("claz") 是字符串，则

VBScript code
exec="select * from article where claz='"& request.querystring("claz")&"' order by [time] desc"


如果 request.querystring("claz") 是整数，则

VBScript code
exec="select * from article where claz="& request.querystring("claz")&" order by [time] desc"

[/Quote]

[sd4424]

都是高手嘛 呵呵

[神密者]

如果claz是字符之类的话，那就用下面的方式

exec = "select * from article where claz = '" & request.querystring("claz") & "' order by time desc"

否则

exec = "select * from article where claz = " & request.querystring("claz") & " order by time desc"

[神密者]

不好意思，上面的time要加[time]！刚才没看到！

[Dogfish]

这样看看。
exec="select * from article where claz="&request.querystring("claz") order by [time] desc