Returning queries as array of structs

modius · August 28, 2018, 3:06am

This probably needs a more elaborate write up… but i couldn’t help mentioning it straight away:

Turns out in Lucee you can return the query as an array of structs:

lucee/Example-Code/blob/master/Query-returntype/example02-array.cfm


<cfscript>

query name="arr" datasource="test" returntype="array" {
	echo("
		select lastname,firstname from person
	");
}
dump(arr);
</cfscript>

Why is this helpful? Well you can execute <skin:webview ... /> tags by passing in a struct for the properties. This is way more performant than passing the typename and objectid as there is no lookup on the database.

Sound interesting?