PreserveSingleQuotes()

edit

Returns back string without letting the engine escape the single quotes. Used within CFQUERY blocks usually

PreserveSingleQuotes( string=string );

Returns: String

Argument Description
string
string, required 		edit

Variable that contains a string in which to preserve single-quotation marks.

Examples

edit 
  name_for_query = "Mr. Frank O'Brian";
  dump(PreserveSingleQuotes(name_for_query));

See also