<%
      if request("id")="" then
      response.write("<div align=center><font color=red>请选译左侧的分类!</font></div>")
      else
      id=request("id")
      set rsa=server.createobject("ADODB.Recordset")
      sql="select * from [product_Series] where product_Brand_id="&id&"order by paixu_id desc"
      rsa.open sql,conn,1,1      
      If  rsa.eof and rsa.bof Then
      response.write("<div align=center class=red12>沒有相關信息！</div>")
      else
      do while not rsa.eof
      %>


出错提示:

Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'product_Brand_id=12order by paixu_id desc' 中。

只要我删掉"order by paixu_id desc"  就没有问题，可以运行

paixu_id 数据库类型为数字型；
没有问题；
真的想不出是哪里出问题了。

sql="select * from [product_Series] where product_Brand_id="&id&" order by paixu_id desc"
要空出一格

空出空格我也试过了，还是出错！

product_Brand_id="&id
这样呢？

sql="select * from [product_Series] where product_Brand_id="&id&" order by paixu_id desc"

id=cint(request("id"))

sql="select * from name_TDirTtl where followid="&zid&" order by zid desc"