NO LOAD DATA

NO LOAD DATA

LucianosilvaLucianosilva Posts: 1Questions: 1Answers: 0
edited December 2014 in Free community support

Please help me with de question. I dont know . the debug of the chrome show erro:Uncaught TypeError: Cannot set property 'nTf' of undefined

`` `
<?php require_once('Connections/SGEM.php'); ?>

<?php $query = mysql_query("SELECT Status, GREC, Material, Descricao,DATE_FORMAT(DataGrec,'%d/%m/%Y') AS DataGrec, QtddGrec, Locacao, Total, DURE, Indice FROM import WHERE DURE < 0 ORDER BY DataGrec ASC"); while($fetch = mysql_fetch_assoc($query)) { $output[] = $fetch; } echo json_encode($output); ?>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico">
<meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0">

<title>DataTables example - Language options</title>
<link  href="libraries/DataTables-1.10.4/media/css/jquery.dataTables.css" rel="stylesheet" type="text/css">

<script type="text/javascript" language="javascript" src="libraries/DataTables-1.10.4/media/js/jquery.js"></script>
<script type="text/javascript" language="javascript" src="libraries/DataTables-1.10.4/media/js/jquery.dataTables.js"></script>
$(document).ready(function() { var oTable = $('#Triagem').dataTable( { "SAjaxSource": "triagemjson.php", "aoColumns": [ {"MDATA": "Status"}, {"MDATA": "GREC"}, {"MDATA": "Material"}, {"MDATA": "Descricao"}, {"MDATA": "DataGrec"}, {"MDATA": "QtddGrec"}, {"MDATA": "Locacao"}, {"MDATA": "Total"}, {"MDATA": "DURE"}, {"MDATA": "Indice"} ] } ); } );

</head>

<body>

Status GREC Material Descrição DataGrec QtddGrec Locacao Total DURE Indice
Status GREC Material Descrição DataGrec QtddGrec Locacao Total DURE Indice

</body>
</html>

`` `

return No data available in table, o rerutn json is this:
[{"Status":"BF","GREC":"896165","Material":"A 3842900016","Descricao":"CJ PEDAL DA EMBREAGEM COMPL DI","DataGrec":"01\/08\/2014","QtddGrec":"15","Locacao":"BO 001","Total":"10","DURE":"-240.96","Indice":"0"},....}]

This discussion has been closed.