Tagged as HQL
Saturday, December 8, 2012 Xindi CMS version 2012.12.8 released
The latest version of Xindi CMS is available to download from GitHub. Changes include an upgrade to the latest release of DI/1. Xindi is a small, lightweight and flexible CFML content management system. It's great for web developers looking for a simple way to make site content editable by their clients. Open source, free and flexible, Xindi is a great choice for your next web...
Read more »Wednesday, May 2, 2012 Returning yesterday's records in HQL using ColdFusion
A quick follow up to my previous post, 'Returning yesterday's records in MySQL', here is how to do the same task in HQL. Sadly HQL lacks a DateAdd method so yesterday's date needs to be created outside of the query. <cfscript> var yesterday = DateAdd( "d", -1, CreateDate( Year( Now() ), Month( Now() ), Day( Now() ) ) ); var orders = ORMExecuteQue...
Read more »