September 27, 2009 - 1:17 PM (GMT)
Category: Coldfusion,tech notes
Here's another item that I am note sure I knew before, but now I do. When you are running a query of queries and trying to do a sort on it, the one thing you have to remember is that the field names are case sensitive.
So what you need to do is cfdump the query you are using in the query of queries and copy the field names that show up exactly as shown. Then it should run just fine.