Are you asking whether the data can be sorted without a return trip to the server? If
so, I believe that's a CSS or JavaScript question. Any client-side gurus out there?
Otherwise, you can pass a variable into the query that got the results in the first
place like "orderby" and pass through a column name into your query using the order by
SQL function.
Confusing?
Here's an example:
SELECT whatever
FROM whatever_table
WHERE whatever
ORDER BY #orderby#
Does that help?
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Johnson, Dana [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 01, 2000 11:08 AM
> To: '[EMAIL PROTECTED]'
> Subject: sorting a table
>
>
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
