Skip to content

Instantly share code, notes, and snippets.

@bardware
Created June 8, 2017 08:54
Show Gist options
  • Select an option

  • Save bardware/536f3a0ffdf77c88355af7a002ab025c to your computer and use it in GitHub Desktop.

Select an option

Save bardware/536f3a0ffdf77c88355af7a002ab025c to your computer and use it in GitHub Desktop.
<cfscript>
qryPers = QueryNew(
'pn_id,vor name,nach name',
'integer,varchar,varchar',
[
{ pn_id = 2, 'vor name' = 'L', "nach name" = "y" },
{ pn_id = 1, 'vor name' = 'A', "nach name" = "b" }
]
);
qryPersSort = QueryExecute(
"SELECT * FROM qryPers ORDEr BY [vor name]",
{},
{
dbtype = "query"
}
);
</cfscript>
<cfdump var="#qryPers#">
<cfdump var="#qryPersSort#">
<cfquery name="qryPersSort2" dbtype="query">
SELECT * FROM qryPers ORDEr BY [vor name] DESC
</cfquery>
<cfdump var="#qryPersSort2#">
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment