Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JeffT
Posting Yak Master
111 Posts |
 Posted - 2006-02-03 : 14:40:59
|
| Hi,I'm looking for a way to popup a message from my .asp program for users under the following scenario:(1) user enters an id number in a field on Page A and clicks on a link. (2) .asp program runs a query against a bunch of tables and then calls another .asp program which presents the user with the data extracted via the query on Page B.I'd like to pop up a message box when the user clicks on the link in #(1) above (something like "Retrieving Information...please wait") until the screen #2 with the data is displayed. I've tried this:<Script Language="VBScript"> MsgBox "Retrieving Query information...please wait"</Script>but the message doesn't pop up until the data has already been retrieved. This is an application that is going away in the next year and a half so, rather than tweak it to see if the query time can be decreased, I'm told I should popup this message.Thank you,Jeff |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-03 : 15:21:49
|
| You might want to put this thread in the ASP.NET or Other Topics forum as this one is for SQL Server.Tara Kizeraka tduggan |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-02-03 : 15:33:12
|
| You need to do this in a three-stage way.Page 1 The UI PageThis page has the box and the link that the user interacts with. When the user clicks on the link, you need to store some value that will tie the user on the page to the query they are about to execute. You'll probably stored this "query number" in session.Once you store the value, and kick off the query, send the user to page 2Page 2 The "Please Wait" PageThis page will Meta Refresh every 15-30 seconds (as determined by you) and check to see if the query is complete. Once the query is complete, send the user to Page 3.Page 3 The Display pageThis page will read the "query number" for the user and pull the results of that user's query and display them.That's a very high level description of what needs to happen. The tricky part here is having some sort of "queue" that stores the queries that need to be run, and having something that will run them and store the results someplace.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
JeffT
Posting Yak Master
111 Posts |
Posted - 2006-02-03 : 21:23:21
|
| Thanks very much Tara and Michael. I appreciate your input !Jeff |
|
|
|
|
|
|
Message Box popup