Should be simple enough to make your ORDER BY clause a variable. When
you initially run your query, make sure that variable is cfparam'ed or
otherwise defined. When someone clicks on a "sort" link, you call the
same template. If you don't want to expose the database structue in a
link (ie: mypage.cfm?sort=price%20ASC) try encrypt/decrypt.
--
Billy Cravens
[EMAIL PROTECTED]
Lisa Hamlin wrote:
>
> We have a customer who wants to take the results of a query and sort =
> them by a specific column. The intial query did a UNION on several =
> tables (one table for each month). The resulting output looked something =
> like this:
>
> COMPANY1
> PRODUCT A - totals
> PRODUCT B - totals
> COMPANY2
> PRODUCT C - totals
> PRODUCT D - totals
> COMPANY3
> PRODUCT 3 - totals
> COMPANY1
> PRODUCT B - totals
>
> The customer wants to re-sort so that all of COMPANY1's information is =
> consecutive (for grand totals). How can this be done?
>
> Thanks in advance,
> Lisa
>
------------------------------------------------------------------------------
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.
