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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to