LassoScript Utility
Basics Browse Detail

[Records] ... [/Records]

Tag Link [Records] ... Category Database
Type Container Source Available No
Support Preferred Version 3.0
Change Unchanged Data Source Any
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

Description

[Records] ... [/Records] loops through each record in a found set. Synonym is [Rows] ... [/Rows].

Optional -InlineName parameter specifies that results should be returned from a named inline. However, in Lasso 8.5 and later it is preferred to use the [ResultSet] ... [/ResultSet] tags to access the results of a named inline.

Syntax

[Records]
 ...  [Field: 'Field_Name'] ...
[/Records]

[Inline: ...]
  [Records]
    ... [Field: 'Field_Name'] ...
  [/Records]
[/Inline]

[ResultSet: -InlineName='Inline_Name']
  [Records]
    ... [Field: 'Field_Name'] ...
  [/Records]
[/ResultSet]

[Records-InlineName='Inline_Name']
  ... [Field: 'Field_Name'] ...
[/Records]

Parameters

Optional Parameters
-InlineName The name of an inline whose results should be returned by the records tag. If omitted, defaults to returning results from the nearest enclosing inline or Lasso action.

Examples

To display search results within an inline:

Use the [Records] ... [/Records] tags. The following example finds all records in the People table of the Contacts database and formats the result.

[Inline: -FindAll,
    -Database='Contacts',
    -Table='People']
  [Records]
    <br>[Field: 'First_Name'] [Field: 'Last_Name']
  [/Records]
[/Inline]

<br>John Doe
<br>Jane Doe
<br>John Surname
<br>Mary Peoples