sort a query from queryNew()

[Guest_imported]

Hi
I wanted to sort a query on time, from the time nearest to a time in a session var (session.time). My query:

<cfset tempvalue = queryAddrow(session.tidliste)><cfset tempvalue = querySetCell(session.tidliste,&quot;bid&quot;,session.ledig_bord.bid)>
<cfset tempvalue = querySetCell(session.tidliste,&quot;dato&quot;,session.dato)>
<cfset tempvalue = querySetCell(session.tidliste,&quot;time&quot;,session.ledig_bord.time)>
<cfset tempvalue = querySetCell(session.tidliste,&quot;ant&quot;,session.ledig_bord.ant)>
<cfset tempvalue = querySetCell(session.tidliste,&quot;bordnr&quot;,session.ledig_bord.bordnr)>
<cfset tempvalue = querySetCell(session.tidliste,&quot;mb&quot;,session.ledig_bord.mb)>

 

[SnakeHollywood]

You can only sort a query that is read from a database. The query is sorted in SQL before being returned to ColdFusion If you are creating a query on the fly as you are here, there is no opportunity to sort it.