Skip to content

Instantly share code, notes, and snippets.

@kukielp
Created November 19, 2020 21:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kukielp/546d8c69c9da28393fc45eff33c0cad8 to your computer and use it in GitHub Desktop.
Save kukielp/546d8c69c9da28393fc45eff33c0cad8 to your computer and use it in GitHub Desktop.
<cfscript>
loopLength = 10
qry = queryNew("id,dstart_time", "integer,Timestamp");
for(i=1; i<loopLength; i++){
tmpDate = dateAdd("d",-i,now());
queryAddRow(qry);
querySetCell(qry, "id", i);
querySetCell(qry, "dstart_time", tmpDate);
}
writeOutput("Query new:")
writeDump(qry);
</cfscript>
<cfset strt = {} />
<cfloop query="qry">
<cfset strt[qry.id] = qry.dstart_time />
</cfloop>
<cfdump var="#strt#" />
<cfset sortedQry = structSort(strt,"numeric","asc") />
<cfdump var="#sortedQry#" />
<cfloop from=1 to="#arrayLen(sortedQry)#" index=i >
<cfset item = sortedQry[i] />
<cfoutput>#strt[item]#</cfoutput>
</cfloop>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment