thanks! but then i juz realise that Coldfusion will automatically handle this part ONLY IF i do not use the form variable directly. I need to assign that form variable to another variable before setting it into DB. Then it works automatically. !
> -----Original Message----- > From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 20, 2001 11:44 AM > To: CF-Talk > Subject: Re: How to save single quotes into DB > > > In SQL you would have to have 2 single quotes for it to > insert properly IE > Hard Copy Rec'd would be 'Hard Copy Rec''d' > > You can use REReplaceNoCase to do it.... > > <cfoutput>#REReplaceNoCase("joseph's","'","''","ALL")#</cfoutput> > > > > > ----- Original Message ----- > From: "JAIME HOI" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, November 19, 2001 7:08 PM > Subject: How to save single quotes into DB > > > > hi > > I hit this error while trying to save this string "Hard > Copy Rec'd " > > from an input text. > > ORA-01756: quoted string not properly terminated > > SQL = Update table set remks = ' Hard Copy Rec'd ' ; > > > > Is there any function in COldfusion that can escape reading the > > single quotes in the string so i can > > successfully save the whole string Hard Copy Rec'd > (including the single > > quotes) into DB? > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists