Re-sort Queries

thanks all

The tersest answer is: YES.


Any or all your thoughts apply depending on what you want to do and how
you want to build the user interface.

It sounds like you had some controls that made a new request to the
server and then tried to sort the data with a QofQ. This will work, but
you have to have saved the data from the original request so that you
have something to query. If you have not done something to save the
original query in a persistent scope such as session, application or
server, then it was thrown away when the first request was completed and
sent to the client.

Some of your options are re-query the database, save the original query
in a persistent scope to be used again, use DHTML or Flash client side
code that sorts the results without new requests, use Ajax that does use
a new request, but does not need to refresh the browser, ect.

As you can see there are many ways to skin this particular requirement
and which one you use depends on your ultimate goals, how comfortable
you are with any and all the technologies and techniques involved, and
any complicating factors such as paging which can significantly confuse
the issue of sorting.

Sure, thanks Eric. One thing though, that would require going back to the database to capture the recordset, can I resort this by not going to the database (ie: QoQ)?

Best thing to do is make your header row a series of links:

name department date
Eric IT 9/11/2007
Joe Sales 5/25/2006

So if I want to sort by name, click on "name". If i want to sort on department...click on "department"...you get the picture...

the link would look like index,cfm?sortby=name or sortby=1

in your query:

select name, department, date
from employee
order by
<cfif order_by eq "name">
name
<cfelseif order_by eq "department">
department
<cfelse>
name>
</cfif>

Eric