how do you sort a collection search

[oak3]

I was wondering if there was a way to sort a collection search by the custom1
field which is an ID number? Do I have to do that programmatically or is there
a handy attribute that could be used? It would be much easier to sort it when
the search is done and then loop through the results with a cfoutput, rather
than sort the results into a new list and then loop through that, but I guess
it's not too big a deal. Just wondered if there was a shortcut. Thanks, Oak

[Tom Jordahl]

Try using Query of Queries and the 'order by clause:

<cfquery dbtype="query" name="sortedQuery">
select *
FROM OriginalQuery
ORDER BY custom_1
</cfquery>


--
Tom Jordahl
Macromedia Server Development

[oak3]

Cool. Is there a way to take 2 collections and merge the results this way or would you do the initial query with an 'AND' operator between the select statements?

[Tom Jordahl]

Since you are not doing a Query, you can search multiple collections at the
same time if you want by putting a list of collections in the cfsearch tag.

--
Tom Jordahl
Macromedia Server Development