home *** CD-ROM | disk | FTP | other *** search
/ Chip 2002 February / CHIPCD_02_2002.iso / Internet / Macromedia ColdFusion Server 5 / coldfusion-50-win-us.exe / data1.cab / Examples / CFDOCS / snippets / dateadd.cfm < prev    next >
Encoding:
Text File  |  2001-06-13  |  2.0 KB  |  92 lines
  1. <!--- This example shows the use of DateAdd --->
  2.  
  3. <HTML>
  4.  
  5. <HEAD>
  6. <TITLE>
  7. DateAdd Example
  8. </TITLE>
  9. </HEAD>
  10.  
  11. <BASEFONT FACE="Arial, Helvetica" SIZE=2>
  12. <BODY  bgcolor="#FFFFD5">
  13.  
  14. <H3>DateAdd Example</H3>
  15.  
  16. <CFPARAM name="value" default="3">
  17. <CFPARAM name="type" default="yyyy">
  18.  
  19. <!--- if numbers passed, then use those --->
  20. <CFIF IsDefined("form.value")>
  21.     <CFSET value = form.value>
  22. </CFIF>
  23. <CFIF IsDefined("form.type")>
  24.     <CFSET type = form.type>
  25. </CFIF>
  26.  
  27.  
  28. <CFQUERY name="GetMessages" DATASOURCE="cfsnippets">
  29. SELECT     UserName, Subject, Posted
  30. FROM    Messages
  31.  
  32. </CFQUERY>
  33.  
  34. <P>This example uses DateAdd to determine when a message in
  35. the database will expire.  (The value selected is messages older
  36. than <CFOUTPUT>#value#
  37.  
  38. <CFSWITCH EXPRESSION=#type#>
  39.     <CFCASE VALUE="yyyy">years</CFCASE>
  40.     <CFCASE VALUE="q">quarters</CFCASE>
  41.     <CFCASE VALUE="m">months</CFCASE>
  42.     <CFCASE VALUE="y">days of year</CFCASE>    
  43.     <CFCASE VALUE="w">weekdays</CFCASE>    
  44.     <CFCASE VALUE="ww">weeks</CFCASE>    
  45.     <CFCASE VALUE="h">hours</CFCASE>    
  46.     <CFCASE VALUE="n">minutes</CFCASE>    
  47.     <CFCASE VALUE="s">seconds</CFCASE>        
  48.     <CFDEFAULTCASE>years</CFDEFAULTCASE></CFSWITCH>
  49. </CFOUTPUT>).
  50.  
  51. <TABLE>
  52. <TR>
  53.     <TD>UserName</TD>
  54.     <TD>Subject</TD>
  55.     <TD>Posted</TD>
  56. </TR>
  57. <CFOUTPUT query="GetMessages">
  58. <TR>
  59.     <TD>#UserName#</TD>
  60.     <TD>#Subject#</TD>
  61.     <TD>#Posted# <CFIF DateAdd(type, value, posted) LT Now()>EXPIRED</CFIF></TD>
  62. </TR>
  63. </CFOUTPUT>
  64. </TABLE>
  65.  
  66. <FORM action="dateadd.cfm" METHOD="post">
  67.  
  68. <PRE>
  69. How many units? <INPUT TYPE="Text" NAME="value" VALUE="<CFOUTPUT>#value#</CFOUTPUT>">
  70. What kind of unit?
  71.     <SELECT NAME="type">
  72.         <OPTION value="yyyy" SELECTED>years
  73.         <OPTION value="q" >quarter
  74.         <OPTION value="m" >month
  75.         <OPTION value="y" >day of year
  76.         <OPTION value="d" >day
  77.         <OPTION value="w" >weekday
  78.         <OPTION value="ww" >week                        
  79.         <OPTION value="h" >hour
  80.         <OPTION value="n" >minute
  81.         <OPTION value="s" >second
  82.         </SELECT>
  83. </PRE>
  84.  
  85. <INPUT TYPE="Submit" NAME=""><INPUT TYPE="RESET">
  86. </FORM>
  87.  
  88.  
  89. </BODY>
  90.  
  91. </HTML>       
  92.