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:296273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
