Raj KAJ (scottobear) wrote,
Raj KAJ
scottobear

quick cool query from Paul!

<cfprocessingdirective suppresswhitespace="yes">
<cfinclude template="/includes/hep/header.cfm" />
<a name="content" id="content"></a>
<div id="pagecontents">
<cfoutput><h1>#page_title#</h1>
<cfif #page_subtitle# neq ""><h2>#page_subtitle#</h2></cfif></cfoutput>

<cfdirectory action=”list” directory=”#expandpath(“.”)#” name=”digests” filter=”he*.cfm”>

<cfset issues = querynew(“issuemo,issueday,issueyear,file”,”integer,integer,integer,varchar”)>
<cfoutput query=”digests”>
<cfset prename = listfirst(replace(name,”he”,”"),”.”)>
<cfset month = left(prename,2)>
<cfset day = mid(prename,3,2)>
<cfset year = right(prename,2)>
<cfset queryaddrow(issues)>
<cfset querySetCell(issues, “issuemo”, month)>
<cfset querySetCell(issues, “issueday”, day)>
<cfset querySetCell(issues, “issueyear”, year)>
<cfset querySetCell(issues, “file”, name)>
</cfoutput>

<cfquery name=”showissues” dbtype=”query”>
SELECT issuemo, issueday, issueyear, file
FROM issues
ORDER BY issueyear DESC, issuemo DESC, issueday
</cfquery>

<cfoutput query=”showissues” group=”issueyear”>
<h2>20#issueyear#</h2>
<cfoutput group=”issuemo”>
<h3>#MonthAsString(issuemo)#</h3>
<ul>
<cfoutput>
<cfset filename = issuemo & “/” & issueday & “/” & issueyear>
<li><a href=”#file#”>#dateformat(filename,”mmmm dd, yyyy”)#</a></li>
</cfoutput>
</ul>
</cfoutput>
</cfoutput>

<!—
<h2>2015</h2>
<h3>August</h3>
<ul>
<li><a href=”/livability/he_digest/he082715.cfm”>August 27, 2015</a> <cfoutput>#newtag(“n”,”8/27/2015″)#</cfoutput></li>
<li><a href=”/livability/he_digest/he081315.cfm”>August 13, 2015</a></li>
</ul>
<h3>July</h3>
<ul>
<li><a href=”/livability/he_digest/he073015.cfm”>July 30, 2015</a></li>
<li><a href=”/livability/he_digest/he071615.cfm”>July 16, 2015</a></li>
<li><a href=”/livability/he_digest/he070215.cfm”>July 2, 2015</a></li>
</ul>
<h3>June</h3>
<ul>
<li><a href=”/livability/he_digest/he061815.cfm”>June 18, 2015</a></li>
</ul>
<h3>May</h3>
<ul>
<li><a href=”/livability/he_digest/he052115.cfm”>May 21, 2015</a></li>
<li><a href=”/livability/he_digest/he050715.cfm”>May 07, 2015</a></li>
</ul>
<h3>April</h3>
<ul>
<li><a href=”/livability/he_digest/he042315.cfm”>April 23, 2015</a></li>
<li><a href=”/livability/he_digest/he040915.cfm”>April 9, 2015</a></li>
</ul>
<h3>March</h3>
<ul>
<li><a href=”/livability/he_digest/he032615.cfm”>March 26, 2015</a></li>
<li><a href=”/livability/he_digest/he031215.cfm”>March 12, 2015</a></li>
</ul>
<h3>February</h3>
<ul>
<li><a href=”/livability/he_digest/he022615.cfm”>February 26, 2015</a></li>
<li><a href=”/livability/he_digest/he021215.cfm”>February 12, 2015</a></li>
</ul>
<h3>January</h3>
<ul>
<li><a href=”/livability/he_digest/he012915.cfm”>January 29, 2015</a></li>
<li><a href=”/livability/he_digest/he012215.cfm”>January 22, 2015</a></li>
<li><a href=”/livability/he_digest/he011515.cfm”>January 15, 2015</a></li>
<li><a href=”/livability/he_digest/he010815.cfm”>January 8, 2015</a></li>
<li><a href=”/livability/he_digest/he010115.cfm”>January 1, 2015</a></li>
</ul>
<h2>2014</h2>
<h3>December</h3>
<ul>
<li><a href=”/livability/he_digest/he121814.cfm”>December 18, 2014</a></li>
<li><a href=”/livability/he_digest/he121114.cfm”>December 11, 2014</a></li>
<li><a href=”/livability/he_digest/he120514.cfm”>December 5, 2014</a></li>
</ul>
<h3>November</h3>
<ul>
<li><a href=”/livability/he_digest/he112014.cfm”>November 20, 2014</a></li>
<li><a href=”/livability/he_digest/he111314.cfm”>November 13, 2014</a></li>
<li><a href=”/livability/he_digest/he110614.cfm”>November 6, 2014</a></li>
</ul>
<h3>October</h3>
<ul>
<li><a href=”/livability/he_digest/he103014.cfm”>October 30, 2014</a></li>
<li><a href=”/livability/he_digest/he102314.cfm”>October 23, 2014</a></li>
<li><a href=”/livability/he_digest/he101614.cfm”>October 16, 2014</a></li>
<li><a href=”/livability/he_digest/he100914.cfm”>October 9, 2014</a></li>
<li><a href=”/livability/he_digest/he100214.cfm”>October 2, 2014</a></li>
</ul>
<h3>September</h3>
<ul>
<li><a href=”/livability/he_digest/he092514.cfm”>September 25, 2014</a></li>
<li><a href=”/livability/he_digest/he091814.cfm”>September 18, 2014</a></li>
<li><a href=”/livability/he_digest/he091114.cfm”>September 11, 2014</a></li>
<li><a href=”/livability/he_digest/he090414.cfm”>September 4, 2014</a></li>
</ul>
<h3>August</h3>
<ul>
<li><a href=”/livability/he_digest/he082814.cfm”>August 28, 2014</a></li>
<li><a href=”/livability/he_digest/he082114.cfm”>August 21, 2014</a></li>
<li><a href=”/livability/he_digest/he081414.cfm”>August 14, 2014</a></li>
<li><a href=”/livability/he_digest/he080714.cfm”>August 7, 2014</a></li>
</ul>
<h3>July</h3>
<ul>
<li><a href=”he073114.cfm”>July 31, 2014</a></li>
<li><a href=”he072414.cfm”>July 24, 2014</a></li>
<li><a href=”he071714.cfm”>July 17, 2014</a></li>
<li><a href=”he071014.cfm”>July 10, 2014</a></li>
<li><a href=”he070314.cfm”>July 3, 2014</a></li>
</ul>
<h3>June</h3>
<ul>
<li><a href=”he062614.cfm”>June 26, 2014</a></li>
<li><a href=”he061914.cfm”>June 19, 2014</a></li>
<li><a href=”he061214.cfm”>June 12, 2014</a></li>
<li><a href=”he060514.cfm”>June 5, 2014</a></li>
</ul>
<h3>May</h3>
<ul>

<li><a href=”he052914.cfm”>May 29, 2014</a></li>
<li><a href=”he052214.cfm”>May 22, 2014</a></li>
<li><a href=”he051514.cfm”>May 15, 2014</a></li>
<li><a href=”he050814.cfm”>May 8, 2014</a></li>
<li><a href=”he050114.cfm”>May 1, 2014</a></li>
</ul>
<h3>April</h3>
<ul>
<li><a href=”he042414.cfm”>April 24, 2014</a></li>
<li><a href=”he041714.cfm”>April 17, 2014</a></li>
<li><a href=”he041014.cfm”>April 10, 2014</a></li>
<li><a href=”he040314.cfm”>April 3, 2014</a></li>
</ul>—>
</div></div>
<cfinclude template=”/includes/moddate.txt” />
<cfinclude template=”/includes/hep/footer.cfm” />
</cfprocessingdirective>

Originally published at The Scotto Grotto. You can comment here or there.

Tags: uncategorized
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 0 comments