Lasso Soft Inc. > Home

[Encode_SQL]

[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.

  • Syntax
  • Parameters
[Encode_SQL: 'String Parameter']

[Inline: -SQL='SELECT * FROM Database.Table WHERE field LIKE \'' + 
    (Encode_SQL: 'String Parameter') + '\';']
  ...
[/Inline]
Required Parameters
String Value The string value to be encoded.
Examples

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. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft