«

Hi All,

I've an asp page which brings back a query and displays it in a table. The
query takes around 30 seconds. Once the page displays they will have an
option to send it to excel. From the examples I've seen they all require the
query to be re-ran again in asp (i.e. server side scripting) and as it takes
30 seconds to start with I want to try and take out the repeat of the query.
Does anyone know of any way you can do this in asp by passing the already
executed table to asp or via any other method?

Many thanks,
Rob

"bob" <> wrote in message
news:chusjb$oot$...
> Hi All,
>
> I've an asp page which brings back a query and displays it in a table.
> The query takes around 30 seconds. Once the page displays they will have
> an option to send it to excel. From the examples I've seen they all
> require the query to be re-ran again in asp (i.e. server side scripting)
> and as it takes 30 seconds to start with I want to try and take out the
> repeat of the query. Does anyone know of any way you can do this in asp by
> passing the already executed table to asp or via any other method?

Depending on how much data is returned, I guess you could write the HTML
table to a session variable.

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserv...y/centers/iis/
http://mvp.support.microsoft.com/
http://www.iisfaq.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://www.tryiis.com

We return the recordset as a response.write and use script to load excel and
populate the spreadsheet...

-mike


"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:ci43u3$...
> "bob" <> wrote in message
> news:chusjb$oot$...
> > Hi All,
> >
> > I've an asp page which brings back a query and displays it in a table.
> > The query takes around 30 seconds. Once the page displays they will have
> > an option to send it to excel. From the examples I've seen they all
> > require the query to be re-ran again in asp (i.e. server side scripting)
> > and as it takes 30 seconds to start with I want to try and take out the
> > repeat of the query. Does anyone know of any way you can do this in asp
by
> > passing the already executed table to asp or via any other method?
>
> Depending on how much data is returned, I guess you could write the HTML
> table to a session variable.
>
> --
> Tom Kaminski IIS MVP
> http://www.microsoft.com/windowsserv...y/centers/iis/
> http://mvp.support.microsoft.com/
> http://www.iisfaq.com/
> http://www.iistoolshed.com/ - tools, scripts, and utilities for running
IIS
> http://www.tryiis.com
>
>