On Thursday 13 Dec 2001 03:42, Jack A. Fobel wrote: > Hello, > > Coming from an ASP world, I'm trying to learn how to break the browser from > caching. I am using variables and their values in the querystring to > update a mysql database with perl. I am also re-querying the database to > pull back the record. I was hoping to pull back the updated record but it > appears to either cache the info in the browser and/or mysql is caching the > query; dunno.
I use perl/mysql quite extensively, and I have never run into anything like the second possibility you are describing. AFAIK, the only way that could happen is if you use INSERT DELAYED queries, and they don't finish running before your next refresh happens. There are, however, bugs in IE that make it not requery, and when it doesn, it doesn't do it properly, thus possibly resulting in stale data. IIRC, squid has a workaround kludge for this behaviour. > I have tried a few things, they are 1) turn off cache in IE, 2) pass a > datestamp through the querystring, 3) HTML cache buster code. Being none of > these worked, I am resorting to believe it is the queries I am using in > perl. Try sending back the last modified time in the headers that is always the current timestamp. You may also want to play with the "Pragma:" http header. If you use the standard CGI modules in perl, you shouldn't really be having any of those problems, though. Try a few different browsers (including versions) - that should help you pinpoint the problem. > Any ideas how I can write my queries in a select so that it is sure to > pick up any recently changed data from the database that might have just > been written? It sounds like you have a browser problem. Regards. Gordan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
