component {

    remote array function getSuggestions(required string search) returnFormat=json {
        var q = new com.adobe.coldfusion.query();
        q.setDatasource("cfartgallery");
        q.setSQL("select firstname,lastname from artists where lower(lastname) like :search or lower(firstname) like :search");
        q.addParam(name="search",value="%#lcase(arguments.search)#%",cfsqltype="cf_sql_varchar");
        var res = q.execute().getResult();
        var result = [];
        for(var i=1; i<=res.recordCount; i++) {
            arrayAppend(result, "#res.lastname[i]#, #res.firstname[i]#");
        }
        return result;
    }
}