Jump to content

dhoult

Members
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About dhoult

  • Rank
    Newbie
  1. dhoult

    Sql Query Not Updating In Ie

    Doesn't work
  2. dhoult

    Sql Query Not Updating In Ie

    So I noticed that when I hit my back button, or even when I hit submit again, and the pages get loaded, according to the server logs the sql "select" statements don't get executed, yet the variables are still assigned (the old values). In Firefox and Chrome all the statements are executed.
  3. dhoult

    Sql Query Not Updating In Ie

    Hmmm... I really don't know either. I've read the documentation and there's nothing that helps. Oh well, I guess I'll keep playing around.
  4. dhoult

    Sql Query Not Updating In Ie

    I've checked all the variables, and they all seem correct. But if the database is caching the values, why would I only have the problem in IE?
  5. dhoult

    Sql Query Not Updating In Ie

    Because of the web server I'm using, it makes database access incredibly simple. Let me know if you have a question about the code.
  6. dhoult

    Sql Query Not Updating In Ie

    Now it's not working again..... grrrrr Here's a sample:<form action="confirmOrder.stm" method="post" enctype="multipart/form-data" name="order1" id="order1"> <table id="orderForm" border="0" cellpadding="0" cellspacing="10"> <tr> <td id="label">First Name</td> <td><span id="spryFirstName"> <input type="text" name="firstName" id="firstName" tabindex="1"/><br /> <span class="textfieldRequiredMsg">A value is required.</span></span></td> <td id="label">Last Name</td> <td><span id="spryLastName"> <input type="text" name="lastName" id="lastName" tabindex="2"/><br /> <span class="textfieldRequiredMsg">A value is required.</span></span></td> </tr></table><input type="submit" name="submit" value="Submit"><input type="button" name="back" id="back" value="<- Back" onClick="loadPage('order.stm?ID=<RC$ID>&back=yes', 'order')"> </form>...// <RCQdata sql="SELECT * FROM orders WHERE OrderID = RC$ID"><RCFdata><RCif RCDdata.1 ! NULL> document.getElementById("firstName").value = '<RCDdata.2>' document.getElementById("lastName").value = '<RCDdata.3>'<RCendif>
  7. dhoult

    Sql Query Not Updating In Ie

    Okay, I think I fixed it. Apparently, IE was doing something with the database connection like not releasing it. So the new data got sent to the database, but IE couldn't access the new information yet. I guess the old info was still stored in a buffer, and querying the database again used that buffer instead of the new info.That's just the way I see it. Anyway, I played around with a few numbers like the "query timeout" in my server configurations, and now it seems to work. Hopefully it stays that way ::crosses fingers::Thanks for your ideas.Btw, I've had too many problems in general programming this website for IE. It's been so much easier in the other two.
  8. dhoult

    Sql Query Not Updating In Ie

    The back button I'm talking about is not for the browser. I have a "back" button next to my "submit" button. All the back button does is run a script that loads the previous form into a <div> container in the window. That form will query the database to see if the person already entered information. If there is a record for that form, it will fill in all the recorded entries. With IE, when I run the "SELECT" statement, all the returned data is old, even though when I look in the database the old entries are not there anymore.
  9. dhoult

    Sql Query Not Updating In Ie

    I hope I'm asking this in the correct forum...There is a form on my website where you enter information, it stores it in the database, takes you to another page where you enter more info, etc.When you click the "back" button on a page (not the browser back button), it goes to the previous page, loads your information from the database and places it into the form so you can then modify it. If you submit that form, it updates the info in the database.This works fine. However, the problem I have is when you go back to the same page a second time, it does not display the modified information, but rather it shows the original info. THIS IS ONLY AN ISSUE WITH IE. It displays the updated info like it should in Firefox and Chrome.I have checked the database and it gets updated every time without fail. I have checked the variables that store the information from the SQL query and they're empty until the call on the webpage. So I really have no clue how IE is retrieving the original data when it no longer exists in the database.I am using Access 2003 for my database and Sambar as my web server.Any ideas? Thanks!!
  10. dhoult

    Compliments

    I just want to say that I really like the website and how everything is organized and displayed. It has helped me many times.
×