Showing 1 to 0 of 0 entries... wait, what?

frank.oosterhuis

I'm using dataTables with a serverside-script as resource (php).
Whenever the table is empty (or even filtering to an empty resultset) my table still thinks that there's still one record to display.

Data returned by PHP:
[code]{"sEcho":1,"iTotalRecords":"0","iTotalDisplayRecords":"0","aaData":[]}[/code]

The resultset is cleary empty, and actually very similar to the example:
[code]{"sEcho": 4, "iTotalRecords": 57, "iTotalDisplayRecords": 0, "aaData": [] }[/code]

Does anyone have any clues on how to fix this issue?

frank.oosterhuis

well, this is fun.
starting this topic (with syntax hilights) made me realise the difference between the two JSON objects.

I've fixed this using intval in PHP.

Meh, I hate it when solutions are this simple, and yet take me this much effort.
Sorry for opening this rather useless topic..

allan

Heh - good to hear you got it sorted. Funny thing is that I haven't seen this question in the forum before, and now in about 2 days, there have been four posts about it. Did this come from a tutorial or something? Or just random coincidence?

Regards,
Allan

frank.oosterhuis

for all I know this is just random.
I kinda missed the other posts about this aswell.. (again: sorry)

allan

No problem at all. Lots of funny coincidences going on just now. Maybe "they" are watching me after all ;-)

Regards,
Allan