If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Updating a record--ID is being passed twice.....

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-12-04, 15:48
meechp123 meechp123 is offline
Registered User
 
Join Date: Dec 2003
Location: Providence, RI
Posts: 9
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
Reply With Quote
  #2 (permalink)  
Old 08-13-04, 15:40
DMWCincy DMWCincy is offline
Registered User
 
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.
Reply With Quote
  #3 (permalink)  
Old 08-14-04, 01:01
Seppuku Seppuku is offline
Useless...
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On