Forum Moderators: open

Message Too Old, No Replies

ASP response.redirect

Why hasn't my database updated?

         

Filipe

7:56 pm on Apr 30, 2002 (gmt 0)

10+ Year Member



Hi, I have an administrator section for a website that interacts with an OLE database (Access). When an administrator changes something, I redirect him instantly to the main admin page where he can see the changes he's just made. However, the db query in the main admin page isn't picking up the changes that were made immediately before I response.redirect()ed them there. What gives?

Xoc

9:08 pm on Apr 30, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Sounds like the database isn't flushing before it redirects. You did close all the objects and set their object variables to nothing before you did the response.redirect?

txbakers

12:41 am on May 1, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Your page is being stored in Cache.

You need to set Response.Expires = -1 so the page never caches.