Global Alert 1

[Gamera99]

We are building an intranet web project using interdev with an oracle back end. I am trying to think of some way to incorporate a global alert feature which will tell users when the database is not available, if the database is shutting down for backups, etc (it goes down every night for backups).

I wanted to have a DBA utility which will allow the DBA to compose a message or select a canned message from a table, and set the start time, end time, or message duration. Then I planned to replace the title bar frame of the webpage with the message during times when the message is transmitted to all users.

My problem: I can do all of the above with no problem, but if I set a session ID to change the titlebar page, it occurs to me that the session ID affects on the user in the specific session. Is there a way to set a global variable so it affects the entire user group? If there is, I can set a variable which will cause the title bar to change; I can set up the titlebar page to refresh on 1 minute intervals for example.

Thanks if anyone has any ideas.

 

[Gamera99]

I think I will just load a value into a special database table and the page will read the value each time it refreshes.

 

[vasah20]

Why don't you use Application variables?
Those are accessible to all pages within your ASP application, and their life span lasts until IIS is shut down.

To use an application variable is the same basic syntax as a session variable.

Ex:
Application("DBAvailable&quot = true 'set the variable

Response.write Application("DBAvailable&quot 'write the value
and so on...

hope this helps
leo

 

[Gamera99]

Thanks very much Leo; that helped a lot!!