Difference between revisions of "STR ESCAPE()"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Function to return escape out or disallow certain string contencts ==Syntax== STR_ESCAPE(<expC>) ==See Also== ASC(), AT(), ATNEXT(), CHR(), CHR...") |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
| − | Function to return | + | Function to return a string where certain characters or strings have been escaped out or removed |
==Syntax== | ==Syntax== | ||
Latest revision as of 12:22, 2 March 2017
Contents
Purpose
Function to return a string where certain characters or strings have been escaped out or removed
Syntax
STR_ESCAPE(<expC>)
See Also
ASC(), AT(), ATNEXT(), CHR(), CHRTRAN(), DECODE(), ENCODE(), HTML_ENTITIES(), HTML_ENTITY_DECODE(), INLIST(), LEFT(), OCCURS(), RAT(), RIGHT(), STR(), STR_ESCAPE(), STR_REPLACE(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()
Description
The STR_ESCAPE() function will search <expC> and return a string where certain characters or strings have been escaped out or removed.
- Single quotes are escaped out as to enable embedding within strings
- Embedded SQL statements are disallowed to prevent SQL injection attacks
Example
? str_escape("Grocer's apostrophe") Grocer''s apostrophe
