Re: CFQUERY Results in Natural SQL Order?

2007-09-20 Thread James Holmes
I'm sorry I don't have a solution, but I'm really curious; why is the column order important? On 9/20/07, Todd Mathews <[EMAIL PROTECTED]> wrote: > Does anyone know of a simple way to have the results of a CFQUERY return the > results in the natural sql result order instead of always returning > e

RE: CFQUERY Results in Natural SQL Order?

2007-09-20 Thread Rob O'Brien
I've run into very few instances where the alpha sorting of query columns has been a bother. However, I just ran into one yesterday. I wanted to use CFTABLE as a quick and easy way to display an unknown recordset. Using COLUMNLIST from the CFQUERY result wouldn't work - I wanted the 'natural' orde