Actually, here is another option that is easy and appears to work. I am just
taking the URL.sortOrder value from the pulldown and adjusting the query
accordingly. Do you see a drawback to this?
<cfparam name="URL.sortOrder" default="1" type="integer">
<cfscript>
// Select query parameters
selectClause = "Employee.EmployeeID AS Employee_EmployeeID,
Employee.OfficeID AS Employee_OfficeID, Company.CompanyName AS
Company_CompanyName, Office.OfficeName AS Office_OfficeName,
Employee.LastName AS Employee_LastName, Employee.FirstName AS
Employee_FirstName, Employee.MiddleName AS Employee_MiddleName,
Employee.Title AS Employee_Title, Employee.Email AS Employee_Email";
fromClause = "Company, Office, Employee";
whereClause = "Company.CompanyID = Office.CompanyID AND
Employee.OfficeID = Office.OfficeID AND Office.OfficeID = #URL.OfficeID#";
if(URL.sortOrder EQ 1)
orderByClause = "Employee.LastName ASC, Employee.FirstName ASC";
else
orderByClause = "Employee.Email ASC";
GetPersonnel =
Application.DatabaseBlocks.SelectRecords(selectClause:selectClause,
fromClause:fromClause, whereClause:whereClause, orderByClause:
orderByClause);
</cfscript>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Adam Churvis
> Sent: Thursday, December 02, 2004 11:06 PM
> To: [email protected]
> Subject: Re: [plum] Custom Query Sorting
>
> When you pass a custom query object to the DisplayList Plum
> custom tag, it completely circumvents the query building
> code, so the sort order cannot act upon it.
>
> However, you bring up an excellent point that could be
> approached using a couple of different techniques. Consider this:
>
> 1) When you choose a different sort order from the sort order
> menu on a list, it re-queries the database using the new sort
> order. We *could* approach this problem by enabling
> developers to map each sort order choice in the sort order
> menu to a method call that returns a specific query object
> already sorted in the desired order.
>
> 2) There is also the idea of using query of queries to
> re-sort the query object, but those of you who have taken our
> ColdFusion MX Master Class understand the very negative
> internal ramifications of doing this. Still, it might be worth a try.
>
> Anyway, David and I are discussing it and will have an answer
> before the final release. I don't know if we'll add the
> feature in this release, but we'll have an answer for what and when.
>
> Respectfully,
>
> Adam Phillip Churvis
> Member of Team Macromedia
> http://www.ProductivityEnhancement.com
>
> Download Plum and other cool development tools, and get
> advanced intensive Master-level training:
>
> * C# & ASP.NET for ColdFusion Developers
> * ColdFusion MX Master Class
> * Advanced Development with CFMX and SQL Server 2000
>
> ----- Original Message -----
> From: "Jeff Fleitz" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Thursday, December 02, 2004 5:57 PM
> Subject: [plum] Custom Query Sorting
>
>
> > If you specify a custom query for use in a DisplayList tag,
> is there a way
> > to get the list to honor multiple sort orders? The original
> sort orders
> > specified by Plum don't work now that I am using the custom query.
> >
> > Jeff
> >
> >
> >
> >
> **********************************************************************
> > You can subscribe to and unsubscribe from lists, and you can change
> > your subscriptions between normal and digest modes here:
> >
> >
> http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
> >
> **********************************************************************
> >
>
>
> **********************************************************************
> You can subscribe to and unsubscribe from lists, and you can change
> your subscriptions between normal and digest modes here:
>
> http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
> **********************************************************************
>
>
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
