Macromedia coldfusion 4.5-cfml language reference User Manual

316

<P>This example uses DateAdd to determine when a message in
the database will expire.  (The value selected is messages older
than <CFOUTPUT>#value#

<CFSWITCH EXPRESSION=#type#>

<CFCASE VALUE="yyyy">years</CFCASE>
<CFCASE VALUE="q">quarters</CFCASE>
<CFCASE VALUE="m">months</CFCASE>
<CFCASE VALUE="y">days of year</CFCASE>
<CFCASE VALUE="w">weekdays</CFCASE>
<CFCASE VALUE="ww">weeks</CFCASE>
<CFCASE VALUE="h">hours</CFCASE>
<CFCASE VALUE="n">minutes</CFCASE>
<CFCASE VALUE="s">seconds</CFCASE>
<CFDEFAULTCASE>years</CFDEFAULTCASE>

</CFSWITCH>
</CFOUTPUT>).

<TABLE>
<TR>

<TD>UserName</TD>
<TD>Subject</TD>
<TD>Posted</TD>

</TR>
<CFOUTPUT query="GetMessages">
<TR>

<TD>#UserName#</TD>
<TD>#Subject#</TD>
<TD>#Posted# <CFIF DateAdd(type, value, 

posted) LT Now()>EXPIRED</CFIF></TD>

</TR>
</CFOUTPUT>
</TABLE>
...