Display "busy" window while query running in background

[FaStOnE]

Wasn't sure where to post this, but thought I would start here.

I have several JSP pages that I build SQL Queries with for my office. Unfortunately, there are some queries that must be run across a 1 to 20 million record databases. What's the easiest way to have a "Busy" screen show up while the query is running in the background, so that the user doesn't think the window is locked up? Whether it's a miniature computer running around the screen or flashing text doesn't matter to me... I just want them to know (visually) that something is going on.

As a bonus, if there was a way to tell it how much has completed (percentage complete bar) that would be great... but, I can't think of a way to do that while executing a query.

Thanks for your help!

Rick
--Remember, 2 wrongs don't make a right! But 3 rights make a left!

 

[sowmindra]

You could use a DIV tag which shows the "Loading..." message.(sya div1)
I guess you would be displaying the data in html TABLE so it will display untill all the rows are filled.
So u put the table in DIV(say div2) and hide it,after getting all the data u hide div1 and show the div2.

 

[tsdragon]

Check out Thread215-152691
Tracy Dryden
tracy@bydisn.com

http://www.bydisn.com

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.