Direct him to Microsoft Front Page or Dreamweaver if he feels like giving up all his granular control.
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. Sounds to me like your friend is just lazy. On Thu, Sep 23, 2010 at 11:08 AM, Rick Root <[email protected]> wrote: > > I've been trying to convince one of my friends that using cfinsert and > cfupdate is a bad idea. > > I recently told him that real CF programmers don't use cfinsert and > cfupdate :) He responded with this: > > CF8 uses cfqueryparam inside all cfinsert/cfupdate statements, making > it just as safe as a regular cfquery, but minus all the clunky code > needed to create the query. Actually, scratch that, both queries, > since without them you have to maintain both the insert and update > statements separately if you add a new form field to a form. cfinsert > can do in one line of code what otherwise could be hundreds, not to > mention saving you all the ridiculous potential errors from not having > commas in the correct place, accidentally using or not using quotes, > or mis-matching insert values since the syntax of inserts is different > from updates and the two lines you need to add can often be quite far > apart. Call me proud to not be a real cf programmer. > > I just don't know how to respond to this. > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:337383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

