Should you use pure CF-ORM or a mixture of CF-ORM and SQL

I have been meaning to write this up for some time now, and haven't had the time to do so. One of the things that I found when learning CF-ORM for the first time, was it was very over whelming  to say the least and a lot of questions would come from trying to use it.

Now 2 years down the track and I can say that there are times to use it and times not to use it, and it all boils down to whether you want the application to be scalable or you just don't care, because you know the amount of traffic will never get that high to matter.

Either way I want to touch on some things that I did discover, where I quickly changed my thinking as I went along.

Filtering data with Hibernate

In a previous post I touched on how you can use hibernate to return paginated data, today I am going to show how to use hibernate to filter the results returned from a query.

Pagination with Hibernate

One of the things that has never really been easy is pagination within Coldfusion. And we all now know that Hibernate will be part of the core of Coldfusion now, but what we dont know is how much easier this will make our work.

With the addition to some extra coding by Barney he has written cfgroovy which also allows for the adoption of hibernate in Coldfusion now.