SELECT firstname, lastname
FROM users
ORDER BY #form.sort# #form.dir#
LIMIT #form.limit#, #form.start#
SELECT COUNT(lastname) 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();
extobj.initGrid(title="Messages",path='http://'&cgi.server_name&cgi.script_name&'?action=getData',root='users',id='id',defaultSortColumn=form.sort,defaultSortOrder=form.dir);
extobj.initGridFooter();
//extobj.setGridCol(header='Subject',width=200,name='subject',render="String.format('{0}', value)",detailRender="String.format('{0}
{1}', value, record.data['body'])");
extobj.setGridCol(header='First name',width=200,name='firstname');
extobj.setGridCol(header='Last name',width=150,name='lastname');
The following errors occured:
- #extobj.errormessages[i]#