deadline reminder

[achai]

how to make a deadline reminder?<br>tableroject-&gt;field:deadline<br>many dates in deadline field. can i write coldfuion query to ask system to remind me two days before each deadline.<br>or use Scheduled Tasks.

 

[DarkMan]

You can set up a template, like:<br><br><FONT FACE=monospace><br>&lt;cfset date1=dateadd(2,&quot;d&quot;,dateformat(now(),&quot;mm/dd/yy&quot)&gt;<br>&lt;cfset date2=dateadd(3,&quot;d&quot;,dateformat(now(),&quot;mm/dd/yy&quot)&gt;<br><br>&lt;cfquery name=&quot;project&quot; datasource=&quot;mytable&quot;&gt;<br>&nbsp;&nbsp;select * from project<br>&nbsp;&nbsp;where deadline &gt; '#date1#' and deadline &lt; '#date2#'<br>&lt;/cfquery&gt;<br><br>&lt;cfmail to=&quot;<A HREF="mailto:you@yourcompany.com">you@yourcompany.com</A>&quot; from=&quot;you#yourcompany.com&quot; subject=&quot;Deadline is coming&quot;&gt;<br>The following projects are due on #dateformat(date1)#:<br>&lt;cfoutput query=&quot;project&quot;&gt;<br>#ProjectName#&lt;/cfoutput&gt;<br>&lt;/cfmail&gt;</font><br><br>and set it in the CF scheduled tasks to run daily....

 

[achai]

what's &quot;2&quot; in &quot;dateadd(2...&quot;?<br>does it mean before two days?<br>when i tried to run this file. it shows some erro:<br>&quot;A query driven CFOUTPUT tag is nested inside a CFMAIL tag that also has a QUERY= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, only the top-level tag can specify the query that drives the processing.&quot;<br><br>

 

[DarkMan]

<FONT FACE=monospace>&lt;cfset date1=dateadd(2,&quot;d&quot;,dateformat(now(),&quot;mm/dd/yy&quot)&gt;</font><br><br>Means &quot;Add (2) &quot;d&quot;(days) to today at midnight (dateformat(now(),&quot;mm/dd/yy&quot; with no time specified).<br><br>Also, you must have specified a query in your cfmail tag.&nbsp;&nbsp;This would be what's causing your error....<br><br>If you are grouping around two columns in your query, say &quot;ProjectOwner&quot; (the email address) and &quot;ProjectName&quot; you should be able to get around this by doing something like:<br><br><FONT FACE=monospace>&lt;cfmail query=&quot;project&quot; group=&quot;ProjectOwner&quot; to=&quot;#ProjectOwner#&quot; from=&quot;<A HREF="mailto:you@yourcompany.com">you@yourcompany.com</A>&quot; subject=&quot;Deadline is coming&quot;&gt;<br>The following projects are due on #dateformat(date1)#:<br>&lt;cfoutput group=&quot;ProjectName&quot;&gt;<br>#ProjectName#&lt;/cfoutput&gt;<br>&lt;/cfmail&gt;</font>

 

[achai]

erro shows:<br>&quot;Parameter 1 of function DateAdd which is now &quot;2&quot; must be a valid date/time part specifier<br>The error occurred while evaluating the expression: <br>&nbsp;date1=dateadd(2,&quot;d&quot;,dateformat(now(),&quot;mm/dd/yyyy&quot)&quot;<br><br>so i tried to add &quot;&quot;, '', () to 2, still doesn't work.<br><br>

 

[iza]

... let's read the doc ....<br><br>Syntax&nbsp;&nbsp;&nbsp;DateAdd(datepart, number, date)<br><br>that means the ocrrect syntax appears to b :<br>&nbsp;date1=dateadd(&quot;d&quot;,2,dateformat(now(),&quot;mm/dd/yyyy&quot)&quot;<br><br><br><br>

 

[achai]

if i use group, erro shows:&quot;Loop error<br>The group ProjectOwner does not specify a column of the query&quot;<br><br>if i delete group, and remove query=&quot;&quot; from &lt;cfoutput query=&quot;&quot;&gt;to &lt;cfmail query=&quot;&quot; to=&quot;&quot; from=&quot;&quot;&gt;<br><br>it doesn't show any erro.<br>but i haven't got any email.<br>should i set mail server in coldfusion administrator?<br>

 

[DarkMan]

Whoops!&nbsp;&nbsp;I got the 2 and the &quot;d&quot; mixed up... Sorry about that...<br><br>Yes.&nbsp;&nbsp;You need to set up your mail server in the cf administrator.&nbsp;&nbsp;Either that, or specify your server in the mail tag...&nbsp;&nbsp;SERVER=&quot;mail.yourcompany.com&quot; PORT=&quot;25&quot;&nbsp;&nbsp;(the port number is almost always 25...)&nbsp;&nbsp;If you have access to the administrator, you should set it up there, though...