Datatables displaying too many rows

ViktorAlm

Hello

I'm having problems with scrolling. I want to display all my data without pagination.

I used to have this error before
[code]aoData is undefined[/code]

and it tries to display rows after the total amount of rows.
[code]Displaying 44 to 64 of total 49 rows[/code]

wich generates a mysql error in my loaddb.php file wich i copied from the examples.

What am I doing wrong? i've been looking around for days and I havent found any answers or maybe i just dont understand.

[code]
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "loaddb2.php",
"bScrollInfinite": true,
"bScrollCollapse": true,
"sScrollY": "450px",
[/code]
and i also get this warning
[code]DataTables warning (table id = 'example'): ColReorder attempted to initialise twice. Ignoring second[/code]

allan

Can you give us a link to your demo page please? Also worth making sure that you are using the latest versions of all the plug-ins and DataTables itself: http://datatables.net/download .

Thanks,
Allan

ViktorAlm

Hey thanks for your reply! I've been away but here is a link:
EDIT. Removed link

I think I installed it somewhere in december, I'l look it up now

allan

Ah you are using scroller. In that case the rows MUST all be of the same height (which currently they are not and that is causing the problem).

The Scroller documentation notes:

> Note that rows in the table must all be the same hight. Information in a cell which expands on to multiple lines will cause some odd behaviour in the scrolling.

This blog post has more details: http://datatables.net/blog/Introducing_Scroller_-_Virtual_Scrolling_for_DataTables (see the "How it works" section for why they must be the same height).

Allan

ViktorAlm

Hey, thanks.

I thought the number of rows caused the error? but now it's displaying the correct amount of rows and I still get the error from the loaddb.

[quote]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-8, 57' at line 6[/quote]

this is the loaddb link:
http://dokumenthanteringsplan.se/demo/loaddb2.php?sEcho=2&iColumns=7&sColumns=&iDisplayStart=-8&iDisplayLength=57&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&mDataProp_5=5&mDataProp_6=6&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&sSearch_5=&bRegex_5=false&bSearchable_5=true&sSearch_6=&bRegex_6=false&bSearchable_6=true&iSortingCols=1&iSortCol_0=0&sSortDir_0=asc&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&bSortable_5=true&bSortable_6=true&_=1328703895394

http://dokumenthanteringsplan.se/demo/dynsearch.php