CFINSERT and CFUPDATE are nice shortcuts, but they're wierd. You're required to have your variable names match the exact column names in the DB, which, unless you have planned for that from the beginning, almost always requires you to write unnecessary <cfset applicationVar = translatedDBVar> code to get everything in order before calling the tag.
Honestly, I don't use CFINSERT or CFUPDATE for the same reason I don't use CFQUERY if I can avoid it. Using a stored proc is just the least ambiguous way to get data in and out of a CF web application in my experience. YMMV. - Jim Damien McKenna wrote: >OK, I'll bite. Why would you *not* use standard CFML tags for the >purpose they fullfill? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54