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 Philip Arnold - ASP wrote: > On this, try to avoid using CFINSERT and CFUPDATE - they're horrible and > slow, not to mention having memory leaks at times... > > Use real SQL as much as you can > > 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. > ********************************************************************** > > > -----Original Message----- > > From: Jason Miller [mailto:[EMAIL PROTECTED]] > > Sent: 31 May 2002 15:58 > > To: CF-Talk > > Subject: Re: Multiple Record Update > > > > > > On the page that processes just send over the Unique > > identifier/primary key - and all the variables. > > use the <cfupdate tag to update database records. If updating > > multiple tables - On small forms - I just set a cfupdate tag > > for each table and enter the values to be updated. > > Here is an example using access - which I assume since you > > didn't state any other db > > > > <cfupdate > > datasource="datasource" > > tablename="UsersInfo" > > dbtype="ODBC" > > formfields="UserName, Location, Email, Address1, Address2, > > Flr, City, State, Zip, Tele, Fax, CareOf, SpecialInst, > > PPQuestion, PPAnswer, AirportCode"> > > > > <cfupdate > > datasource="datasource" > > tablename="Users" > > dbtype="ODBC" > > formfields="UserName, Password"> > > > > hope this is what you were looking for. > > jay miller > > > > Terry wrote: > > > > > Hi-- > > > > > > I have a form that displays multiple records populated from > > the database. Something like this: > > > > > > Department > > > EmployeeName Add1(text input) Add2(text input) > > City (text input) > > > EmployeeName Add1(text input) Add2(text input) > > City (text input) > > > . > > > . > > > Department > > > EmployeeName Add1(text input) Add2(text input) > > City (text input) > > > EmployeeName Add1(text input) Add2(text input) > > City (text input) > > > . > > > . > > > etc. > > > > > > The question is how to I process this? It passes multiple > > EmployeeID's (from hidden field), but only the text input > > fields if they are populated (they aren't required). > > > > > > I think I've done it before, but I'm brain dead today. > > > > > > TIA > > > > > > Terry > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
