Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
jqgrid 3.4 All xml data is displaying in one page
29/07/2009
01:58
Avatar
Naren
Guest
Guests

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.

29/07/2009
10:26
Avatar
Naren
Guest
Guests

Is the problem because I am using url directly as books.html ? Please help.

The only problem is all the 25 rows are displaying in one page. 

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information