DataTables.net以“aData is undefined”返回 [英] DataTables.net comes back with "aData is undefined"

查看:97
本文介绍了DataTables.net以“aData is undefined”返回的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我是DataTables.net的新手,只是无法弄清楚我错过了什么,这让我发疯了。它在错误控制台中返回aData is undefined。

我正在使用DataTables 1.9.4和jQuery包中提供的内容(我认为这并不重要)。 br />


HTML:



 <      id   =  dt-enrollments >  
< thead >
< tr >
< th > 名称< / th >
< th > 校园< / th >
< th > Advisor < / th >
< th > 已完成的步骤< / th >
< th > 付费< / th >
< th > 已开始< / th >
< th > 已完成< / th >
< th > 选项< / th >
< / tr >
< / thead >
< tbody >
< / tbody >
< / table >





JS:



 $( document )。ready(
function ()
{
$( ' #dt-enrollments')。dataTable(
{
' sPaginationType'' full_numbers'
' bProcessing' true
' sAjaxSource'' / admin / api / enrollments'
' oLanguage'
{
' sProcessing'' 正在加载注册,请稍候......'
}
});
});





每个FireBug的响应来自/ admin / api / enrollments:



 [{Name:name1,Campus:campus1,Advisor:advisor1,StepsCompleted:1,付费 :真正的 入门: 2013-06-15T04:07:08.7848004-04:00, 已完成: 2013-06-15T04:07:08.7848004-04:00, 选项: } { 名称: NAME2, 校园: campus2, 顾问: advisor2, StepsCompleted:2, 付费:真正的 入门:2013-06-15T04:07 :08.7848004-04:00\" , 已完成: 2013-06-15T04:07:08.7848004-04:00, 选项: },{ 名称: NAME3, 校园: campus3\" , 顾问: advisor3, StepsCompleted:3, 付费:真正的 入门: 2013-06-15T04:07:08.7848004-04:00, 已完成:2013- 06-15T04:07:08.7848004-04:00\" , 选项: },{ 名称: NAME4, 校园: campus4, 顾问: advisor4, StepsCompleted: 4, 付费:真正的 入门: 2013-06-15T04:07:08.7848004-04:00, 已完成: 2013-06-15T04:07:08.7848004-04:00,选项:}} 





我在这里缺少什么?





提前谢谢!

解决方案

document )。ready(
function ()
{


' #dt-enrollments')。dataTable(
{
' sPaginationType'' full_numbers'
' b处理' true
< span class =code-string>' sAjaxSource'' / admin / api / enrollments'
' oLanguage'
{
' sProcessing'' 正在加载注册,请稍候......'
}
});
});





