2 Replies Latest reply on Jan 11, 2007 6:26 AM by Johnny852

    Query of Queries-  sorting issue

    Johnny852
      I've discovered that when I get a query from the database and then try to sort it by QofQ the results are very strange.
      When using ' SELECT * FROM' the results differ from those when using 'SELECT Column1, Column2 FROM'

      I wonder if I did not include some parameters or it is a bug of Coldfusion.

      P.S. Attached code should illustrate what I mean.
      P.P.S. Can you implement 'upper(ColumnName)' in order by in QofQ?