tracker issue : CF-3035946

select a category, or use search below
(searches all categories and all time range)
Title:

Bug 72891:(Watson Migration Closure)http://www

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/

Reporter/Name(from Bugbase): Todd Rafferty / Todd Rafferty (Todd Rafferty)

Created: 09/05/2008

Components: Database, CFQuery

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Platforms All

Vote Count: 1

Problem:

http://www.zrinity.com/developers/mx/undocumentation/query.cfm

Can we get the following exposed to us:
.sort()
.findColumn()

I had a very long discussion about this with Jason Delmore, he said he'd look into possibly getting it into CF9, but I don't know where that stands at the moment.

Right now, the only way to resort a query object is to do a query of queries on it.  Having a sort() function that we can use on the query object (instead of writing a QoQ) would be handy.
Method:


Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3035946

External Customer Info:
External Company:  
External Customer Name: Todd Rafferty
External Customer Email: 65E3269B4558959A992016B6
External Test Config: 09/05/2008

Attachments:

Comments:

+1 from me. Maybe you could also consider to add the ability to sort by several columns. Examples: query.sort("lastName") <!--- Sorts ascending by "lastName" ---> query.sort("lastName","DESC") <!--- Sorts descending by "lastName" ---> query.sort([{column="lastName",order="ASC"},{column="firstName",order="DESC"}) <!--- Sorts ascending by "lastName" and if the last names are equal sorts descending by first name --->
Vote by External U.
24765 | November 10, 2011 10:39:28 AM GMT