Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1626718011831-1c90dddc-c5c3-3025-017c-e3ed5ac0ec94.cfm

Created July 19, 2021 18:31
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 trycf/9808ed47e8cd4daf3d47928a39812098 to your computer and use it in GitHub Desktop.
Save trycf/9808ed47e8cd4daf3d47928a39812098 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1626718011831-1c90dddc-c5c3-3025-017c-e3ed5ac0ec94.cfm
<cfscript>
qry = queryNew( 'col', 'Integer' )
writedump( qry )
qoq = queryExecute(
'SELECT sum( col ) FROM qry',
[],
{ dbType = 'query' }
)
writedump( qoq )
qoq2 = queryExecute(
'SELECT sum( col ) FROM qry GROUP BY col',
[],
{ dbType = 'query' }
)
writedump( qoq2 )
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment