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