I have a query from wich I want to order the results after the results have
been displayed. For Instance I want the user to order the search results by
the column name on which he clicks.

How would one do this dynamically, and keep the order even when browsing
with recordsets? www.download.com does this very good. 

This is my query:

SELECT * 
FROM sl_software, sl_software_type
WHERE sl_software.type = sl_software_type.typeid
AND (ProgramName LIKE '%#searchcriteria#%' OR FileName LIKE
'%#searchcriteria#%')

Thanks

Carlo van Wyk
ColdFusion Developer
SOLVE Consulting
[w] www.solve.co.za 
[c] +27 83 454 3533
[t] +27 21 447 1108
[f] +27 21 447 1128

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to