Problem in pagination for fetchnig records having more than 9 fields

Problem in pagination for fetchnig records having more than 9 fields

jewel03csejewel03cse Posts: 11Questions: 0Answers: 0
edited August 2010 in General
I have a mysql database table having more than 1200 records and 18 fields(columns) including primary key.
I have used datatable plugin to view, search and sort.

Problem: When I fetch records from database table, pagination works fine for fetching records consisting
of 9 fields or less. But when I want to fetch records having 10 fields or more, pagination does not work
properly after fetching 100 records.
After that, next page does not come though I click on the icon of pagination. The
Processing... div appears on the screen and doesn't disappear until I refresh the whole page.

Question: 1.Why is this kind of problem appearing?
2.Is there any restriction on the number of fields of record for fetching through dataTable plugin?
3.How can I solve this problem?

Please, respond to me as early as possible.

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin
    Given the symptoms, I'd say it's almost certainly a JSON validation issue. Try running your returned JSON through http://jsonlint.com .

    Allan
  • jewel03csejewel03cse Posts: 11Questions: 0Answers: 0
    You are right, Allan. It was JSON validation issue. Now, I have got the problem and solved it. Thank you, Allan for your response and also for your great plugin.
This discussion has been closed.