jquery - Datatables server side data response error -


i getting following error when try fetch data server side script

datatables warning: table id=example - requested unknown parameter '0' row 0. more information error, please see http://datatables.net/tn/4

what doing wrong ?

here's html

<script> $(document).ready(function(){     $('#example').datatable({         serverside: true,         "columndefs": [             { "title": "sr.",           "name": "sr",           "width": "5%",  "targets": 0 },             { "title": "ecode",         "name": "code",         "width": "5%",  "targets": 1 },             { "title": "employee name", "name": "name",         "width": "25%", "targets": 2 },             { "title": "guardian",      "name": "guardian",     "width": "20%", "targets": 3 },             { "title": "doa",           "name": "doa",          "width": "10%", "targets": 4 },             { "title": "department",    "name": "department",   "width": "20%", "targets": 5 },             { "title": "designation",   "name": "designation",  "width": "20%", "targets": 6 }         ],         ajax: {             url: 'employees/listdata/all',             type: 'post'         }     }); }); </script> <table id="example" class="display" cellspacing="0" width="100%"> </table>

here's json response

{ "recordstotal":842, "recordsfiltered":842, "data":[     {"dt_rowid":"28","sr":"1","code":"28","name":"abhishek sharma","guardian":"ramesh chand","doa":"10\/12\/2013","department":"welding shop","designation":"m. operator - nut former"},     {"dt_rowid":"66","sr":"2","code":"66","name":"achhay lal","guardian":"baharan mahto","doa":"26\/06\/2013","department":"workshop","designation":"store keeper"},     {"dt_rowid":"454","sr":"3","code":"454","name":"achhay lal","guardian":"jai kumar","doa":"26\/01\/2015","department":"cutting department","designation":"quality controller"}     ] }

i found solution , usual simple overlooked

<script> $(document).ready(function(){     $('#example').datatable({         "processing": true,         "serverside": true,         "columndefs": [             { "data": "sr",             "title": "sr.",             "name": "sr",           "width": "5%",  "targets": 0 },             { "data": "code",           "title": "ecode",           "name": "code",         "width": "5%",  "targets": 1 },             { "data": "name",           "title": "employee name",   "name": "name",         "width": "25%", "targets": 2 },             { "data": "guardian",       "title": "guardian",        "name": "guardian",     "width": "15%", "targets": 3 },             { "data": "doa",            "title": "doa",             "name": "doa",          "width": "10%", "targets": 4 },             { "data": "department",     "title": "department",      "name": "department",   "width": "20%", "targets": 5 },             { "data": "designation",    "title": "designation",     "name": "designation",  "width": "20%", "targets": 6 }         ],         ajax: {             url: 'employees/listdata/all',             type: 'post'         }     }); }); </script> <table id="example" class="display" cellspacing="0" width="100%"></table>

i added data property each column , worked perfectly.


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more