aoData.push size limit of vars
aoData.push size limit of vars
Osiris
Posts: 36Questions: 0Answers: 0
Hi,
Is there a variable size limit to what you can push using aoData.push ?
I'm sending my query (which varies) to the server processing page.
I'm choosing 'clients' in one page (in a datatable) ... this generates a query on a second page, which calls a third page : the server-processing.php.
It works perfectly, until I choose a client to many.
Is the query becoming too big to be sent as a $_GET variable ?
I've tried to send it as POST type, same result.
If I hardcode my php generated query into the processing page (as the table), the json shows perfectly.
Is there a variable size limit to what you can push using aoData.push ?
I'm sending my query (which varies) to the server processing page.
I'm choosing 'clients' in one page (in a datatable) ... this generates a query on a second page, which calls a third page : the server-processing.php.
It works perfectly, until I choose a client to many.
Is the query becoming too big to be sent as a $_GET variable ?
I've tried to send it as POST type, same result.
If I hardcode my php generated query into the processing page (as the table), the json shows perfectly.
This discussion has been closed.
Replies
I presume you mean for fnServerParams? In which case no - although obviously the more data to send the longer it takes, the slower the app is. Also many server's have a GET limit, so you might want to use POST.
Allan
aoData.push( { "name": "trueQuery", "value": "'.$query.'","type": "POST" } );
...[/code]
fnServerData indeed.
I've set all relevant vars in my server's php.ini to an astronomical size.
I assume this variable can be cought through
[code]$_POST['trueQuery'][/code]
Allan
I can only catch the var through $_GET
what's the code behind the aoData.push in fnServerData ?
Are you escaping/encoding these vars somewhere ?
I see it was already asked in this topic, but not directly answered.
http://datatables.net/forums/discussion/1630/using-aodata-to-push-extra-things-to-a-php-file/p1
Allan
it isn't the jQuery as far as the request variables are concerned.
Why the POST type isn't working, I'll find out later.
The url with the $_GET vars actually gets cut off.
Just found it in the access.log on the apache (so not in the error log since it's normal behaviour).
[code]LimitRequestLine 65536[/code]
The default seems to be 4KB
Problem solved.
thx for all the feedback, Allan.