Product Logo

CNS Query

Query your databases without relationships.

Functions

CNSQuery_EscapeQuotes

NameCNSQuery_EscapeQuotes
Description

This is a utility function that takes raw Text and conforms it to what the ExecuteSQL function needs in order to function correctly. It turns any Backward Slashes (  ) into a double-Backward Slash ( \\ ) and turns any Single Quotes ( ' ) into Backward Slash-Single Quote ( ' ).

Return TypeText
FormatCNSQuery_EscapeQuotes ( Text )
Required Parameters
Text

The Text to conform to what ExecuteSQL needs.

Example
Example 1

Returns "I can\'t seem to find the backslash (\\) on my keyboard."

CNSQuery_EscapeQuotes( "I can't seem to find the backslash (\) on my keyboard." )