[Encode_SQL] takes a single argument which is a string to be encoded. It encodes any characters which are reserved in SQL statements by placing a backslash before them.
This tag can be used to encode a string value within a SQL statement. It should not be used on an entire SQL statement.
[Encode_SQL: 'String Parameter']
[Inline: -SQL='SELECT * FROM Database.Table WHERE field LIKE \'' +
(Encode_SQL: 'String Parameter') + '\';']
...
[/Inline]
See the Lasso 8 Language Guide for examples of how to use this tag. This tag is documented on page 368.
Tag Link | [Encode_SQL] | Category | Encoding |
---|---|---|---|
Type | Substitution | Data Source | Any |
Support | Preferred | Version | 6.0 |
Output Type | String | Security | Tag |
Implementation | Internal | Sets | Lasso 6.0 |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft