LassoScript Utility
Basics Browse Detail

-SkipRecords

Tag Link -SkipRecords Category Database
Type Command Source Available No
Support Preferred Version 2.5
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, Lasso 2.5

Description

-SkipRecords specifies the offset into the records which should be returned from a -Search or -FindAll action. The default is 1 if no -SkipRecords tag is specified so the first record will be returned. Synonym is -SkipRows.

This tag can be used in concert with the -MaxRecords tag to page through a found set.

The value specified for this command tag can be retrieved using the [SkipRecords_Value] tag.

Syntax

[Inline: -SkipRecords=SkipRecords_Value, ...]

<a href="default.lasso?-SkipRecords=SkipRecords_Value&...">Link</a>

<form action="default.lasso" method="POST">
  <input type="hidden" name="-SkipRecords" value="SkipRecords_Value">
  ...
</form>

Parameters

Required Parameters
SkipRecords_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 -SkipRecords command tag. The following example specifies a -Search action in [Inline] ... [/Inline] tags. The second record in the found set is returned since -SkipRecords=1 is specified. Only one record is returned since -MaxRecords=1 is specified.

[Inline: -Search,
    -Database='Contacts',
    -Table='People',
    -MaxRecords=1,
    -SkipRecords=1,
    'First_Name'='John']
  [Records]
    <br>[Field: 'First_Name'] [Field: 'Last_Name']
  [/Records]
[/Inline]

<br>John Surname