problem with server-side option

antonio77

Hi,

I'm trying to load data coming from the server.
I've just unzip the file dataTable.zip and change the sAjaxSource parameter to load data
in "sAjaxSource": "./HTTPRequest.py".

http://condb.web.cern.ch/condb/.dataTables-1.6/examples/server_side/HTTPRequest.py
http://condb.web.cern.ch/condb/.dataTables-1.6/examples/server_side/server_side.html

why it doesn't work?

thanks in advance,

Antonio

allan

Hi Antonio,

If I load this up in my browser: http://condb.web.cern.ch/condb/.dataTables-1.6/examples/server_side/HTTPRequest.py - how do it know the parameters such as the page number, the display length, filtering etc?! Everything here in fact: http://datatables.net/usage/server-side

DataTables passes all of these as GET variables (unless you tell it to do POST), and the server-side processing must query a database and return the result set.

You might be getting slightly confused with Ajax data source and server-side processing:

http://datatables.net/examples/data_sources/ajax.html - client-side does all the hard work
http://datatables.net/examples/data_sources/server_side.html - server-side does all the hard work

Allan

antonio77

Hi Allan,

Sorry if I confused with Ajax data source and server-side processing...
Now I've fixed the problem just putting "sEcho": 1 instead of 0.

Anyway, I don't want to send this kind of parameters (sEcho,page number, the display length, filtering ) to the server side.
I want just retrive the rows in JSON format from server side;
and I want the other parameters configured in the client side.

Is it possible? Maybe, I'm seeing a wrong example.
thanks,

Antonio

antonio77

Hi Allen,

ok it is very simple,
It needs only to delete the followings parameters:
// "bProcessing": true,
//"bServerSide": true,
thanks,

Antonio