Tag Link | -Op | Category | Operator |
---|---|---|---|
Type | Command | Source Available | No |
Support | Abbreviation | Version | 3.0 |
Change | Unchanged | Data Source | Any, Lasso MySQL |
Output Type | None | Security | None |
Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0, Lasso 3.x |
BW - Begins With.
EW - Ends With.
CN - Contains.
LT - Less Than.
LTE - Less Than or Equals.
GT - Greater Than.
GTE - Greater Than or Equals.
EQ - Equals.
NEQ - Not Equals.
The following operators may be used with MySQL data sources in Lasso Professional 6 and higher:
FT - Full Text Search
RX - Regular Expression Search
NRX - (Not) Regular Expression Search
[Inline:
<a href= "default.lasso?
<form action="default.lasso" method="POST">
<input type="hidden" name="
<input type="text" name="Field_Name" value="Value">
...
</form>
Required Parameters | |
---|---|
Operator | The field matching operator. One of BW, EW, CN, LT, LTE, GT, GTE, EQ, NEQ. |
To specify what field-level operator to use in a database action:
Use the
[Inline:
'First_Name'='Beth']
[Records]
<br>[Field: 'First_Name'] [Field: 'Last_Name']
[/Records]
[/Inline]
<br>Beth Surname
<br>Mary Beth LastName
To perform a full-text search on a field in MySQL:
If a MySQL field is indexed as full
Mike
Jane
\0
To use regular expressions as part of a MySQL search:
Regular expressions can be used as part of a search value for a field by using
Lastname, Mike
Lastname, Mary Beth
\0
Substitution | ||
---|---|---|
|
| |
Command | ||
|
|