Raymond Camden wrote: > Can we see your code? I had no issues with this on either CF5 or MX. > Here is the code I used: > > > <cf_querysim name="foo"> > price name > 6000 foo > 10000 goo > 20000 moo > </cf_querysim> > <cfdump var="#foo#"> > > <cfquery name="test" dbtype="query"> > select price > from foo > where price > 7000 > </cfquery> > > <cfdump var="#test#">
order by in CF 5.0 doesn't work with QoQ's when the query is built or modified using QuerySetCell, and I found no work arounds, querying the query and then trying to query and order by with that recordset still doesn't work z ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists