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
