MMQuery

Query your databases without relationships.

<- Back to MMQuery function list

MMQuery_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 Type
Text
Format
MMQuery_EscapeQuotes ( Text )
Required Parameters
  • Text

    The Text to conform to what ExecuteSQL needs.

Related Items
MMQuery_ExecuteSQL, MMQuery_ExecuteSQLEx
Example

Code:

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

Result:

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