gistfile1.cfm

public function get(string objectid = '') {
        var queryUser = new query();
        var hasParams = len(arguments.objectid) && isNumeric(arguments.objectid);
        var sql = 'select objectID, username, password, bAdmin, ratingLimit from user';
        if(hasParams){
         sql = sql & ' where objectid = :objectid';
        }
        queryUser.setSQL(sql);
        if(hasParams){
          queryUser.addParam(name="objectid",value="1",cfsqltype="INT");
        }
        return application.utils.queryToArray( queryUser.execute().getResult() );
  }