S
Steven Scaife
I have a search page with upteen boxes that they can choose to fill out and
my second page gets the values and passes them to a stored procedure which
builds the SQL string and returns the recordset.
On this second page i have it so that when a long search is taking place a
layer is shown saying "Search in progress .... Please wait". However since
i changed to a stored procedure it takes a length of time before the page
submits by which time the search is more or less complete. How do i get it
to submit almost immediately so my wait message appears. I have
response.buffer = true at the top of my page, on some pages i have redirects
before processing is complete and all the page settings are in a .inc file
which i place at the top of my page using server.execute Will i need to set
the buffer to false, not entirely sure what this does, except that you need
to set to true to redirect before processing ends to avoid errors.
TIA
my second page gets the values and passes them to a stored procedure which
builds the SQL string and returns the recordset.
On this second page i have it so that when a long search is taking place a
layer is shown saying "Search in progress .... Please wait". However since
i changed to a stored procedure it takes a length of time before the page
submits by which time the search is more or less complete. How do i get it
to submit almost immediately so my wait message appears. I have
response.buffer = true at the top of my page, on some pages i have redirects
before processing is complete and all the page settings are in a .inc file
which i place at the top of my page using server.execute Will i need to set
the buffer to false, not entirely sure what this does, except that you need
to set to true to redirect before processing ends to avoid errors.
TIA