Bonjour,
Je souhaite utiliser le plug-in JQuery DataTables, mais j'obtiens le message suivant :
"DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error"

JSON : (valide avec JSONLint)
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
[{"sEcho":1,"iTotalRecords":4411,"iTotalDisplayRecords":4411,"aaData":[
["MARTIN STEPHANE","DS50610","pantalon HV(ref 3)","44","4","Commande"," "],
["MARTIN STEPHANE","DS50610","blouson de froid (ref 6B)","XL","2","Commande"," "],
["MARTIN STEPHANE","DS50610","T Shirt HV (ref 13)","XL","4","Commande"," "],
["MARTIN STEPHANE","DS50610","Chaussure de securite basse (ref 2\/3)","43","1","Commande"," "],
["MARTIN STEPHANE","DS52411","pantalon HV(ref 3)","44","4","Commande"," "],
["MARTIN STEPHANE","DS52411","T Shirt HV (ref 13)","XL","5","Commande"," "],
["MARTIN STEPHANE","DS52411","Chaussure de securite basse (ref 2\/3)","43","1","Commande"," "],
["MARTIN STEPHANE","DS52411","Chaussure de securite PTFE ( ref 3-1)","43","1","Commande"," "],
["DUPONT ROBERT","DC22811","Combinaison HV(ref 5)","3","1","Commande"," "],
["DUPONT ROBERT","DC22811","Surveste de pluie HV ( ref 6A )","M","1","Commande"," "]]}
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
<script language="javascript">	
			 $(document).ready(function() {
					$('#tabliste').dataTable( {
						"bProcessing": true,
						"bServerSide": true,
						"sAjaxSource": "server_processing_mssql.php"
					} );
			});
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
<table id="tabliste"class="dataTable" width="100%">
	<thead>
	    <tr>
		<th width="20%">Agent</th>
		<th width="10%">N°Cde</th>
		<th width="20%">Désignation Article</th>
		<th width="5%">Taille</th>
		<th width="5%">Qté</th>
		<th width="10%">Etat</th>
		<th width="30%">Observation</th>					  
	    </tr>
	</thead>			
	<tbody>							
	    <tr>
		<td colspan="7" class="dataTables_empty">Loading data from server</td>												
	   </tr>	
	</tbody>			
</table>
Merci pour votre aide