Jquery DataTables.net:没有把负的int放在表中 [英] Jquery DataTables.net: Failing to put negative int in table
本文介绍了Jquery DataTables.net:没有把负的int放在表中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
$(document).ready(function(){
$('#myTable ').DataTable({
ajax:{
url:'@ Url.Content(〜/ api / cas / nodes / all / lastcondition /)',
columns [
{type:num,data:Id},
{data:Name},
{data:Alias} ,
{data:DateQuery},
{type:num,data:Condition},
{type:num data:TimeSecLastCondition}
]
}
});
});
从ajax查询返回的JSON:
{
data:[{
Id:-2144725655,
Name:NodeName,
Alias :NodeAlias,
DateQuery:2015-11-13T08:16:04,
条件:0,
TimeSecLastCondition:1558
}]
}
错误:
为第0行列0请求未知参数0。
解决方案
您正在混合ajax选项和其他选项。而不是
ajax:{
url:'@ Url.Content(〜/ api / cas / nodes /所有/ lastcondition /)',
列:[
{type:num,data:Id},
{data },
{data:Alias},
{data:DateQuery},
{type:num,data },
{type:num,data:TimeSecLastCondition}
]
})
你应该做
ajax:{
url: '@ Url.Content(〜/ api / cas / nodes / all / lastcondition /)'
},
列:[
{type:num,data :Id},
{data:Name},
{data:Alias},
{data:DateQuery},
{type:num,data:Condition},
{type:num,data:TimeSecLastCondition}
]
}
I have an API that returns some negative numbers for the Id field. Here is my datatables script:
$(document).ready(function () {
$('#myTable').DataTable( {
ajax: {
url: '@Url.Content("~/api/cas/nodes/all/lastcondition/")',
"columns": [
{ "type" : "num", "data": "Id"},
{ "data": "Name" },
{ "data": "Alias" },
{ "data": "DateQuery" },
{ "type" : "num", "data": "Condition" },
{ "type" : "num", "data": "TimeSecLastCondition" }
]
}
} );
});
JSON returned from ajax query:
{
"data": [{
"Id": -2144725655,
"Name": "NodeName",
"Alias": "NodeAlias",
"DateQuery": "2015-11-13T08:16:04",
"Condition": 0,
"TimeSecLastCondition": 1558
}]
}
Error:
"Requested unknown parameter '0' for row 0, column 0."
解决方案
You are mixing the ajax option and other options. Instead of
ajax: {
url: '@Url.Content("~/api/cas/nodes/all/lastcondition/")',
"columns": [
{ "type" : "num", "data": "Id"},
{ "data": "Name" },
{ "data": "Alias" },
{ "data": "DateQuery" },
{ "type" : "num", "data": "Condition" },
{ "type" : "num", "data": "TimeSecLastCondition" }
]
})
you should do
ajax: {
url: '@Url.Content("~/api/cas/nodes/all/lastcondition/")'
},
columns: [
{ "type" : "num", "data": "Id"},
{ "data": "Name" },
{ "data": "Alias" },
{ "data": "DateQuery" },
{ "type" : "num", "data": "Condition" },
{ "type" : "num", "data": "TimeSecLastCondition" }
]
}
这篇关于Jquery DataTables.net:没有把负的int放在表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文