George, I'll like to suggest you to use DataMgr. DataMgr is a great time saver tool and could be the answer to your needs. In your case just name your form fields with the same name in database and DataMgr will do the heavy work for you.
http://datamgr.riaforge.org/ Cheers Marco Antonio C. Santos On Jan 9, 2008 3:33 PM, Jerry Guido <[EMAIL PROTECTED]> wrote: > I use SQL.cfc. http://sqlcfc.riaforge.org/ > > It is MSSQL Server only. I ported it to MySQL... well sorta. It is CF8 > only (CFDbinfo) at the moment, I haven't had the time to make it a pure > SQL version nor has it been tested in a production environment. Let me > know if you are interested and I can send you a copy. I also have a > helper CFC that will combine form and URL vars (cookies and session vars > too) into a single struct (takes a lot of the grunt work out of using > SQL.cfc. > > I use transfer too but with SQL.cfc you can do all your Crud functions > with one line of code. > > I used Squid head as well for quick cruds. > > > Jerry Guido > Programmer > MGT of America, Inc. > [EMAIL PROTECTED] > > The information contained in this electronic communication is intended > only for the use of the addressee, and may be a confidential > communication. If you are not the intended recipient, you are hereby > notified that you have received this transmittal in error; any review, > dissemination, distribution or copying of this transmittal is strictly > prohibited. > > > -----Original Message----- > From: Todd [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 09, 2008 12:13 PM > To: CF-Talk > Subject: Re: CFC, Custom tag, or something for tedious SQL Queries? > > Break up the form into forms? > > On Jan 9, 2008 11:56 AM, George Linderman wrote: > > > 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 > > > > -- > ~Todd Rafferty > http://www.web-rat.com/ > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:296278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
