Hi Guys,
I am on the latest version you sent me.
I think the issue is the format of the data returned.
I have validated this as valid Json data.
I am trying to populate the DataTable using the following code.
Is the issue how to pass the data here:
DataTable1.settings.data = req.responseText ;//JSON.parse(dataJson2);
i.e. how do I pass the data in the correct format.
I have tried various parse / stringify etc.
I am getting this error:
TypeError: url.lastIndexOf is not a function. (In 'url.lastIndexOf('/')', 'url.lastIndexOf' is undefined).
line 3923 column 57
If I use some data formatted as
var data1 = [
["Tiger Nixon", "System Architect", "Edinburgh", "5421", "2011/04/25", "$320,800"],
["Garrett Winters", "Accountant", "Tokyo", "8422", "2011/07/25", "$170,750"]
]
I can populate the dataTable with
var dataJson = JSON.stringify(data1);
var table = $("#DataTable1").DataTable();
table.clear();
DataTable1.settings.data = JSON.parse(dataJson);
setTimeout(loadTable, 50);
Button1.onclick=function(){
req = Ajax("http://www.toolfolks.com/techy/someData.php", "GET", txtSend.value, done);
}
function done() {
if (req.status == 200) { //success
htmResponse.innerHTML = req.responseText;
console.log('This is the data'+req.responseText);
// add to grid
var table = $("#DataTable1").DataTable();
table.clear();
var dataJson2 = JSON.stringify(htmResponse.innerHTML);
DataTable1.settings.data = req.responseText ;//JSON.parse(dataJson2);
setTimeout(loadTable, 50);
}
else {//'failure
htmResponse.innerHTML=req.err;
}
}
function loadTable() {
var table = $("#DataTable1").DataTable();
table.rows.add(DataTable1.settings.data).draw();
}
[{"invoice_no":"704523213-6","product_name":"Thyroidinum, Baryta carb., Berber. vulg., Bryonia, Calc. carb., Cinchona, Conium, Digitalis, Ferrum picricum, Hydrastis, Iodium, Lycopodium, Nux vom., Pareira, Pulsatilla, Sabal, Selenium, Staphysag., Thuja occ.,Trifolium pratense, Echinacea, Lappa, Solid","delivery_status":"0","pin_code":"9616"},{"invoice_no":"873879067-X","product_name":"OCTINOXATE and TITANIUM DIOXIDE","delivery_status":"0","pin_code":"90"},{"invoice_no":"888174546-1","product_name":"coffee bean","delivery_status":"0","pin_code":"5"},{"invoice_no":"742900466-0","product_name":"Bupropion Hydrochloride","delivery_status":"1","pin_code":"2"},{"invoice_no":"505396330-4","product_name":"Caffeine","delivery_status":"1","pin_code":"8313"},{"invoice_no":"344082937-5","product_name":"dimethicone","delivery_status":"1","pin_code":"816"},{"invoice_no":"824881650-8","product_name":"Oxazepam","delivery_status":"0","pin_code":"6944"},{"invoice_no":"793629004-4","product_name":"estradiol","delivery_status":"0","pin_code":"536"},{"invoice_no":"751800320-1","product_name":"SULFUR,SULFACETAMIDE SODIUM","delivery_status":"1","pin_code":"73"},{"invoice_no":"124982586-5","product_name":"Miconazole nitrate","delivery_status":"1","pin_code":"8"},{"invoice_no":"393625687-X","product_name":"dextromethorphan HBr, doxylamine succinate","delivery_status":"1","pin_code":"94271"},{"invoice_no":"533099566-3","product_name":"BENZALKONIUM CHLORIDE","delivery_status":"0","pin_code":"38"},{"invoice_no":"415234478-4","product_name":"acetaminophen, dextromethorphan hydrobromide and doxylamine succinate","delivery_status":"0","pin_code":"2"},{"invoice_no":"137027302-9","product_name":"PULSATILLA, ALLIUM CEPA, ARSENICUM ALBUM, NUX VOMICA, EUPHRASIA OFFICINALIS, SABADILLA, STICTA PULMONARIA, ARALIA RACEMOSA, CUPRUM METALLICUM","delivery_status":"1","pin_code":"72"},{"invoice_no":"428527283-0","product_name":"levofloxacin","delivery_status":"1","pin_code":"60"},{"invoice_no":"271939674-5","product_name":"Phenytoin","delivery_status":"0","pin_code":"7903"},{"invoice_no":"847229680-6","product_name":"Glipizide","delivery_status":"1","pin_code":"41"},{"invoice_no":"862907237-7","product_name":"methylphenidate hydrochloride","delivery_status":"1","pin_code":"23"},{"invoice_no":"092319365-0","product_name":"bisacodyl","delivery_status":"1","pin_code":"4"},{"invoice_no":"357948877-5","product_name":"hydrocodone bitartrate and ibuprofen","delivery_status":"1","pin_code":"78857"},{"invoice_no":"126264383-X","product_name":"Bisacodyl","delivery_status":"1","pin_code":"61007"},{"invoice_no":"822256216-9","product_name":"Treatment Set TS346876","delivery_status":"0","pin_code":"42"},{"invoice_no":"448501691-9","product_name":"Alcohol","delivery_status":"0","pin_code":"58641"},{"invoice_no":"486144265-6","product_name":"Carvedilol","delivery_status":"1","pin_code":"9"},{"invoice_no":"973277310-3","product_name":"buspirone hydrochloride","delivery_status":"1","pin_code":"41"},{"invoice_no":"615440246-5","product_name":"Carvedilol","delivery_status":"0","pin_code":"84"},{"invoice_no":"930597430-9","product_name":"TERBUTALINE SULFATE","delivery_status":"0","pin_code":"41"},{"invoice_no":"153411247-2","product_name":"Oak White","delivery_status":"0","pin_code":"21"},{"invoice_no":"627228036-X","product_name":"VERAPAMIL HYDROCHLORIDE","delivery_status":"0","pin_code":"69"},{"invoice_no":"302659823-2","product_name":"Ceftriaxone Sodium","delivery_status":"0","pin_code":"368"},{"invoice_no":"531848284-8","product_name":"glipizide","delivery_status":"1","pin_code":"7"},{"invoice_no":"086245636-3","product_name":"factor ix complex","delivery_status":"1","pin_code":"80"},{"invoice_no":"987178075-3","product_name":"Ceftriaxone Sodium","delivery_status":"1","pin_code":"648"},{"invoice_no":"561582077-2","product_name":"Pyrithione Zinc","delivery_status":"0","pin_code":"0"},{"invoice_no":"235966890-0","product_name":"Agnus castus, Arnica montana, Baryta carbonica, Caladium seguinum, Kali bromatum, Lycopodium clavatum, nuphar luteum, Nux vomica, Onosmodium virginianum, Phosphoricum acidum, Picnicum acidum, Selenium metallicum","delivery_status":"1","pin_code":"84009"},{"invoice_no":"247885358-2","product_name":"LATANOPROST","delivery_status":"0","pin_code":"233"},{"invoice_no":"271660434-7","product_name":"Diethylpropion hydrochloride","delivery_status":"1","pin_code":"54452"},{"invoice_no":"813320093-8","product_name":"Magnesium Citrate","delivery_status":"1","pin_code":"2"},{"invoice_no":"113150242-6","product_name":"Silver Maple","delivery_status":"1","pin_code":"93"},{"invoice_no":"311237529-7","product_name":"ALCOHOL","delivery_status":"1","pin_code":"56532"},{"invoice_no":"133196175-0","product_name":"Loperamide HCl","delivery_status":"1","pin_code":"9990"},{"invoice_no":"346713651-6","product_name":"Amitriptyline Hydrochloride","delivery_status":"1","pin_code":"8"},{"invoice_no":"380694458-X","product_name":"acetaminophen","delivery_status":"1","pin_code":"617"},{"invoice_no":"151137649-X","product_name":"OCTINOXATE and TITANIUM DIOXIDE","delivery_status":"0","pin_code":"70699"},{"invoice_no":"869299262-3","product_name":"DIPHENHYDRAMINE HYDROCHLORIDE","delivery_status":"1","pin_code":"18"},{"invoice_no":"289291592-9","product_name":"Danazol","delivery_status":"0","pin_code":"570"},{"invoice_no":"284994139-5","product_name":"simvastatin","delivery_status":"1","pin_code":"2597"},{"invoice_no":"445209665-4","product_name":"TETRAHYDROZOLINE HYDROCHLORIDE","delivery_status":"1","pin_code":"9527"},{"invoice_no":"227399116-9","product_name":"Benzalkonium Chloride","delivery_status":"1","pin_code":"788"},{"invoice_no":"714837287-9","product_name":"AVOBENZONE, OCTINOXATE,OCTISALATE","delivery_status":"1","pin_code":"118"},{"invoice_no":"133949701-8","product_name":"escitalopram","delivery_status":"1","pin_code":"3"},{"invoice_no":"991791431-5","product_name":"Aluminum Zirconium Tetrachlorohydrex GLY","delivery_status":"1","pin_code":"5"},{"invoice_no":"529683170-5","product_name":"ganciclovir sodium","delivery_status":"1","pin_code":"9"},{"invoice_no":"842657445-9","product_name":"Acetaminophen","delivery_status":"0","pin_code":"670"},{"invoice_no":"785100365-2","product_name":"Western Water Hemp","delivery_status":"1","pin_code":"82324"},{"invoice_no":"882329081-3","product_name":"Doxycycline Hyclate","delivery_status":"1","pin_code":"763"},{"invoice_no":"230796197-6","product_name":"ALCOHOL","delivery_status":"1","pin_code":"63477"},{"invoice_no":"541346259-X","product_name":"losartan potassium and hydrochlorothiazide","delivery_status":"0","pin_code":"800"},{"invoice_no":"973060608-0","product_name":"Acetaminophen, Phenylephrine HCl","delivery_status":"1","pin_code":"12984"},{"invoice_no":"563841670-6","product_name":"Mometasone furoate monohydrate","delivery_status":"1","pin_code":"16"},{"invoice_no":"340186652-4","product_name":"Morphine sulfate","delivery_status":"1","pin_code":"396"},{"invoice_no":"741830611-3","product_name":"ZINC OXIDE","delivery_status":"1","pin_code":"804"},{"invoice_no":"542955494-4","product_name":"ALPRAZOLAM","delivery_status":"1","pin_code":"4"},{"invoice_no":"864090158-9","product_name":"Nitrous Oxide","delivery_status":"1","pin_code":"47"},{"invoice_no":"079288528-7","product_name":"TRICLOSAN","delivery_status":"0","pin_code":"134"},{"invoice_no":"358384712-1","product_name":"Mirtazapine","delivery_status":"0","pin_code":"51"},{"invoice_no":"732437456-5","product_name":"calcium carbonate","delivery_status":"0","pin_code":"742"},{"invoice_no":"344524760-9","product_name":"Mineral Oil","delivery_status":"0","pin_code":"5321"},{"invoice_no":"412917237-9","product_name":"Dextromethorphan HBr","delivery_status":"0","pin_code":"6223"},{"invoice_no":"742834065-9","product_name":"Chamomilla, Myrrha, Rosmarinus, Ruta, Symphytum, Antimon Tart, RSV.","delivery_status":"1","pin_code":"70198"},{"invoice_no":"582729740-2","product_name":"Triclosan","delivery_status":"0","pin_code":"386"},{"invoice_no":"599415748-1","product_name":"Eucalyptus (Blue Gum) Eucalyptus globulus","delivery_status":"1","pin_code":"50498"},{"invoice_no":"218164196-X","product_name":"Thioridazine Hydrochloride","delivery_status":"0","pin_code":"2809"},{"invoice_no":"889690163-4","product_name":"CLOTRIMAZOLE","delivery_status":"1","pin_code":"24214"},{"invoice_no":"072490809-9","product_name":"Triamterene and Hydrochlorothiazide","delivery_status":"0","pin_code":"2"},{"invoice_no":"736005670-5","product_name":"lisdexamfetamine dimesylate","delivery_status":"0","pin_code":"51477"},{"invoice_no":"668774669-3","product_name":"Esterified Estrogens and Methyltestosterone","delivery_status":"1","pin_code":"4841"},{"invoice_no":"290961790-4","product_name":"Acetaminophen, Chlorpheniramine maleate, Dextromethorphan HBr, Phenylephrine HCl","delivery_status":"0","pin_code":"298"},{"invoice_no":"259230387-1","product_name":"PREGABALIN","delivery_status":"0","pin_code":"1648"},{"invoice_no":"880366143-3","product_name":"Chaetomium globosum","delivery_status":"1","pin_code":"1"},{"invoice_no":"891173758-5","product_name":"CLOVE","delivery_status":"1","pin_code":"7201"},{"invoice_no":"072553405-2","product_name":"Acetaminophen","delivery_status":"0","pin_code":"34452"},{"invoice_no":"316716477-8","product_name":"Apis Belladonna Mercurius","delivery_status":"1","pin_code":"975"},{"invoice_no":"179222518-0","product_name":"methylphenidate hydrochloride","delivery_status":"1","pin_code":"0"},{"invoice_no":"362689132-1","product_name":"Doxazosin Mesylate","delivery_status":"1","pin_code":"2731"},{"invoice_no":"127180182-5","product_name":"Calcium Carbonate","delivery_status":"0","pin_code":"56693"},{"invoice_no":"889833147-9","product_name":"Salicylic Acid","delivery_status":"0","pin_code":"46"},{"invoice_no":"835056640-X","product_name":"ethanol","delivery_status":"1","pin_code":"926"},{"invoice_no":"068110653-0","product_name":"SODIUM MONOFLUOROPHOSPHATE","delivery_status":"0","pin_code":"6"},{"invoice_no":"082635876-4","product_name":"Sulfamethoxazole and Trimethoprim","delivery_status":"0","pin_code":"33"},{"invoice_no":"277729706-1","product_name":"doxepin hydrochloride","delivery_status":"0","pin_code":"4570"},{"invoice_no":"614260216-2","product_name":"Meropenem","delivery_status":"1","pin_code":"1703"},{"invoice_no":"694172798-5","product_name":"Amphotericin B","delivery_status":"0","pin_code":"3"},{"invoice_no":"894328008-4","product_name":"Western Juniper","delivery_status":"0","pin_code":"49628"},{"invoice_no":"966169677-2","product_name":"Avobenzone, Homosalate, Octisalate, Octocrylene, and Oxybenzone","delivery_status":"0","pin_code":"1396"},{"invoice_no":"086967433-1","product_name":"Pemetrexed disodium","delivery_status":"0","pin_code":"69638"},{"invoice_no":"902504964-8","product_name":"BENZOYL PEROXIDE","delivery_status":"0","pin_code":"7"},{"invoice_no":"443655470-8","product_name":"risperidone","delivery_status":"1","pin_code":"11591"},{"invoice_no":"132374458-4","product_name":"OXYGEN","delivery_status":"1","pin_code":"6233"},{"invoice_no":"286421306-0","product_name":"Allergenic Extracts Alum Precipitated","delivery_status":"1","pin_code":"128"}]