error in update statement.

Results 1 to 3 of 3

Thread: error in update statement.

  1. #1
    Join Date
    Dec 1969
    Posts
    147

    Default error in update statement.

    hi:)<BR><BR>i always got this error whenever i execute the edit functions,<BR>i had change number of things here and there but the same <BR>error still occur. does anyone know why?<BR><BR><BR><BR>thanks a lot<BR>karen<BR><BR><BR><BR><BR>Database Errors Occured<BR><BR>UPDATE authors SET Record=&#039&#039, TITLE=&#039&#039, CHRISTIAN=&#039&#039, SURNAME=&#039&#039, NAME=&#039&#039, DESIGNATIN=&#039&#039, DESIGDEPT=&#039&#039, FOCUSAREA=&#039&#039, COMPANY=&#039&#039, ADDRESS1=&#039&#039, ADDRESS2=&#039&#039, ADDRESS3=&#039&#039, PD=&#039&#039, TELEPHONE=&#039&#039, FAX=&#039&#039, DEPT=&#039&#039, STATUS=&#039&#039, CUSTTYPE=&#039&#039, MAILTYPE=&#039&#039, MAILDEPT=&#039&#039, MAILAPDS=&#039&#039, XMASCARDS=&#039&#039, NEWSLINK=&#039&#039, ANNUALREPORT=&#039&#039, BROCHURES=&#039&#039, WHERE AU_ID=<BR><BR>Error #-2147217900<BR><BR>Error desc. -> [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in UPDATE statement.

  2. #2
    Join Date
    Dec 1969
    Posts
    511

    Default RE: error in update statement.

    It would help if you could post the code you used to construct the SQL string. Did you write it all on one line?<BR><BR>Pete

  3. #3
    Join Date
    Dec 1969
    Posts
    147

    Default RE: error in update statement.

    thanks that problem is solved =)<BR>problems lies at the last statement couldn&#039t had a comma:(<BR><BR>i would like to ask ya another question.<BR><BR>i had my add function working on my database but sometimes it isn&#039t working properly, sometimes it adds but sometimes it doesn&#039t<BR>with a error msg:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e21&#039 <BR><BR>Errors occurred <BR><BR>/ad2.asp, line 81 <BR><BR>do you know what had happen?<BR><BR>thanks again:)<BR><BR>karen<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •