<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>