Alert based on text field criteria

[redbay]

i have an action form that has to be closed by a specified date, i would like an alert, message or warning to be activated if the action hasnt been closed by that date, is there a way of doing this

 

[Cheech]

When you say you want an alert to happen if an action is passed its expire date, do you want this done by the database or by a user visiting a page?

[Peace][Pipe]

 

[redbay]

either through the user visiting the page or via an email notification but i think thats to difficult!

 

[Cheech]

Take a recordset of all the entries where the expirory date has passed and then use a Show if recordset is not empty behaviour to display an alert if a record exists.

Cheech

[Peace][Pipe]

 

[redbay]

how would i display the alert?

 

[Cheech]

Untested

<%
if not rsWhatever.eof and rswhatever.bof then
%>
<script language=javascript>
alert("outstanding items")
</script>
<%end if%>

Cheech

[Peace][Pipe]