SHARE
TWEET

Untitled

a guest Jun 18th, 2019 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2019
  2.   February
  3.       Day
  4.      
  5. <cfquery name="nchklist" datasource="#fds#">
  6.     SELECT year(chkdate) AS Year, month(chkdate) AS month, day(chkdate) AS day, vcheck
  7.     FROM vchk
  8.     where vid = '#vid#' and final = 1
  9.     ORDER BY year, month, day
  10. </cfquery>
  11.  
  12. <cfoutput query="nchklist" group="year">
  13.  
  14.     <cfoutput group="month">
  15.         #monthAsString(month)#
  16.  
  17.         <cfoutput group="day">
  18.             <a href="create_report.cfm?vcheck=#vcheck#">View</a> :  DateFormat(chkdate, 'dddd - mmmm d, yyyy')#<br>
  19.         </cfoutput>
  20.  
  21.     </cfoutput>
  22.  
  23. </cfoutput>
  24.      
  25. ORDER BY year(chkdate), month(chkdate), day(chkdate)
  26.      
  27. SELECT year(chkdate) AS TheYear
  28.         , month(chkdate) AS TheMonth
  29.         , day(chkdate) AS TheDay
  30.         , vcheck
  31.  FROM   vchk
  32.  WHERE  vid = <cfqueryparam value="#vid#" cfsqltype="cf_sql_varchar">
  33.  AND    final = 1
  34.  ORDER BY TheYear, TheMonth, TheDay
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top