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
