Warning: The SQL command was the first introduction of SQL to the macro language. It has many limitations and quirks and is now deprecated. It is provided for here for backwards compatibility only. It is very much recommended that you use the more complete and robust SQLite database engine. See the SQLite() function.
Allows you to sort the resulting recordsets.
Syntax:
ORDER BY component1[,componentN]
each component is of the format: [#]fieldname [ASC|DESC]
where "#" forces the field to be treated as numeric and ASC and DESC request sorting in ascending or descending order, respectively. Any field that you want to ORDER BY, must also be included in the select clause.
Example:
$status = dbtosql("caches","Code,Name,CacheType,Container,Difficulty,Terrain","$_Install\macros\caches.txt","") $status = sql("select * from caches order by terrain","H") $html = sqltohtml($status,"Cache Summary","Y") |
The optional # before a fieldname forces the field to be treated as a numeric. Remember that in an SQL database, numeric data are stored as text in general or exponential format - using # sorts on such fields numerically.
Immediately following a fieldname you can optionally put ASC for an ascending sort, or DESC for a descending sort. When you omit the sort direction, the default ascending sort order is used.