Dreamweaver Master Page generates error after Updating
Posted on 2007-10-11
I have Dreamweaver generated Master/Update forms.
I open the master file and click on the record I want to update. The record comes up and I make my changes and then click submit. Record updates the database and puts me back to the master page just like it's supposed to. I click on the same or another record and I get an error message. This error will continue until I close out IE and reopen it. Then it works fine until I update a record and we repeat the sequence. The error looks like this:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/helpdesk/update.asp, line 113
Line 113 is the line that opens the recordset. I've tried a forced refresh on the page and that didn't work. Only closing out the browser works. If I click the link on the master page and look at the record but don't update, everything works fine. I can open as many records as I want. It's only when I update the record that I have an issue. Can someone give me an idea of where to look for this error? It seems to be generated on the update page, but at this point I'm not sure.