ODBC Drivers error '80040e14'- Syntax error (missing operator) in query expression

请各位专家多指教！！  
   
  我欲更新数据库已有内容。错误如下：  
  Microsoft   OLE   DB   Provider   for   ODBC   Drivers   error   '80040e14'    
   
  [Microsoft][ODBC   Microsoft   Access   Driver]   Syntax   error   (missing   operator)   in   query   expression   ''Pleasure   is   a   gift   to   human   beings   from   the   nature.   The   contemporary   medical   science   demonstrates   that   during   the   sex'.    
   
  /admin/doupdate.asp,   line   92    
   
  上述是detail_descr的部分内容(为何没有显示全部？)是否在那里把'打错了？？  
   
  line   92是conn.Execute   SQL，Syntax   error   (missing   operator)   in   query   expression错误，都是显示conn.Execute   SQL错，其实大家都知道应该是在此之前有错误，本身这句不错。  
   
  我用DSN连接数据库，数据库在服务器上设置了可读、可写和可执行权限。  
   
  数据库连接代码：  
  <%  
  Set   conn=Server.CreateObject("ADODB.Connection")  
  conn.ConnectionTimeout=60  
  conn.Open   "DSN=eincdsn"  
  %>  
   
  asp部分代码如下：  
   
  <%@   LANGUAGE="VBSCRIPT"   %>  
  <!--#include   file="conn.asp"-->  
   
  <%  
  product_id=request.FORM("ID")  
  product_name=request.FORM("product_name")  
  manu_id=request.FORM("manu_id")  
  sort_id=request.FORM("sort_id")  
  sub_sort_id=request.FORM("sub_sort_id")  
  item_no=request.FORM("item_no")  
  size=request.FORM("size")  
  MSRP=request.FORM("MSRP")  
  price=request.FORM("price")  
  small_img=request.FORM("small_img")  
  big_img=request.FORM("big_img")  
  simp_descr=request.FORM("simp_descr")  
  detail_descr=request.FORM("detail_descr")  
  %>  
   
  <%  
  Dim   SQL  
  SQL   =   "Update   Products   "   &   "Set   "   &   "product_name="  
  SQL   =   SQL   &   "'"   &   product_name   &   "'"   &   ",   "  
  SQL   =   SQL   &   "manu_id="  
  SQL   =   SQL   &   ""   &   manu_id   &   ""   &   ",   "  
  SQL   =   SQL   &   "sort_id="  
  SQL   =   SQL   &   ""   &   sort_id   &   ""   &   ",   "  
  SQL   =   SQL   &   "sub_sort_id="  
  SQL   =   SQL   &   ""   &   sub_sort_id   &   ""   &   ",   "  
  SQL   =   SQL   &   "item_no="  
  SQL   =   SQL   &   "'"   &   item_no   &   "'"   &   ",   "  
  SQL   =   SQL   &   "size="  
  SQL   =   SQL   &   "'"   &   size   &   "'"   &   ",   "  
  SQL   =   SQL   &   "MSRP="  
  SQL   =   SQL   &   ""   &   MSRP   &   ""   &   ",   "  
  SQL   =   SQL   &   "price="  
  SQL   =   SQL   &   ""   &   price   &   ""   &   ",   "  
  SQL   =   SQL   &   "small_img="  
  SQL   =   SQL   &   "'"   &   small_img   &   "'"   &   ",   "  
  SQL   =   SQL   &   "big_img="  
  SQL   =   SQL   &   "'"   &   big_img   &   "'"   &   ",   "  
  SQL   =   SQL   &   "simp_descr="  
  SQL   =   SQL   &   "'"   &   simp_descr   &   "'"   &   ",   "  
  SQL   =   SQL   &   "detail_descr="  
  SQL   =   SQL   &   "'"   &   detail_descr   &   "'"  
  SQL   =   SQL   &   "   where   product_id="   &   product_id  
   
  conn.Execute   SQL  
   
  Response.   Write   "Update   DataBase   Successlly!"  
  Response.End  
  conn.Close  
  Set   conn=Nothing  
  %>  
  问题点数：20、回复次数：3Top

1 楼softrookie（编程新生）回复于 2002-09-19 07:56:53 得分 10

查查ODBC数据源有没有什么错误Top

2 楼zqfleaf（动力港湾）回复于 2002-09-19 07:59:22 得分 10

把你的sql语句response.write   出来，然后把他放到数据库存执行看看能不能执行下去。Top

3 楼eincus（美国易美）回复于 2003-02-08 08:21:03 得分 0

解答:      
  Because     the     text     contained     a         '     symbol     in     input     text     area,     SQL     supposed     it     was     the     end     of     syntax     but     actually     it     was     not     ending     yet.     Syntax     error     message     displayed.Top

相关问题

• 数据库
• 执行
• microsoft
• sql
• syntax
• odbc
• missing operator
• driver
• error
• in query expression

• 帖主：eincus
• softrookie
• zqfleaf

• Web开发类图书