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
