Jeff,
This thread does not deal with sort orders on a cf_DisplayFilteredSelect,
does it?
I have a plum Generated tage of:
<cf_DisplayFilteredSelect
parentTable="tblFieldType"
primaryKey="n_fieldTypeID"
primaryKeyType="integer"
foreignKey="n_fieldTypeID"
displayColumn="n_fieldTypeID"
displayColumnType="integer"
label="Field Type"
required="Yes">
Which I have changed to:
<cf_DisplayFilteredSelect
parentTable="tblFieldType"
primaryKey="n_fieldTypeID"
primaryKeyType="integer"
foreignKey="n_fieldTypeID"
displayColumn="c_type"
displayColumnType="varchar(15)"
label="Field Type"
required="Yes">
Changing the displayColumn and displayColumnType so it displays a user
friendly name, however, I would still like that display list sorted on
n_fieldTypeID. I do not see an option to do that in the VTM.
Dan
----- Original Message -----
From: "Jeff Fleitz" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, December 03, 2004 11:20 AM
Subject: RE: [plum] Custom Query Sorting
> 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
> **********************************************************************
**********************************************************************
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
**********************************************************************
