RE: Multiple Record Update

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

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

RE: Multiple Record Update

. 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

Re: Multiple Record Update

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

RE: Multiple Record Update--Resolved

Thanks Phillip, That got me going in the right direction. *** REPLY SEPARATOR *** On 5/31/02 at 3:03 PM Philip Arnold - ASP wrote: I have a form that displays multiple records populated from the database. Something like this: Department EmployeeName Add1(text

RE: Multiple Record Update

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

RE: Multiple Record Update--Resolved

Thanks Phillip, That got me going in the right direction. No probs, glad to help 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