每个FireBug的响应来自/ admin / api / enrollments:



 [{Name:name1,Campus:campus1,Advisor:advisor1,StepsCompleted:1,付费 :真正的 入门: 2013-06-15T04:07:08.7848004-04:00, 已完成: 2013-06-15T04:07:08.7848004-04:00, 选项: } { 名称: NAME2, 校园: campus2, 顾问: advisor2, StepsCompleted:2, 付费:真正的 入门:2013-06-15T04:07 :08.7848004-04:00\" , 已完成: 2013-06-15T04:07:08.7848004-04:00, 选项: },{ 名称: NAME3, 校园: campus3\" , 顾问: advisor3, StepsCompleted:3, 付费:真正的 入门: 2013-06-15T04:07:08.7848004-04:00, 已完成:2013- 06-15T04:07:08.7848004-04:00\" , 选项: },{ 名称: NAME4, 校园: campus4, 顾问: advisor4, StepsCompleted: 4, 付费:真正的 入门: 2013-06-15T04:07:08.7848004-04:00, 已完成: 2013-06-15T04:07:08.7848004-04:00,选项:}} 





我在这里缺少什么?





提前谢谢!


我弄清楚了。首先,JSON的格式不正确 - 你不只是返回数据,你还需要返回其他东西:



 { sEcho :1, iTotalRecords :4,iTotalDisplayRecords :4,sColumns :[ 顾问, 校园, 已完成, 姓名, 付费, 开始, StepsCompleted, 选项], aaData:[{ 名称: 名1, 校园: campus1, 顾问: advisor1, StepsCompleted:1, 付费:真开始: 2013-06-15T20:24:07.3187581-04:00, 已完成: 2013-06-15T20:24:07.3187581-04:00, 选项: },{ 名称: NAME2, 校园: campus2, 顾问: advisor2, StepsCompleted:2, 付费:真正的 入门:2013-06-15T20:24:07.3187581 -04:00\" , 已完成: 2013-06-15T20:24:07.3187581-04:00, 选项: },{ 名称: NAME3, 校园: campus3 顾问: advisor3, StepsCompleted:3, 付费:真正的 入门: 2013-06-15T20:24:07.3187581-04:00, 已完成:2013-06- 15T20:24:07.3187581-04:00\" , 选项: },{ 名称: NAME4, 校园: campus4, 顾问: advisor4, StepsCompleted:4, 付费:真正的入门:201 3-06-15T20:24:07.3187581-04:00\" , 已完成: 2013-06-15T20:24:07.3187581-04:00, 选项: }]} 





然后,您还需要在JS中定义列:



 

I'm new to DataTables.net and just can't figure out what I am missing, it's driving me crazy. It comes back with "aData is undefined" in the errors console.
I'm using DataTables 1.9.4 with the supplied in that package jQuery (not that it matters that much, I think).

HTML:

<table id="dt-enrollments">
		<thead>
			<tr>
				<th>Name</th>
				<th>Campus</th>
				<th>Advisor</th>
				<th>Steps Completed</th>
				<th>Paid</th>
				<th>Started</th>
				<th>Completed</th>
				<th>Options</th>
			</tr>
		</thead>
		<tbody>
		</tbody>
	</table>



JS:

$(document).ready(
			function()
			{
				$('#dt-enrollments').dataTable(
					{
						'sPaginationType': 'full_numbers',
						'bProcessing': true,
						'sAjaxSource': '/admin/api/enrollments',
						'oLanguage' :
							{
								'sProcessing': 'Loading enrollments, please wait...'
							}
					});
			});



Response from /admin/api/enrollments per FireBug:

[{"Name":"name1","Campus":"campus1","Advisor":"advisor1","StepsCompleted":1,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""},{"Name":"name2","Campus":"campus2","Advisor":"advisor2","StepsCompleted":2,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""},{"Name":"name3","Campus":"campus3","Advisor":"advisor3","StepsCompleted":3,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""},{"Name":"name4","Campus":"campus4","Advisor":"advisor4","StepsCompleted":4,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""}]



What am I missing here?


Thank you in advance!

解决方案

(document).ready( function() {


('#dt-enrollments').dataTable( { 'sPaginationType': 'full_numbers', 'bProcessing': true, 'sAjaxSource': '/admin/api/enrollments', 'oLanguage' : { 'sProcessing': 'Loading enrollments, please wait...' } }); });



Response from /admin/api/enrollments per FireBug:

[{"Name":"name1","Campus":"campus1","Advisor":"advisor1","StepsCompleted":1,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""},{"Name":"name2","Campus":"campus2","Advisor":"advisor2","StepsCompleted":2,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""},{"Name":"name3","Campus":"campus3","Advisor":"advisor3","StepsCompleted":3,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""},{"Name":"name4","Campus":"campus4","Advisor":"advisor4","StepsCompleted":4,"Paid":true,"Started":"2013-06-15T04:07:08.7848004-04:00","Completed":"2013-06-15T04:07:08.7848004-04:00","Options":""}]



What am I missing here?


Thank you in advance!


I figured it out. First, JSON is not in the correct format - you don't just return data, you need to return some other stuff, too:

{"sEcho":1,"iTotalRecords":4,"iTotalDisplayRecords":4,"sColumns":["Advisor","Campus","Completed","Name","Paid","Started","StepsCompleted","Options"],"aaData":[{"Name":"name1","Campus":"campus1","Advisor":"advisor1","StepsCompleted":1,"Paid":true,"Started":"2013-06-15T20:24:07.3187581-04:00","Completed":"2013-06-15T20:24:07.3187581-04:00","Options":""},{"Name":"name2","Campus":"campus2","Advisor":"advisor2","StepsCompleted":2,"Paid":true,"Started":"2013-06-15T20:24:07.3187581-04:00","Completed":"2013-06-15T20:24:07.3187581-04:00","Options":""},{"Name":"name3","Campus":"campus3","Advisor":"advisor3","StepsCompleted":3,"Paid":true,"Started":"2013-06-15T20:24:07.3187581-04:00","Completed":"2013-06-15T20:24:07.3187581-04:00","Options":""},{"Name":"name4","Campus":"campus4","Advisor":"advisor4","StepsCompleted":4,"Paid":true,"Started":"2013-06-15T20:24:07.3187581-04:00","Completed":"2013-06-15T20:24:07.3187581-04:00","Options":""}]}



And then, you also need to define columns in your JS:


这篇关于DataTables.net以“aData is undefined”返回的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