Automatically alert

[Angkor]

I store few pending task in Access or MS SQL and set the deadline to
each item. While I am viewing the webpage, it will give message or
alert with specific time. How can I do in ASP?

 

[Evertjan.]

Angkor wrote on 22 mrt 2006 in microsoft.public.inetserver.asp.general:

I store few pending task in Access or MS SQL and set the deadline to
each item. While I am viewing the webpage, it will give message or
alert with specific time. How can I do in ASP?

something like (depending on your db-engine and connection method):

sql = "... where alarmDate between now()-1 and now()+1 .... "

set mD=CONNECT.Execute(SQL)

do until mD.Eof
%>
Alarm: <%=mD("alarmDate")%> (<%=mD("alarmReason")%>)<br>
<%
mD.MoveNext
loop