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
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)