Showing more than 500 rows

davehaggblad

I've searched the forum for an hour or so and not found an answer to what I suspect is a simple question.

I am using DataTables with browser side processing on a table that I know has 1500 rows. Everything appears to be working but I'm only getting 500 rows in the output. The status message says "Showing 1 to 25 of 500 entries".

I don't get a message saying there are more, though I've tried using "sInfoFiltered": "(filtered from _MAX_ total records)"

How do I display the full number of records in the table rather than just the 500 records?
Link to live page http://westriverconveyors.com/parts-catalog/reducers-gearbox-search
(note: once I can get this working I'll be reducing/removing the 'other' search fields...

Debug code ivedok

Thanks

tangerine

Where are you getting the data from? Your live page clearly has a 500-row table.

davehaggblad

It's a Business Catalyst website, which is really just the CMS. I don't know for sure what the back end is but believe it's aspx.

Your response tweaked something for me. I created a test page and output the table without attaching DataTable. Turns out the CMS is limiting the output to 500 rows.

So thank you for your quick reply tangerine. I will chase this through the CMS support.

tangerine

No problem - hope you get it fixed OK.