SELECT firstname, lastname, department, id
FROM users
ORDER BY #form.sort# #form.dir#
LIMIT #form.limit#, #form.start#
SELECT COUNT(id) as totalcount
FROM users
extobj = createobject("component",extcfc).init();
extobj.setGridQuery(users,usercount.totalcount);
//clear server output buffer
getPageContext().getOut().clearBuffer();
extobj.printJsonData();
extobj = createobject("component",extcfc).init('/js/ext-2.0');
extobj.initGrid(title="Sample Users",path='http://'&cgi.server_name&cgi.script_name&'?action=getData',root='users',id='id',defaultSortColumn=form.sort,defaultSortOrder=form.dir,detailedView=true);
extobj.initGridFooter();
extobj.setGridCol(header='Department',width=200,name='department',renderer="String.format('{0}', value)");
extobj.setGridCol(header='First name',width=200,name='firstname');
extobj.setGridCol(header='Last name',width=150,name='lastname');
//set grouping if you want
//extobj.setGridGrouping('department');
//add details row
extobj.setGridRowBody('address');
The following errors occured:
- #extobj.errormessages[i]#