Hi,
I am using dhtmlxconnector and trying to implement server side paging and i am facing some issues.
When i load grid it fetches all the record in first request only.
Xml genatrated by dhtmlxconnector dosent return rows total_count,pos property.
below is the sample code JS code.
function initGrid(){
mygrid = new dhtmlXGridObject('record_grid');
mygrid.setImagePath("dhtml_comp/imgs/");
mygrid.setHeader("Num,Date,Name,Notes,Type,Code,Post, ");
mygrid.setInitWidthsP("7,18,12,15,10,18,15,5");
mygrid.setColAlign("left,left,left,left,left,left,left,left");
mygrid.setSkin("light");
mygrid.init();
mygrid.enableSmartRendering(true);
mygrid.enablePaging(true, 5, null, "pagingArea", true, "infoArea");
mygrid.setPagingSkin("bricks");
mygrid.xmlFileUrl ="LoadGridServlet?partId="+partId+"&gridType=ResearchAndService";
gridQString = "LoadGridServlet?partId="+partId+"&gridType=ResearchAndService&ount=5& posStart=0";
mygrid.loadXML(gridQString);
}Below is Java connector code
GridConnector connector = new GridConnector(conn, DBType.Oracle);
connector.dynamic_loading(true);
String query = "Select * from temp";//sample select query
String columnString = "a,c,v,d";//Sample grid column list
connector.render_sql(query, "table_a_id", columnString);