Aliaspooryorik Musings Posts

Aliaspooryorik

Dates with day suffix in ColdFusion ORM

12 Jul 2011

I often need to display dates where the day has a suffix such as 1st, 2nd, 3rd, 4th. This is a pain to do in CFML as ColdFusion's DateFormat doesn't support it. However, all is not lost! Read more »

View ORM queries in page debugging

21 Jun 2011

I really like the new ORM features of ColdFusion, but I want to see the ORM queries in my standard ColdFusion debugging template. Read more »

ORM hibernate sessions

18 Apr 2011

I see quite a lot of confusion about how hibernate sessions work in ColdFusion 9's ORM. So I thought I'd put together various examples to see what happens. Read more »

Storing ORM Entities in the session scope

17 Feb 2011

I've just been trying to debug an error with ColdFusion ORM. I'm building a booking system and decided to store the new Booking Entity in the session scope until the final stage of the process at which point I'd call EntitySave. Read more »

HQL tip - use a HashMap

13 Sep 2010

When you use HQL, you can choose to select specific properties from an entity (for performance) and also if you want to get aggregate values (such as count and sum). The problem with doing this is that you end up with an array of arrays which isn't very nice to work with. To solve this probblem you can use a map which is similar to a good old ColdFusion struct. Read more »

View HQL in your ColdFusion debugging info

20 Aug 2010

I just tried out the new to CF9.01, ability to write HQL statements in a cfquery tag and found that if you have ColdFusion debugging turned on, then you actually get the HQL outputted. Read more »

ORM Sample Blog Updated to CF9.01

21 Jul 2010

The port I did of Mark Mandel's tBlog to hibernate ORM has now been updated to include some CF9.01 goodies. Read more »

EntityToQuery does not return a ColdFusion Query

22 Jun 2010

You can't use Query of Queries with the result returned from EntityToQuery. Read more »

SQL to HQL slides from Scotch on the Rocks

31 May 2010

I've uploaded the slides from my Scotch on the Rocks presentation on SQL to HQL. Although I've gone for a "presentation zen" style, I've added quite a few notes for the slides and attached sample code so I hope it is useful! Read more »

ORM article on DZone

28 May 2010

I co-authored an article with, the very smart guy that is, Bob Silverberg for DZone. You can read "An Introduction to ColdFusion Object-Relational Mapping" on the DZone website. Read more »

« Previous Page Next Page »

Search

Wish List

Found something helpful & want to say ’thanks‘? Then visit my Amazon Wish List :)