How to efficiently generate alerts

[Sathish kumar FifthGen]

Hi !

I have a scenario ... There are login for seperate users and if some changes occurs in a DB table (such as row insertion or deletion), a alert must be generated for that particular user ....Anyone suggest me the best way of implementing this scenario ....

Regards
Sathish

[Scheepers de Bruin]

I can think of at least two ways:

a) When the user requests a new page, you display the alert on the page, or the page opens an alert dialog box or window. Users do not like popus, however.

b) Have an 'agent' window opened at the start of the session, that has a timeout set (in javascript) to however often you want to poll the server, and refreshes the agent window at that interval:

<script language="javascript">
setTimeout("document.reload()",1000);
</script>

this script will cause the document to be reloaded in 1 second.