asked on

make a popup html window based on SQL Trigger Values ?

hi,,,
i'm trying to make a small popup html window on the right bottom corner of user screen,,

this window is created based on a tigger on a table ,when ever
a row is inserted to a user a window well popup on his/her screen..

i need that to look as an Email Notification, or an alert to the user.

i'm developing in Vb.Net & SQL Server..
is there a way to do that , or any idea,,

eyeh8u

WWW is a pull technology, the user's web browser has to request a page from the server. There is no way the server can push a message to the client's machine to do the popup.

So you need to fake it. You would have to have an HTML page that used a javascript timer, or a meta refresh to reload itself. When reloaded, if it needed to alert the user it would have to create a new window via javascript and position it in the bottom corner.

It would also have to have at least a title bar and close button, you could remove the toolbar and address bar, but it's never going to look quite like an Email Notification alert.

You can find the screen width and height from the screen object, so you'd create a new window and place it in the corner something like:

var left = screen.width - desiredwindowwidth;
var top = screen.height - desiredwindowheight
var hwnd = window.open('alertwindow.html','alert','left='+left+';top='+top);

You woun't be able to fire it from the trigger.

star4

ASKER

if it is not possible , how is Microsoft MSN messanger is working ????
What about Norton AntiVirus Live Update ??????

ASKER CERTIFIED SOLUTION

eyeh8u

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial