You may have to replace the " in the comments field with the html equivalent, " before you insert.
-----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 10:12 AM To: CF-Talk Subject: RE: Single Quote in Multiple Record Update - not yet Whoops, typo! It's correct on the actual page. Actually, it only the comments field that's the problem - everything else is fine. The update is actually much larger than the example - probably 50 fields. Query works great until somebody puts something like "I can't figure this" into the comments field... For my update multiple records problem with single quotes: <CFOUTPUT> <CFLOOP index="thisID" list="#FORM.ProjID#"> <CFQUERY NAME="update" datasource="creati610.data"> UPDATE INT_PROJECT FORM_NUM= '#evaluate("FORM.NUM_#thisID#")#', DUE_DATE= '#evaluate("FORM.DUE_DATE_#thisID#")#', COMMENTS= '#evaluate("FORM.COMMENTS_#thisID#")#' WHERE ID = #thisID# </CFQUERY> </CFLOOP> </CFOUTPUT> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
