How to sort output of <cfexchangemail...

[paquettee]

I have searched everywhere to find this simple answer to a simple question. No seems to have asked this question so far.

Here is my code:
<cfexchangeConnection
action="open"
username="**********"
password="**********"
server="**********"
connection="testconn1">

<cfexchangemail action="get" name="getMail" folder="" connection="testconn1">
<cfexchangefilter name="TimeSent" from="#lastweek#" to="#rightNow#">
</cfexchangemail>

.....Output Code ....

<cfexchangeConnection
action="close"
connection="testconn1">

The output comes out not sorted in any particular way. Is there a way for me to change the order of the output?

Thanks in advance.

Regards,

Eric

[paquettee · Accepted solution]

Answer... :)

<cfset columnId = query.findColumn("TimeReceived")>
<cfset query.sort(columnId, false)>