LassoScript Utility
Basics Browse Detail

-SkipRows

Tag Link -SkipRows Category Database
Type Command Source Available No
Support Synonym 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

-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

[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>

Parameters

Required Parameters
SkipRows_Value Specifies the offset into the records to be returned.

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]

<br>John Surname