Lasso Soft Inc. > Home

-UseLimit

-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.

  • Syntax
  • Parameters
[Inline: -Search, -MaxRecords='25', -UseLimit, ...]

[Inline: -FindAll, -MaxRecords='25', -UseLimit, ...]
Examples

To have MySQL immediately return records once a limit is reached:

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]
Result:
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. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft