帮忙说说是啥错？~~~~~~~~~~~~3X!

[batty2000]

<%
dbpath=server.mappath("cart.mdb")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq=" & dbpath

<%
dbpath=server.mappath("cart.mdb")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq=" & dbpath

CategoryID=request("CategoryID")
Descript=request("Description")
Head="网上超市-[" & Descript & "]区"
sql="select * from Products where CategoryID=" & CategoryID
sql=sql & "Order by ProductID" //11行
set rs=conn.execute(sql) //12行
%>
==================================
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'CategoryID=4Order by ProductID' 中。
/buy.asp, 第 12 行
====================================
Order By 默认的排序方式是"从小到大"，请问这个大小是指什么大小？我的数据表
Products的字段ProductID的数据类型是文本，还能用order by吗？？？

错在哪儿？如何改～～

[woyingjie]

sql=sql & "Order by ProductID desc/asc"

[luluso]

sql="select * from Products where CategoryID="&CategoryID&" Order by roductID" set rs=conn.execute(sql)

[lbd8848]

driver={microsoft access driver (*.mdb)};->
driver={Microsoft Access Driver (*.mdb)};

[xiaobird1]

sql=sql & " Order by ProductID"

[josney]

sql="select * from Products where CategoryID='"&CategoryID&"' order by cint(productid)"
不行的话把order by cint(productid)去掉试试

[QZY2003]

可能你的CategoryID是空值.

自己查一下

是不是request("CategoryID")没有得到值

[QZY2003]

sql=sql & "Order by ProductID"
-----------|在order前加空格
试一下
如:sql=sql &" "&" Order by ProductID"