Server-side : No matching records founds.

Fiaxhs

Hello Allan :)

I've got a problem with the 1.5 beta 6, while using server side processing.

Even if I get a result, the data isn't loaded in the table, and showing a "no matches found"... Maybe I've done something wrong ?

See attached video

http://fiaxhs.com/up/video.php?video=2009-03-31_1118.swf&width=906&height=625

Fiaxhs

OK, my fault -_-

The HTML table got less columns than the numbers of columns in the result :] It's working really fine now.

BTW, it's a really cool feature :)

(Don't forget to see with me if you need some help for french translation)

Guillaume LO RE.

djoh

Got the same issue, no really easy to troubleshoot though.

You might like to display an appropriate error message if it is doable...

Thx

allan

Hi guys,

@Guillaume - good to hear you got it working. And yup any French translation, I'll give you a shout :-)

@djoh - there are two common ways in which server-side processing will fail:
1. The json return is not valid
2. The json formatting is incorrect (be it the number of columns or the wrong parameters).

JSONLint is ideal for debugging json issues: http://www.jsonlint.com/ (it's annoying that jQuery doesn't throw an error when it's eval fails...

With regard to displaying an error message - yes this is something I'd like to look at, and have done briefly already, but it's quick difficult given the number of different data sources DataTables can take its data from :-). I'll have a look for the next beta...

Allan

djoh

Wow, you're really involved in your project... That's great !

Fiaxhs

Hello djoh ;)

Now that I've played a lot with this server side, here's the main reason I've encountered leading to the "No matching records found"

1. As allan said, the Json is not valid ( unescaped quote or a break line in it)
2. The number of columns in the HTML structure is different from the number of columns in the JSON result
3. If you're using "aoColumns" in the dataTables initialisation, check you're describing the right number of columns

@Allan thanks for JSONLint, this will be helpful !