Yes, I just pass the parameters back in to the same page and use SQL 'ORDER BY'
<cfquery ...
<cfif URL.SortBy is "LastName">Order by LastName</cfif>
</cfquery>
...
<a href="#CGI.SCRIPT_NAME#"?SortBy=LastName>Last Name</a>
...
At 02:08 PM 9/1/00 -0400, Johnson, Dana wrote:
>Hello All:
>
>I was wondering if anybody has a routine or tag that sorts a dynamic table
>by clicking the table headers to sort in asc or des order by column
>
>here is what I have
>
><CFTABLE QUERY="getlist" COLHEADERS >
><CFCOL TEXT="#Lname#" HEADER="Last Name" WIDTH="15" ALIGN="LEFT">
><CFCOL TEXT="#fname#" HEADER="First name" WIDTH="15" ALIGN="LEFT">
><CFCOL TEXT="#deptname#" HEADER="Department" WIDTH="30" ALIGN="LEFT">
><CFCOL TEXT="#phnext#" HEADER="Ext" WIDTH="5" ALIGN="LEFT">
><CFCOL TEXT="#fax#" HEADER="Fax Number" WIDTH="15" ALIGN="RIGHT">
>
></CFTABLE>
>
>
>p.s not critical just testing
>
>Dana E. Johnson
>Sr. Web Developer
>CIT
>VTF/Technology Financing Services
>[EMAIL PROTECTED]
>(904) 620-7458
>
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
