-SortColumn specifies the name of a field which should be used to sort the results that are returned from a database action. Synonym is -SortField.
Can be used in concert with a -SortOrder tag to sort the field in Ascending, Descending, or Custom (data source dependent) order. Multiple -SortColumn tags can be used for compound sorts.
[Inline: -SortColumn='Field_Name', -SortOrder='Ascending'...]
<a href="default.lasso?-SortColumn=Field_Name&-SortOrder=Descending&...">Link</a>
<form action="default.lasso" method="POST">
<input type="hidden" name="-SortColumn" value="Field_Name">
<input type="hidden" name="-SortOrder" value="Custom">
...
</form>
Use the -SortColumn and -SortOrder command tags. The following example specifies a -Search action in [Inline] ... [/Inline] tags. The results are sorted in descending order by Last_Name.
[Inline: -Search,
-Database='Contacts',
-Table='People',
-SortColumn='Last_Name',
-SortOrder='descending',
'First_Name'='John']
[Records]
<br>[Field: 'First_Name'] [Field: 'Last_Name']
[/Records]
[/Inline]
<br>John Surname
<br>John Doe
Tag Link | -SortColumn | Category | Database |
---|---|---|---|
Type | Command | Data Source | Any |
Support | Synonym | Version | 3.0 |
Output Type | None | Security | None |
Implementation | LCAPI | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0,LDML3x |
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