George, I wrote DataMgr for just this sort of thing. http://www.bryantwebconsulting.com/cfcs/ http://datamgr.riaforge.org/
If you are using OO, then an ORM would be the way to go. Transfer, Reactor, and objectBreeze. I wrote some brief thoughts on different approaches here: http://www.bryantwebconsulting.com/blog/index.cfm/2007/5/25/database_introspection_or_database_definition Brian Rinaldi makes some great comparisons here: http://www.remotesynthesis.com/blog/index.cfm/2007/2/27/Mach-II-or-ColdSpring-Understanding-the-Differences-Between-ColdFusion-Frameworks Hope that helps, Steve > Hey guys, > > We all do them all the time, just good old basic SQL queries. INSERT, > UPDATE etc. However, many times the forms I develop are insanely long... > so writing down all of the field names, and then their values every > time I want to INSERT or UPDATE is a large source of pain for me. Do > you know of any faster way of doing this? Perhaps with a CFC or > something else? Or maybe there are some functions in coldfusion that > do this faster? > > .... > or should I just stop complaining and keep coding :) > > > Thanks, > George C. Linderman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
