code

QUICK COOL QUERY FROM PAUL!

Leave a comment

<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>

Related Posts

Leave a Reply