Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xmlhttp and ie cache
I am using xmlhttp.open and .send to retreive data from the internet. This
works ok but I have realised that the data retreived is not refreshed from the web server, rather is being taken from ie cache (meaning that the data is effectively useless). I have tried using .setrequestheaders with a variety of options. This did not work. Clearing the cache does force a requery of the web server, but is not a practical solution. I have found one suggestion in seaches on the web that indicated a registry setting be changed before the query, and then reset after - seems a bit drastic for mine. Is there a simpler solution to this? thanks JC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xmlhttp and ie cache
Jack,
Yes, massively simpler. Add a dummy parameter to your post and change the dummy value to force a refresh. e.g. something like strPost = http://nnn.nnn.nnn.nnn/MyPage.asp?Param1=55&Param2= & int(rand()*1000) Robin Hammond www.enhanceddatasystems.com "Jack Clift" wrote in message ... I am using xmlhttp.open and .send to retreive data from the internet. This works ok but I have realised that the data retreived is not refreshed from the web server, rather is being taken from ie cache (meaning that the data is effectively useless). I have tried using .setrequestheaders with a variety of options. This did not work. Clearing the cache does force a requery of the web server, but is not a practical solution. I have found one suggestion in seaches on the web that indicated a registry setting be changed before the query, and then reset after - seems a bit drastic for mine. Is there a simpler solution to this? thanks JC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
xmlhttp and ie cache
that should be
CInt(1000 * Rnd()) Robin Hammond www.enhanceddatasystems.com "Robin Hammond" wrote in message ... Jack, Yes, massively simpler. Add a dummy parameter to your post and change the dummy value to force a refresh. e.g. something like strPost = http://nnn.nnn.nnn.nnn/MyPage.asp?Param1=55&Param2= & int(rand()*1000) Robin Hammond www.enhanceddatasystems.com "Jack Clift" wrote in message ... I am using xmlhttp.open and .send to retreive data from the internet. This works ok but I have realised that the data retreived is not refreshed from the web server, rather is being taken from ie cache (meaning that the data is effectively useless). I have tried using .setrequestheaders with a variety of options. This did not work. Clearing the cache does force a requery of the web server, but is not a practical solution. I have found one suggestion in seaches on the web that indicated a registry setting be changed before the query, and then reset after - seems a bit drastic for mine. Is there a simpler solution to this? thanks JC |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
xmlhttp and ie cache
Thanks Robin, have written small slice of code that submits a date string
(year, month, day, hour, minute, second), was easiest for me to do it that way. Works fine. Am interested though on the origninal problem - is this a problem on the server (web) side or something problematic with xmlhttp? Just curious for future reference. Cheers JC "Robin Hammond" wrote: that should be CInt(1000 * Rnd()) Robin Hammond www.enhanceddatasystems.com "Robin Hammond" wrote in message ... Jack, Yes, massively simpler. Add a dummy parameter to your post and change the dummy value to force a refresh. e.g. something like strPost = http://nnn.nnn.nnn.nnn/MyPage.asp?Param1=55&Param2= & int(rand()*1000) Robin Hammond www.enhanceddatasystems.com "Jack Clift" wrote in message ... I am using xmlhttp.open and .send to retreive data from the internet. This works ok but I have realised that the data retreived is not refreshed from the web server, rather is being taken from ie cache (meaning that the data is effectively useless). I have tried using .setrequestheaders with a variety of options. This did not work. Clearing the cache does force a requery of the web server, but is not a practical solution. I have found one suggestion in seaches on the web that indicated a registry setting be changed before the query, and then reset after - seems a bit drastic for mine. Is there a simpler solution to this? thanks JC |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
xmlhttp and ie cache
A general "feature": I think IE's cache is also shared by other objects such
as xlmhttp. If the caching algorithm sees you making a request you've recently made (how recently being determined by your cache settings) then instead of making a request to the server it will simply fetch the content from the cache. A proxy server may also do the same thing regardless of your local settings. Since the request "identity" is based on the URL including the querystring, the "random" parameter will side-step the cache issue. Tim. -- Tim Williams Palo Alto, CA "Jack Clift" wrote in message ... Thanks Robin, have written small slice of code that submits a date string (year, month, day, hour, minute, second), was easiest for me to do it that way. Works fine. Am interested though on the origninal problem - is this a problem on the server (web) side or something problematic with xmlhttp? Just curious for future reference. Cheers JC "Robin Hammond" wrote: that should be CInt(1000 * Rnd()) Robin Hammond www.enhanceddatasystems.com "Robin Hammond" wrote in message ... Jack, Yes, massively simpler. Add a dummy parameter to your post and change the dummy value to force a refresh. e.g. something like strPost = http://nnn.nnn.nnn.nnn/MyPage.asp?Param1=55&Param2= & int(rand()*1000) Robin Hammond www.enhanceddatasystems.com "Jack Clift" wrote in message ... I am using xmlhttp.open and .send to retreive data from the internet. This works ok but I have realised that the data retreived is not refreshed from the web server, rather is being taken from ie cache (meaning that the data is effectively useless). I have tried using .setrequestheaders with a variety of options. This did not work. Clearing the cache does force a requery of the web server, but is not a practical solution. I have found one suggestion in seaches on the web that indicated a registry setting be changed before the query, and then reset after - seems a bit drastic for mine. Is there a simpler solution to this? thanks JC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cache | Excel Discussion (Misc queries) | |||
how do you get a permanent cache? | Excel Discussion (Misc queries) | |||
911 Excel Cache! | Excel Programming | |||
XMLHTTP proxy settings. | Excel Programming | |||
XMLHTTP proxy settings. | Excel Programming |