+1 I feel exactly the same way and still write my SQL statements myself. IMO it's necessary when you start getting into multiple advanced joins, computed columns and inline equations.
On Thu, Sep 23, 2010 at 11:38 AM, Jason Fisher <[email protected]> wrote: > > 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 Bears 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:337398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
