-UseLimit prematurely ends a -Search or -FindAll action once the specified number of records for the -MaxRecords tag have been found and returns the found records. Requires the -MaxRecords tag. This issues an internal LIMIT statement to MySQL to cause it to search more efficiently.
[Inline: -Search, -MaxRecords='25', -UseLimit, ...]
[Inline: -FindAll, -MaxRecords='25', -UseLimit, ...]
The following example searches the Contacts database with a limit of 10 records.
[Inline: -Findall, -Database='Contacts', -Table='People', -MaxRecords='10', -Uselimit]
[Found_Count]
[/Inline]
10
Tag Link | -UseLimit | Category | Database |
---|---|---|---|
Type | Command | Data Source | MySQL |
Support | Preferred | Version | 6.0 |
Output Type | None | Security | None |
Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0 |
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 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft