LassoScript Utility
Basics Browse Detail

[Found_Count]

Tag Link [Found_Count] Category Results
Type Substitution Source Available No
Support Preferred Version 3.0
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

Description

[Found_Count] returns the total number of records found by a Lasso query.

Note: The maximum number of records that is shown by Lasso on each page is set by the -MaxRecords tag. [Shown_Count] returns the number of records shown per page, whereas [Found_Count] returns the total number of records found by the query.

This tag can be used within the [Inline] ... [/Inline] tags that perform a database action or on 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

[Found_Count]

Parameters

No Parameters Required.

Examples

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

Use the [Found_Count] tag. The following [Inline] ... [/Inline] tags perform a search in the People table of the Contacts database for all records and return how many records were found.

[Inline: -FindAll,
    -Database='Contacts',
    -Table='People',
    -KeyField='ID']
  <br>[Found_Count] records were found.
[/Inline]

<br>6 records were found.