LassoScript Utility
Basics Browse Detail

-OpEnd

Tag Link -OpEnd Category Operator
Type Command Source Available No
Support Abbreviation Version 2.0
Change Unchanged Data Source 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, Lasso 2.0, CDML4

Description

-OpEnd is required for each -OpBegin tag which is included in an action. The logical operator specified in the -OpBegin tag is in effect until the matching -OpEnd tag is reached.

The operator specified in the -OpEnd tag is optional, but should be specified as the same operator in the matching -OpBegin tag for best results.

Note: This tag is not supported with FileMaker Pro data sources due to limitations of the FileMaker Web Companion.

Syntax

[Inline: -OpBegin=Operator, ... , -OpEnd=Operator]

<a href="default.lasso?-OpBegin=Operator&...&-OpEnd=Operator">Link</a>

<form action="default.lasso" method="POST">
  <input type="hidden" name="-OpBegin" value="Operator">
  ...
  <input type="text" name="-OpEnd" value="Operator">
</form>

Parameters

Optional Parameters
Operator The logical operator. Should match the operator specified in -OpBegin. One of AND, OR, or NOT.

Examples

To specify a complex search in a database action:

Use the -OpBegin and -OpEnd command tags. The following example specifies a -Search action in [Inline] ... [/Inline] tags. Records which have Last_Name of Doe and are not female are returned. The exclusion of records for women is done by surrounding the name/value pair for the Sex field with -OpBegin='NOT' and -OpEnd='NOT'.

[Inline: -Search,
    -Database='Contacts',
    -Table='People',
    'Last_Name'='Doe',
    -OpBegin='NOT',
      'Sex'='Female',
    -OpEnd='NOT']
  [Records]
    <br>[Field: 'First_Name'] [Field: 'Last_Name']
  [/Records]
[/Inline]

<br>John Doe