Lasso Soft Inc. > Home

-SkipRecords

-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
  • Parameters
[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>
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]
Result:
<br>John Surname
Tag Link -SkipRecords Category Database
Type Command Data Source Any
Support Preferred Version 2.5
Output Type None Security None
Implementation LCAPI Sets Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x,LDML25

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 | PrivacyLegal terms and Shipping | Contact LassoSoft