-SkipRows
-SkipRows specifies the offset into the records which should be returned from a -Search or -FindAll action. The default is 1 if no -SkipRows tag is specified so the first record will be returned. Synonym is -SkipRecords.
This tag can be used in concert with the -MaxRows tag to page through a found set.
The value specified for this command tag can be retrieved using the [SkipRows_Value] tag.
- Syntax
- Parameters
[Inline: -SkipRows=SkipRows_Value, ...]
<a href="default.lasso?-SkipRows=SkipRows_Value&...">Link</a>
<form action="default.lasso" method="POST">
<input type="hidden" name="-SkipRows" value="SkipRows_Value">
...
</form>Examples
To specify the offset into the found set for a database action:
Use the -SkipRows command tag. The following example specifies a -Search action in [Inline] ... [/Inline] tags. The second record in the found set is returned since -SkipRows=1 is specified. Only one record is returned since -MaxRows=1 is specified.
[Inline: -Search,
-Database='Contacts',
-Table='People',
-MaxRows=1,
-SkipRows=1,
'First_Name'='John']
[Records]
<br>[Field: 'First_Name'] [Field: 'Last_Name']
[/Records]
[/Inline]Result:
<br>John Surname
| Tag Link | -SkipRows | Category | Database |
|---|---|---|---|
| Type | Command | Data Source | Any |
| Support | Synonym | Version | 3.0 |
| Output Type | None | Security | None |
| Implementation | LCAPI | Sets | Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x |
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 | Privacy | Legal terms and Shipping | Contact LassoSoft