error ' 80040e21'

Results 1 to 3 of 3

Thread: error ' 80040e21'

  1. #1
    Lasse Guest

    Default error ' 80040e21'

    I&#039ve got this admin-page and adding articles works just fine, but when I want to edit or delete something I get this message: <BR>- - - - -<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e21&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression &#039(nothing=Pa_RaM017 AND ID=Pa_RaM018 AND aaadatewh IS NULL AND aaadatewr IS NULL AND aaatimewh IS NULL AND aaapathwr1=Pa_RaM019 AND aaapathwr2=Pa_RaM020 AND aaapathgo1=Pa_RaM021 AND aaapathgo2 IS NULL AND aaapri=Pa_RaM022 AND hl IS NULL AND in IS NULL AND sea&#039. <BR><BR>/admin/edit.asp, line 62 <BR>- - - - -<BR>Line 62 is where it says: RecordSet.Update<BR>What does his mean?

  2. #2
    Join Date
    Dec 1969

    Default RE: error ' 80040e21'

    that means your SQL statement is wrong.....missing operator could be somthing like: there seems to be a missing ")" at the end of the query statement. check for that

  3. #3
    lasse Guest

    Default RE: error ' 80040e21'

    The SQL statement looks like this:<BR><BR> SQL = "SELECT * FROM news WHERE (((news.ID)=" & Request.QueryString("ID") & "));"<BR><BR>Can there really be something wrong with it, when the form (in the edit-page) does get the old values from the database?

Posting Permissions

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