Problems with server processing, dinamic selectable rows !! going crazy!

kekito

Hi, my problem is that i'm using datatables, from a DB, is working fine ( in postgreSQL ), but i tryed to use the selectable rows, but doesn't work, i think it could be that table not in dom, just using ( .html() ) or something like this.
I need help to use, selectable rows using server processing..

Another problem i had, with tools, copy , .save as .xls, and other, is that the table is not in dom, so, you only take to clipboard, or xls, or csv, is the filtered table.. another problem for me so i'm using server processing from php to connect with database, if somebody can help me, i'll be happy^^, thx about all.

allan

You'll need to give us a bit more to go on if you want us to be able to offer any help! I presume you tried this example: http://datatables.net/examples/server_side/select_rows.html . Which aspect doesn't work? The example seems to be okay.

WRT TableTools - TableTools is entirely client-side - so you only get the data that is on the current page - as you noted. TableTools with server-side processing isn't really something that is supported atm - particularly since server-side processing is often used with 1 million + rows of data - so saving this on the client-side isn't really an option. I suppose if you want to get around this, you could set the paging length to -1, but I wouldn't really recommend it... A server-side process, or proper integration with TableTools would be needed.

Allan

kekito

thxs, i solved the selectable rows, i can't find this example before.. i found yesterday at night, finding by forum.
thxs for help, could i insert a new row with a button to delete row ? for example ? or an input to change the value of server side? i didn't find how i can put a input td with the returned value of server_processing.php. I supouse you have implemented some thing to do this. I read a lot of your doc, but it's too long, maybe i don't find the key to do this,
thx, nice plugin:)

allan

Where the information it output (ie. the JSON string is constructed) you can just add an extra black field there (or with a link or whatever). Then just make sure you add a TH to the table head, and that is you with another column.

Allan

alby762

Hello, I'm new to datatables, I can not read data from a postgres table. I read that you can read data from postgres database. Can you tell me which files of datatables I need change to read data from a postgres table?
Thanks in advance for your help.