MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE, Reference

Page: 340 / 608

316 CFML Language Reference
<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>
...