Hi Viktor Thanks so much for that. It is a much better method than what I was proposing! I am getting a 'Syntax error in UPDATE statement' error when I run the code but should be able to work that one out.
Thanks again for your help. Cheers Marika -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 March 2003 11:43 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Updating Multiple Rows simoultaneously - Help! This email is to be read subject to the disclaimer below. Hi Marika, Is this what you're looking for? (warning: it's untested so there might be some typos) <cfquery name="Tasks" datasource="Hum" dbtype="ODBC"> SELECT ID, Coordinator FROM Humtest </cfquery> <cfquery name="InsertCoord" datasource="Hum" dbtype="ODBC"> UPDATE Humtest SET Coordinator WHERE ID IN (<cfqueryparam value="#ValueList(Tasks.ID)#" cfsqltype ="cf_sql_integer" list="yes">) </cfquery> Cheers, Vik --------------------- Viktor Radnai Web Developer, National E-Commerce, Ernst & Young Direct: +61 2 9248 4361 Marika Auret <[EMAIL PROTECTED] To: "CFAussie Mailing List" <[EMAIL PROTECTED]> u> cc: Sent by: Subject: [cfaussie] Updating Multiple Rows simoultaneously - Help! [EMAIL PROTECTED] mon.com.au 26/03/2003 02:36 PM Please respond to "CFAussie Mailing List" Hi Everyone Hoping someone can help me with this one - what is the best format for updating several rows in a database simoultaneously with values put into a web form? I have a web form setup that lists the records of a database with one of the fields (a text field) being updateable. I want to be able to add content to the text field for each record and then to update it in the database in one hit. I have tried using a cfloop but it doesn't update the correct record/s. I am using Access. Here is a sample of the code for the form action page: <cfquery name="Tasks" datasource="Hum" dbtype="ODBC"> SELECT ID, Coordinator FROM Humtest </cfquery> <cfloop query="Tasks"> <cfquery name="InsertCoord" datasource="Hum" dbtype="ODBC"> INSERT INTO Humtest (Coordinator) VALUES ('#Form.Coordinator#') </cfquery> </cfloop> I have tried putting in a WHERE statement but can't make it work, and I am not even sure that the above code is the best format to use. I have a hidden form field to capture the ID (the primary key) info on the form itself. There is probably a very easy solution for this - but it has been one of those days already! Thanks a million, in advance, for any advice Cheers Marika --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ -------------------- NOTICE - This communication contains information which is confidential and the copyright of Ernst & Young or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone Ernst & Young on 1800 655 717 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of Ernst & Young. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of Ernst & Young. Except as required at law, Ernst & Young does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. Liability limited by the Accountants Scheme, approved under the Professional Standards Act 1994 (NSW) -------------------- --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
