注册 登录
编程论坛 ASP技术论坛

SQL排序出错

huade 发布于 2008-12-12 21:15, 898 次点击
<%
      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' 中。
8 回复
#2
huade2008-12-12 21:27
只要我删掉"order by paixu_id desc"  就没有问题,可以运行

paixu_id 数据库类型为数字型;
没有问题;
真的想不出是哪里出问题了。
#3
laokui2008-12-13 00:39
sql="select * from [product_Series] where product_Brand_id="&id&" order by paixu_id desc"
要空出一格
#4
huade2008-12-13 10:24
回复 第2楼 huade 的帖子
空出空格我也试过了,还是出错!
#5
laokui2008-12-13 10:52
product_Brand_id="&id
这样呢?
#6
lackyking2008-12-13 11:37
sql="select * from [product_Series] where product_Brand_id="&id&" order by paixu_id desc"
#7
lackyking2008-12-13 11:38
id=cint(request("id"))
#8
kjscwj2008-12-15 12:16
sql="select * from name_TDirTtl where followid="&zid&" order by zid desc"
1