| Evertjan. 2006-03-25, 11:58 am |
| Xref: TK2MSFTNGP08.phx.gbl microsoft.public.inetserver.asp.general:303498
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)
|