> Really? Even for just the small forms? - this works quite > quickly on the small forms - upon clicking submit I see the > confirmation page instantly. > > I'll keep that in mind though.... the SQL is more powerful anyhow
What you've got to remember is that CFUPDATE is ugly, code wise, it does all of the standard Replace(myField,"'","''","all") For you, but you have to pass it all sorts of things like the identity (which it has to work out on the table), while real SQL can have a big WHERE clause CFINSERT and CFUPDATE are "theoretically" depreciated commands... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
