ColdFusion 9 and the ORM a simple example.

The ORM in ColdFusion 9 makes things easy. Now lets consider a website that has a section on the side displaying current news items
and lets say it always displays the last 2 most recent news items. As a query this would be:
<br /> select top (2) newsItem, date<br /> from tableName<br /> order by id desc<br />
This works great in Microsoft SQL server but what about MYSQL?
<br /> select newsItem, date<br /> from tableName<br /> order by id desc<br /> limit 2<br />
OK now I have 2 set's of code. More Database Support means more code but ColdFusion should = less code. Here is where the ORM can make this sort of thing a breeze:

So this 1 line of code :
<br /> loadLastTwo = EntityLoad('NewsItem',{},'id desc',{maxResults=2}) ;<br />
can now replace:
<br /> <cfif application.dbType eq "MSSQL"><br /> <cfquery name="last2AsQuery" datasource="application.dsn"><br /> select top (2) news, date<br /> from newsItem<br /> order by id desc<br /> </cfquery><br /> <cfelse><br /> <cfquery name="last2AsQuery" datasource="application.dsn"><br /> select news, date<br /> from newsItem<br /> order by id desc<br /> limit 2<br /> </cfquery><br /> </cfif><br />

Here is the code used for testing. With the ORM is simply a matter of creating an empty datasource with the database of your choice setting the dialect in Application.cfc and the ORM will even make the table for you you don't even need to load up Enterprise manager or phpmyadmin. I tested this on both MSSQL and MYSQL.
index.cfm

NewsItem.cfc

Application.cfc


The final result:



Oh and here is the link to the excellent docs at Adobe

Also make sure if you write your own constructors to specify default values or the ORM will cause some errors about not passing in values when it creates the objects behinds the scenes.