cold fusion get first element of query row
<cfscript>
var result = query.execute().getResult();
if (result.recordCount > 0) {
var ret = QueryGetRow(result, 1); //get first item of query result rows
//do stuff
return ret;
}
</cfscript>