Pagination not enabled
Pagination not enabled
Hi,
First of all, I'd like to thank the author of this magnific tool !
Nevertheless, I have a small prob with pagination icons not enabling.
I have set up as in demo for server-side the tool like this :
[code]
$(document).ready(function() {
$('#example').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "dsp_search.cfm",
"bPaginate": true
} );
} );
[/code]
the returned JSON gives me this
[code]
{"sEcho":10,"aaData":[[1000,"ACQUISITION DE COMPETENCES","AN","ACT"],[1000,"Action de commercialisation de produits du terroir","AN","ACT"],[1000,"APPUI TECHNIQUE","AN","ACT"],[1000,"Appui Technique","AN","ACT"],[1000,"APPUI TECHNIQUE","AN","ACT"],[1000,"Appui technique GAL","AN","ACT"],[1000,"Arch
First of all, I'd like to thank the author of this magnific tool !
Nevertheless, I have a small prob with pagination icons not enabling.
I have set up as in demo for server-side the tool like this :
[code]
$(document).ready(function() {
$('#example').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "dsp_search.cfm",
"bPaginate": true
} );
} );
[/code]
the returned JSON gives me this
[code]
{"sEcho":10,"aaData":[[1000,"ACQUISITION DE COMPETENCES","AN","ACT"],[1000,"Action de commercialisation de produits du terroir","AN","ACT"],[1000,"APPUI TECHNIQUE","AN","ACT"],[1000,"Appui Technique","AN","ACT"],[1000,"APPUI TECHNIQUE","AN","ACT"],[1000,"Appui technique GAL","AN","ACT"],[1000,"Arch
This discussion has been closed.
Replies
[code]
SELECT
#columnList#
FROM
DOCUMENTS
WHERE
#searchField# LIKE
LIMIT
,
SELECT
count(docid) rownbr
FROM
DOCUMENTS
<!--- Generate JSON from Query --->
<!--- Since SerializeJSON capitalize the content which is case-sensitive let's reset it the correct way --->
#tmpSOut#
[/code]
Allan
I've added this as an FAQ now: "Pagination is not enabled, or the information text shows the wrong data set count" - http://datatables.net/faqs
Allan
I've edited the code above so everyone can use it as is (of course with dsn & table changes).
Now let's start trying the pipelining in CF. If I succeed, i'll post it here too.