LassoScript Utility
Basics Browse Detail

[ResultSet] ... [/ResultSet]

Tag Link [ResultSet] ... Category Results
Type Container Source Available Yes
Support Preferred Version 8.5
Change New Data Source Any
Output Type None Security None
Implementation Sets Lasso 8.5

Description

[ResultSet] ... [/ResultSet] returns one of the result sets generated by an inline. This tag accepts a single parameter which determines which result set from the inline should be returned. The number of results generated by an inline can be determined with [ResultSet_Count]. This tag can be called directly within [Inline] ... [/Inline] tags or can be called with an -InlineName parameter to return one of the result sets generated by a named inline.

Within the tag any of the tags that return results from an inline can be used including [Records] ... [/Records], [Records_Array], [Field], [Found_Count], [Shown_Count], etc.

Syntax

[Inline: -Database='Contacts', -SQL='SELECT * FROM People; SELECT * FROM Company;']
[ResultSet: 1]
[Records_Array]
[/ResultSet]
[ResultSet: 2]
[Records]
[Field: 'Name']
[/Records]
[/ResultSet]
[/Inline]

[Inline: -Database='Contacts', -SQL='SELECT * FROM People; SELECT * FROM Company;', -InlineName='mySearch]
[/Inline]
[Loop: (ResultSet_Count: -InlineName='mySearch')]
[ResultSet: Loop_Count, -InlineName='mySearch']
Found [Found_Count] Records in Result Set [Loop_Count].
[/ResultSet]
[/Loop]

Parameters

Optional Parameters
Set Integer value specifies which result set should be returned. Defaults to the first result set.
-InlineName Specifies what inline name the count should be returned for. Defaults to returning information about the surrounding inline.

Examples

See the Lasso 8 Language Guide for examples of how to use this tag.