LassoScript Utility
Basics Browse Detail

[SkipRecords_Value]

Tag Link [SkipRecords_Value] Category Results
Type Substitution Source Available No
Support Preferred Version 2.5
Change Unchanged Data Source Any
Output Type Integer 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_Value] returns the current offset into a found set.

This tag can be used within the [Inline] ... [/Inline] tags that perform a database action or in a format file which is the response to an HTML form or URL that performs a database action. This tag cannot be used within [Records] ... [/Records] tags that reference a named inline.

Syntax

[SkipRecords_Value]

Parameters

No Parameters Required.

Examples

To return the current offset into the found set of a database search:

Use the [SkipRecords_Value] tag. The following [Inline] ... [/Inline] tags perform a search in the People table of the Contacts database for all records and return the offset into the records that were found.

[Inline: -FindAll,
    -Database='Contacts',
    -Table='People',
    -KeyField='ID',
    -MaxRecords=5,
    -SkipRecords=5]
  <br>Showing records starting at record number [SkipRecords_Value].
[/Inline]

<br>Showing records starting at record number 6.