ie, asp, excel caching???

[alex]

Hello,
My problem is as follows...I wrote an ASP application that
pulls data from SQL based on the query the user specified.
I am using the response.contenttype="applicaiton/x-
msexcel" to display the data in Excel via IE. But it seems
the content is cached that is the displayed data is
independent of the query specified, unless i close down
the browser.

It seems to be a client-side issue as not all clients are
having this problem. Any help would be appreciated.

TIA,
Alex

[TomB]

I generally stick an unimportant parameter, randomly generated, on the end
of the URL.
<a href="OpenExcelFile.asp?FileID=7&randomNumber=<%=l ngRand%>">Open</a>

where lngRand is a Random number, thus making the browser consider it a new
file.

"alex" <al******@yahoo.com> wrote in message
news:0d****************************@phx.gbl...

Hello,
My problem is as follows...I wrote an ASP application that
pulls data from SQL based on the query the user specified.
I am using the response.contenttype="applicaiton/x-
msexcel" to display the data in Excel via IE. But it seems
the content is cached that is the displayed data is
independent of the query specified, unless i close down
the browser.

It seems to be a client-side issue as not all clients are
having this problem. Any help would be appreciated.

TIA,
Alex