Error during sAjaxSource call

dangesant

Hi, I'm a young italian developer at first time on this forum.
WellI 'm making a local website and when I run this script
[code]
$(document).ready(function() {
var oTable = $('#example').dataTable( {
"bProcessing": true,
"sAjaxSource": "http://46.37.13.177:7710/WebClinicalDataAPI/GetDocumentsToValidate",
"aoColumns": [
{ "mData": "owner" },
{ "mData": "size" },
{ "mData": "status" },
{ "mData": "title" },
{ "mData": "grade" }
]
} );
} );
[/code]
I obtain this error :
[quote] "XMLHttpRequest cannot load http://46.37.13.177:7710/WebClinicalDataAPI/GetDocumentsToValidate?_=1372782614035. Origin null is not allowed by Access-Control-Allow-Origin." [/quote]

Thank to everyone help me!!

aaronw

So, short story is that you cannot make an AJAX call to a different domain. Look at http://stackoverflow.com/questions/3506208/jquery-ajax-cross-domain for some ways to get around this restriction.

dangesant

@aaronw .... first of all , thank you to answer at my question.
Second, if I do this (a simple ajax call in the same script):
[code]
$.ajax({
type:"GET",
url:"http://46.37.13.177:7710/WebClinicalDataAPI/GetDocumentsToValidate",
dataType:"jsonp",
timeout:"20000",
crossDomain : true,
data: {format :"jsonp"},
success:function(json) {
console.log ("json");
}}});[/code]
it's work fine!! Why?

dangesant

ok.. I have found the problem. In second case , is set [code]crossDomain : true[/code],
question : How I can set the same in DataTable??

allan

Currently you'd need to use a method like this: http://datatables.net/release-datatables/examples/server_side/jsonp.html .

DataTables 1.10 will include an `ajax` option which makes this somewhat easier.

Allan

dangesant

Hi Alla, first of all thank you to answer me.
I've done what you said me ..
[code]
$('#tab').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "http://46.37.13.177:7710/WebClinicalDataAPI/GetDocumentsToValidate?format=jsonp",
"fnServerData": function( sUrl, aoData, fnCallback, oSettings ) {
oSettings.jqXHR = $.ajax( {
"url": sUrl,
"data": aoData,
"success": fnCallback,
"dataType": "jsonp",
"cache": false
} );
}
} );
[/code]

but now the error is :
[quote]Uncaught TypeError: Cannot read property 'length' of undefined at jquery.dataTables.js:2038[/quote]

what's wrong?

dangesant

the line is this :
[quote]for ( var i=0, iLen=aData.length ; i

allan

DataTables expects a property called aaData which contains the data. Your JSON object doesn't have that. It has the data in GetDocumentsToValidate.docs.doc. You might want to use sAjaxDataProp to change aaData to what you need.

Allan

dangesant

ok but I dont understand the meaning of :
[quote]
"url": sUrl,
"data": aoData,
"success": fnCallback,
"dataType": "jsonp",
"cache": false
[/quote]

I must to put the value of the field or the name???

allan

What value of what field?

The parameters for the object you highlighted are for the jQuery Ajax call and don't really have that much to do with DataTables. See: http://api.jquery.com/jQuery.ajax/

Allan