Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Providence, RI
    Posts
    9

    Unanswered: Updating a record--ID is being passed twice.....

    I'm building an application that inserts, searches, updates records from a resume database. Well, I have my application working up to the updating part; when a user clicks the ID number (from the results page), it displays the records infomation. Now, if I wanted to update a record, I set up a link that passes the ID to the update page; here is where everything breaks.

    I'm getting this error:
    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
    [Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'ID = 528, 528'.

    For some reason, it's passing the ID Number twice, anyone have any ideas why?

    Thanks!

    -D

  2. #2
    Join Date
    May 2004
    Posts
    125
    Can you give us a bit of the code that post and receives the request for the update. With out seeing any code we can only take grabs at what is wrong.

  3. #3
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Sounds like you have two HTML form fields with the same name, and the same value.
    That which does not kill me postpones the inevitable.

Posting Permissions

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