LassoScript Utility
Basics Browse Detail

[Total_Records]

Tag Link [Total_Records] Category Results
Type Substitution Source Available No
Support Preferred Version 2.5
Change Unchanged Data Source FileMaker Pro
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

[Total_Records] returns the total number of records in the current table.

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

[Total_Records]

Parameters

No Parameters Required.

Examples

To return the total number of records found by a database search:

Use the [Total_Records] tag. The following [Inline] ... [/Inline] tags perform a search in the People table of the Contacts database for all records and return the total number of records in the database table.

[Inline: -FindAll,
    -Database='Contacts',
    -Table='People',
    -KeyField='ID',
    -MaxRecords=1]
  <br>The are [Total_Records] records in the table.
[/Inline]

<br>There are 6 records in the table.