title: Coldfusion, outputting SQL results grouped by Date Grouping, Today, Yesterday, This Week, etc
body: <p>I'm hitting the DB for a 100 records from a MySQL DB that have a DateAdded (timestamp) column. </p>
  
  <p>I'd like to find a SMART way to display the records as follows in Coldfusion, w/o hitting the database multiple times.</p>
  
  <p>Today:
  - records.....
  Yesterday:
  - records.....
  Earlier This Week:
  - records.....
  Earlier This Month:
  - records.....
  Older:
  - records.....</p>
  
  <p>Thanks for the ideas on how to get this done smartly in ColdFusion.</p>