Display a msg when waiting 4 output from database

Sach · April 29th, 2004, 06:18 AM

Hi

I'm running several queries in my asp page to retrieve data from an access database and display it in a web page. The queries take a long time to run so the user sees a blank screen until the queries have executed and display the data on the screen.

My question is, is it possible to display a message to inform the user to be patient while the queries are executing in the background? I haven't a clue where to start so any help is much appreciated.

Thanks in advance,

Sach.

dhaywirex · April 29th, 2004, 08:09 PM

helo
u could try to output a line before u start the queries to the database, then when the results are displayed, remove the line
e.g.
   strTxt = "Please wait while the results are being retrieved"
   response.write(strTxt)
   queries to database
   display results
   strTxt = ""
   response.write(strTxt)

haven tried it out though, just came to my head as i read ur question
let me know if it works

Snib · April 29th, 2004, 08:24 PM

I'm not sure your solution will work, dhaywirex.

I came up with this (I'm not sure this will work, either....):

<html>
<script language=javascript>
var loadingWin = window.open('about:blank','loadingWin');
loadingWin.document.write('<html><head><title>Load ing...</title></head><body>Please wait. The page you requested is loading.</body></html>');
function destroyPopup()
{
loadingWin.close();
}
</script>
<body onload='destroyPopup()'>
<%
'do your queries here
%>
</body>
</html>

This script should (no guarantees here) pop up a window as soon as it's opened, and then close it when it's done loading.

Let me know if it works.

Snib

<><