?
Solved

Dreamweaver Master Page generates error after Updating

Posted on 2007-10-11
5
Medium Priority
?
355 Views
Last Modified: 2008-01-09
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.

0
Comment
Question by:peggyk2
  • 3
  • 2
5 Comments
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 1000 total points
ID: 20059479
Hi peggyk2,

Is a query string being appended to the URL when you get redirected the first time?
0
 

Author Comment

by:peggyk2
ID: 20059568
Yes.  The URL does have a query.  http://webserver/page.asp?ProblemID=4   Out of my frustration I finally deleted the page and I'm rebuilding it to see if it was a fluke or if I'm actually doing something wrong.  This is the first time I've run across this problem.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 20059728
It might have something to do with the query string being present when you go to the update page a second time.  It could also be something else that the rebuild will take care of.  If the problem continues, post the source code for both pages.
0
 

Author Comment

by:peggyk2
ID: 20059970
After rebuilding the page from scratch, I still had the problem but I figured out what it was doing.   When I updated the form and submitted it, I was taken back to the Master page so I could continue updating other records.  When I went back to the master page, the URL Query was in the address line and the only way I could get it out so it stayed out, was to retype the address without the query  and then refresh.  Just refreshing the page didn't help.  I even tryed using the full internet link to the master page, but that didn't work.  I solved the problem by redirecting to a page stating the record has been updated and by giving a link from there back to the master page.  Kind of a roundabout way to do it, but it works and for what I need it for, it's acceptable.  Thank you for your help.  If you hadn't brought that URL query string to my attention, I never would have figured it out.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 20061359
You're welcome.  A similar issue exists in PHP, which is why I thought of it.  I've stopped using the query string for a lot of issues because of this.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question