Bruce, Thanks for your note on this subject. The "IN" syntax you suggested doesn't make it work for me. I am probably being thick.
This is the error message I get (simplified): ------------- ODBC Error Code = 37000 (Syntax error or access violation) Syntax error in UPDATE statement. SQL = "UPDATE tblName SET fld1=1,2,999,999 WHERE recordID in (127,128)" Data Source = "dsn" ------------- This is from a page where I displayed 4 records and selected to edit 2 of them. The action page is taking fld1 from the form page and trying to put in the ENTIRE LIST OF VALUES FROM THE FORM (1,2,999,999) instead of just the value for recordid 128. The sql syntax that I need to get out on the action page for each marked record is like: UPDATE tblName SET fld1=1, fld2=2 WHERE recordID = 128 So if I marked 3 records to be updated it would be like this on the action page: <cfquery name="update" datasource="dsn"> UPDATE tblName SET fld1=1, fld2=2 WHERE recordID = 127 </cfquery> <cfquery name="update" datasource="dsn"> UPDATE tblName SET fld1=1, fld2=2 WHERE recordID = 128 </cfquery> <cfquery name="update" datasource="dsn"> UPDATE tblName SET fld1=1, fld2=2 WHERE recordID = 129 </cfquery> I know this is straightforward and I think I even have some pages where I have done it but I can't for the life of me remember how to do it! Thanks for any more help. Best, Paul Sinclair > -----Original Message----- > From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 07, 2001 11:40 AM > To: CF-Talk > Subject: RE: Updating only records checked on output page > > > on form page: > > <input type="checkbox" value="#recordid#" name="record"> > > on action page: > > update tablename > where someid in (#form.record#) > > > -----Original Message----- > From: Paul Sinclair [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 07, 2001 10:10 AM > To: CF-Talk > Subject: Updating only records checked on output page > > > I have an output page that may have dozens or hundreds of > records on it. I want to put all the records into a single > form with a checkbox by each record so that a user can: edit > any or all records on the page; click the checkbox to > identify the records modified; and submit the form to a page > that will loop through all the checked records and update > them. I think this is an easy thing but I have some kind of > mental block preventing me from figuring it out! > > The output page is something like this: > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
