400 Bad Request

btz

Hi,
I have very large DT, 395 columns (days in year+month).

Not I get "400 Bad request" because my json request url length is over 7000 chars.

Example json request:
get.php?c=1&sEcho=1&iColumns=395&sColumns=&iDisplayStart=0&iDisplayLength=-1&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2....&mDataProp_394=394&_=1323257078340

I do not have any sorting or filtering etc.

How do I shorten json request?

allan

395 columns - nice!

What to do, I would say, is not try and shorten the request (although you could remove some of the properties you don't need by modifying the core if you wanted), but rather, just POST the request rather than using the default GET: http://datatables.net/release-datatables/examples/server_side/post.html (this method needs v1.8.2 btw).

Regards,
Allan

GregP

Yup yup yup! But I could've sworn we've been able to use POST before 1.8.2. Am I going mad?

allan

You could to - but you had to define fnServerData. 1.8.2 introduced a new parameter, sServerMethod that makes it much easier to use POST rather than GET (since that was the reason for overriding fnServerData in most cases).

Allan

btz

Thanks again allan!

btz

Hmm.. I use FixedHeader 2.0.5.dev with this DT.
With this POST it does not work, columns does not line-up..

allan

I doubt that it is the POST that is causing that. Can you give us a link please?

Allan

btz

Here is link: http://www.tulospalvelu.biz/dt/pp.php

allan

Okay, the table is smaller in width than it is possible to make the header. You got different styling applied to the header than you have to the main table's header (i.e. without the Fixed header). The two must has the same styling, or the main table must be slightly bigger since you can't make the header smaller than it can possibly be!

Allan

btz

Oh,
can you point me to the right direction how to make those stylings same? :)

allan

I'd use Firebug/Inspector to have a look at what styles are applied to the fixed header and what styles are applied to the static one. Specifically it looks like

".ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default"

is applied to the static header only.

Allan

btz

I don't quite follow you now.. :)

Does "bJQueryUI":true have something to do with this?

allan

Have a poke at the two headers with Firebug or Inspector and you should see what I mean.

Allan

btz

Okay, I had my own class for this dt, I changed it back to "display" so now it works but is wider :)

One more question. How to use FixedHeader with Tabs? I have three DTs, own Tab for each.

markjo

This issue is solved here: http://datatables.net/blog/localStorage_for_state_saving
I post for the people who would miss this option.