Actually, I don't use ORM for much the same reason I don't use cfinsert / cfupdate. I still like to craft my SQL and I often have complex relationships that are easy to write in SQL and a PITA to model in an ORM.
- Jason "Smokey the Bearâs rules for fire safety also apply to government: Keep it small, keep it in a confined area, and keep an eye on it." ---------------------------------------- From: "Russ Michaels" <[email protected]> Sent: Thursday, September 23, 2010 11:30 AM To: "cf-talk" <[email protected]> Subject: RE: cfinsert/cfupdate That's a good point I didn't consider that ORM is just doing the same thing. And I bet you are all happily using Transfer and Reactor in the same way. Russ -----Original Message----- From: Justin Scott [mailto:[email protected]] Sent: 23 September 2010 16:27 To: cf-talk Subject: RE: cfinsert/cfupdate > For me I like to be able to have as much control over my > query statements as possible. It makes it easier to read/ > understand and to see EXACTLY what is being sent to the db. While I generally agree with that sentiment, ORM does the same thing on a more grand scale, and I haven't seen anyone railing against using that technology. Personally it's been many years since I last looked at cfinsert/cfupdate, but if the queries that they generate are 'safe' then it might be worth taking another look at as an option to use where appropriate. -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

