Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cache Tom1 Excel Discussion (Misc queries) 5 February 11th 09 08:41 PM
how do you get a permanent cache? Excel Cache Excel Discussion (Misc queries) 18 November 3rd 08 02:38 PM
911 Excel Cache! Edgardo Sepulveda Excel Programming 1 June 7th 04 07:37 PM
XMLHTTP proxy settings. Beto[_3_] Excel Programming 0 April 12th 04 08:29 PM
XMLHTTP proxy settings. Beto[_3_] Excel Programming 0 April 2nd 04 09:52 PM


All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"