Forum


01:58

Hi,
I have the below static xml file
---------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<invoices>
<request>true</request>
<currentpage></currentpage>
<totalpages>3</totalpages>
<totalrecords>25</totalrecords>
<result>
<invoice>
<asin>12345</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12346</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12347</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12348</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12349</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12350</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12351</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12352</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12353</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12354</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12355</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12356</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12357</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12358</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12359</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12360</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12361</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12362</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12363</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12364</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12365</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12366</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12367</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12368</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
<invoice>
<asin>12369</asin>
<invoiceno>data1</invoiceno>
<invoicedate>data2</invoicedate>
<invoiceamount>data3</invoiceamount>
<invoicetax>data4</invoicetax>
<invoicetotal>data5</invoicetotal>
<notes>data6</notes>
</invoice>
</result>
</invoices>
---------------------------------------books.xml------------------------------------------------------------
jQuery(document).ready(function(){
jQuery("#list2").jqGrid({
url:'books.xml',
datatype: "xml",
colNames:["invid","invdate", "Price", "tax","total","note"],
colModel :[
{name:'invid', index:'invid', width:55, xmlmap:"invoiceno"},
{name:'invdate', index:'invdate', width:90, xmlmap:"invoicedate"},
{name:'amount', index:'amount', width:80, align:'right', xmlmap:"invoiceamount"},
{name:'tax', index:'tax', width:80, align:'right', xmlmap:"invoicetax"},
{name:'total', index:'total', width:80, align:'right', xmlmap:"invoicetotal"},
{name:'note', index:'note', width:150, sortable:false, xmlmap:"notes"}
],
pager: jQuery('#pager2'),
rowNum:10,
rowList:[10,20,30],
imgpath: '<%=ctx%>/javascript/jqGrid/themes/<%=jqgTheme%>/images',
viewrecords: true,
recordtext: "Order(s)",
hidegrid: false,
sortorder: "desc",
multiselect: true,
height: 250,
xmlReader: {
root:"result",
row:"invoice",
total:"invoices>totalpages",
records:"invoices>totalrecords",
repeatitems:false,
id:"asin"
}
}).navGrid('#pager2',{add:false,edit:false,del:false,search:false,refresh:false});
});
-----------------------------------this is my jsp code----------------------------------------
The grid is displayed but it shows all the data in one page.
I have 25 records which i need to show in 3 pages.
Please help me in sovling this.
Most Users Ever Online: 715
Currently Online:
63 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66