Margaret Fisk wrote: > You may have to replace the " in the comments field with the html > equivalent, > " before you insert.
You should use CFQUERYPARAM. It also makes your query a slight bit faster. > -----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> > > > ______________________________________________________________________ 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
