Originally Posted by
Daniil
Hi @Vinci,
It is not a problem that you are asking us. Thank you for your activity on the forums.
Regarding the problem.
Could you provide a test case to reproduce?
Thank you for your kindly help.
It is difficult to provide a complete program, as the function is separated into different module...
I will show the major parts, please tell me it is enough or not.
This is the function to convert dataset to jason
public static string DataSetToJson(DataSet ds)
{
JsonHelper jsonHelp = new JsonHelper();
jsonHelp.success = true;
Dictionary<string, string> colNames = new Dictionary<string, string>();
var cols = ds.Tables[0].Columns;
for (int i = 0; i < cols.Count; i++)
if (colNames.ContainsKey(cols[i].Caption))
throw new Exception("Duplicate caption (" + cols[i].Caption + ") in DataTable when using the method DataSetToJson!");
else
colNames.Add(cols[i].Caption, cols[i].Caption);
const string keyword = "_id";
if (colNames.ContainsKey(keyword))
throw new Exception("Duplicate caption (" + keyword + ") in DataTable when using the method DataSetToJson!");
int n = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
jsonHelp.AddItem(keyword, n.ToString());
n++;
foreach (var c in colNames)
{
jsonHelp.AddItem(c.Value, dr[c.Key].ToString());
}
jsonHelp.ItemOk();
}
jsonHelp.totlalCount = ds.Tables[0].Rows.Count;
string str = jsonHelp.ToString();
return str;
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
sb.Append("{");
sb.Append("totalCount:" + totlalCount.ToString() + ",");
sb.Append("success:" + _success.ToString().ToLower() + ",");
sb.Append("error:\"" + _error.Replace("\"", "\\\"") + "\",");
sb.Append("singleInfo:\"" + singleInfo.Replace("\"", "\\\"") + "\",");
sb.Append("data:[");
int index = 0;
sb.Append("{");
if (arrData.Count <= 0)
{
sb.Append("}]");
}
else
{
foreach (string val in arrData)
{
index++;
if (val != "<BR>")
{
sb.Append(val + ",");
}
else
{
sb = sb.Replace(",", "", sb.Length - 1, 1);
sb.Append("},");
if (index < arrData.Count)
{
sb.Append("{");
}
}
}
sb = sb.Replace(",", "", sb.Length - 1, 1);
sb.Append("]");
}
sb.Append("}");
return sb.ToString();
}
The proxy is defined as
public static AjaxProxy GetProxy(string url)
{
AjaxProxy proxy = new AjaxProxy
{
Url = url
};
proxy.ActionMethods.Read = HttpMethod.GET;
JsonReader reader = new JsonReader
{
Root = "data",
TotalProperty = "totalCount"
};
proxy.Reader.Add(reader);
return proxy;
}
Here is the return jason that cause problem
"{totalCount:94,success:true,error:\"\",singleInfo:\"\",data:[{\"_id\":\"0\",\"ITMITMNO\":\"*All\",\"ITMNAM\":\"\",\"SYCDESC\":\"\",\"ITMTYPE\":\"\",\"ITMSTATUS\":\"\",\"ITMSTPFLG\":\"\"},{\"_id\":\"1\",\"ITMITMNO\":\"00000001\",\"ITMNAM\":\"ITEM NAME FOR TESTING----------------------------X\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"2\",\"ITMITMNO\":\"00000013\",\"ITMNAM\":\"Huchison by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"3\",\"ITMITMNO\":\"00000019\",\"ITMNAM\":\"Swire A by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"4\",\"ITMITMNO\":\"00000653\",\"ITMNAM\":\"B'jour\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"5\",\"ITMITMNO\":\"00000729\",\"ITMNAM\":\"Sky Thunder\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"6\",\"ITMITMNO\":\"00001398\",\"ITMNAM\"
:\"ICBC\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"7\",\"ITMITMNO\":\"60020003\",\"ITMNAM\":\"IBM 160GB 7,200 rpm SATA HDD (39M4504)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"8\",\"ITMITMNO\":\"60020004\",\"ITMNAM\":\"IBM 160GB 7,200 rpm SATA HDD (09N4254)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"9\",\"ITMITMNO\":\"60020005\",\"ITMNAM\":\"IBM 160GB 7,200 rpm Hot Swap SATA HDD (39M4522)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"10\",\"ITMITMNO\":\"60020006\",\"ITMNAM\":\"IBM 160GB 7,200 rpm SATA-150 HDD (73P8003)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"11\",\"ITMITMNO\":\"60030001\",\"ITMNAM\":\"IBM 250GB 7,200rpm SATA HDD (39M4526-01)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"12\",\"ITMITMNO\":\"600400
01\",\"ITMNAM\":\"IBM 250GB 7,200rpm SATA HDD (39M4526)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"13\",\"ITMITMNO\":\"60120011\",\"ITMNAM\":\"DB500 KEYMAT ASSY\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"14\",\"ITMITMNO\":\"60120013\",\"ITMNAM\":\"DB500 WINDOW ASSY\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"15\",\"ITMITMNO\":\"60120014\",\"ITMNAM\":\"DB500 B COVER ASSY (GREY)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"16\",\"ITMITMNO\":\"60140001\",\"ITMNAM\":\"DB500 VOLUME SWITCH\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"17\",\"ITMITMNO\":\"60170003\",\"ITMNAM\":\"E0064BA/EPDM RUBBER\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"18\",\"ITMITMNO\":\"60170005\",\"ITMNAM\":\"M800\",\"SYCDESC\":\"Model\",\"ITMTYPE\
":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"19\",\"ITMITMNO\":\"60170011\",\"ITMNAM\":\"E0050G-2A\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"20\",\"ITMITMNO\":\"60230007\",\"ITMNAM\":\"CHIP RESISTOR (MCR18EZPF1000)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"21\",\"ITMITMNO\":\"60230014\",\"ITMNAM\":\"Seagate 160GB 2.5\" 5,400rpm IDE HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"22\",\"ITMITMNO\":\"60230016\",\"ITMNAM\":\"Seagate 160GB 2.5\" 5,400rpm SATA HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"23\",\"ITMITMNO\":\"60240001\",\"ITMNAM\":\"Seagate 160GB 3.5\" 7,200rpm IDE HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"24\",\"ITMITMNO\":\"60240002\",\"ITMNAM\":\"Seagate 160GB 3.5\" 7,200rpm SATA HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\"
,\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"25\",\"ITMITMNO\":\"60240006\",\"ITMNAM\":\"Seagate 40GB 7,200rpm IDE HDD (ST340014A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"26\",\"ITMITMNO\":\"60240012\",\"ITMNAM\":\"Seagate 80GB 2.5\" 5,400rpm IDE HDD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"27\",\"ITMITMNO\":\"60240013\",\"ITMNAM\":\"Seagate 80GB 7,200rpm IDE HDD (ST380011A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"28\",\"ITMITMNO\":\"60240014\",\"ITMNAM\":\"Seagate 80GB 7,200rpm IDE HDD (ST380215A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"29\",\"ITMITMNO\":\"60240015\",\"ITMNAM\":\"Seagate 80GB 7,200rpm SATA HDD (ST380815AS)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"30\",\"ITMITMNO\":\"60240016\",\"ITMNAM\":\"Toshiba 80GB 5,400rpm IDE HDD\",
\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"31\",\"ITMITMNO\":\"60240017\",\"ITMNAM\":\"Western Digital 40GB 7,200rpm IDE HDD (WD400)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"32\",\"ITMITMNO\":\"60260001\",\"ITMNAM\":\"Western Digital 80GB 7,200rpm IDE HDD (800BB)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"33\",\"ITMITMNO\":\"60260003\",\"ITMNAM\":\"Casio Laser Hand Held Terminal (DT900M60E)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"34\",\"ITMITMNO\":\"74806001\",\"ITMNAM\":\"プリント基板001\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"35\",\"ITMITMNO\":\"90010002\",\"ITMNAM\":\"CF0036001 WATER PROOF PACKING TOOLING\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"36\",\"ITMITMNO\":\"90100020\",\"ITMNAM\":\"Lenovo ThinkVisi
on L1900p 19\" LCD Monitor\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"37\",\"ITMITMNO\":\"90100024\",\"ITMNAM\":\"3Com Fast Ethernet 10/100 PCI Card (3C905CX-TX-NM)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"38\",\"ITMITMNO\":\"90100030\",\"ITMNAM\":\"3Com 10/100 PCMCIA Card\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"39\",\"ITMITMNO\":\"90170002\",\"ITMNAM\":\"HP Laserjet 1200 Printer (HP-C7044A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"40\",\"ITMITMNO\":\"90170003\",\"ITMNAM\":\"HP Laserjet 1300 Printer (HP-Q1334A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"41\",\"ITMITMNO\":\"90170004\",\"ITMNAM\":\"HP Laserjet 1300N Printer (HP-Q1335A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"42\",\"ITMITMNO\":\"9017000
7\",\"ITMNAM\":\"HP Laserjet 2200DN Printer (HP-C7063A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"43\",\"ITMITMNO\":\"90170008\",\"ITMNAM\":\"HP Laserjet 2300 Printer (HP-Q2472A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"44\",\"ITMITMNO\":\"90170009\",\"ITMNAM\":\"HP Laserjet 2300D Printer (HP-Q2474A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"45\",\"ITMITMNO\":\"90170010\",\"ITMNAM\":\"HP Laserjet 2300DN Printer (HP-Q2475A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"46\",\"ITMITMNO\":\"90170011\",\"ITMNAM\":\"HP Laserjet 2300DTN Printer (HP-Q2476A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"47\",\"ITMITMNO\":\"90170012\",\"ITMNAM\":\"HP Laserjet 2300N Printer (HP-Q2473A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_
id\":\"48\",\"ITMITMNO\":\"90170016\",\"ITMNAM\":\"HP Color Laserjet 2500 Printer (HP-C9706A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"49\",\"ITMITMNO\":\"90170017\",\"ITMNAM\":\"HP Color Laserjet 2600N Printer (HP-Q6455A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"50\",\"ITMITMNO\":\"90170022\",\"ITMNAM\":\"HP Color Laserjet 3500N Printer (HP-1320A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"51\",\"ITMITMNO\":\"90170023\",\"ITMNAM\":\"HP Color Laserjet 3600N Printer (HP-Q5987A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"52\",\"ITMITMNO\":\"90170024\",\"ITMNAM\":\"HP Color Laserjet 3800N Printer (HP-Q5982A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"53\",\"ITMITMNO\":\"90170025\",\"ITMNAM\":\"HP Laserjet 4200 Printer (HP-Q2425A)\",\"SYCDESC\":\"Model\",\"ITM
TYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"54\",\"ITMITMNO\":\"90170026\",\"ITMNAM\":\"HP Laserjet 4200DTN Printer (HP-Q2428A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"55\",\"ITMITMNO\":\"90170027\",\"ITMNAM\":\"HP Laserjet 4200N Printer (HP-Q2426A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"56\",\"ITMITMNO\":\"90230001\",\"ITMNAM\":\"HP Laserjet 4200TN Printer (HP-Q2427A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"57\",\"ITMITMNO\":\"90230002\",\"ITMNAM\":\"HP Laserjet 4250 Printer (HP-Q5400A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"58\",\"ITMITMNO\":\"90230006\",\"ITMNAM\":\"HP Laserjet 4300 Printer (HP-Q2431A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"59\",\"ITMITMNO\":\"90230007\",\"ITMNAM\":\"HP Laserjet 4300DTN Printer (HP-Q24
34A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"60\",\"ITMITMNO\":\"90230008\",\"ITMNAM\":\"HP Laserjet 4300N Printer (HP-Q2432A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"61\",\"ITMITMNO\":\"90230009\",\"ITMNAM\":\"HP Laserjet 4300TN Printer (HP-Q2433A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"62\",\"ITMITMNO\":\"90230013\",\"ITMNAM\":\"HP Color Laserjet 4600 Printer(HP-C9660A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"63\",\"ITMITMNO\":\"90230014\",\"ITMNAM\":\"HP Color Laserjet 4600DN Printer (HP-C9661A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"64\",\"ITMITMNO\":\"90230015\",\"ITMNAM\":\"HP Laserjet 5100 Printer (HP-Q1860A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"65\",\"ITMITMNO\":\"90240001\",\"IT
MNAM\":\"HP Laserjet 5100TN Printer (HP-Q1861A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"66\",\"ITMITMNO\":\"90240002\",\"ITMNAM\":\"HP Laserjet 5200 Printer (HP-Q7543A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"67\",\"ITMITMNO\":\"90240003\",\"ITMNAM\":\"HP Laserjet 5200N Printer (HP-Q7544A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"68\",\"ITMITMNO\":\"90240004\",\"ITMNAM\":\"HP Laserjet 5200TN Printer (HP-Q7545A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"69\",\"ITMITMNO\":\"90240005\",\"ITMNAM\":\"HP Color Laserjet 5500 Printer (HP-C9656A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"70\",\"ITMITMNO\":\"90240019\",\"ITMNAM\":\"HP Laserjet P3005 Printer (HP-Q7812A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":
\"71\",\"ITMITMNO\":\"90240020\",\"ITMNAM\":\"HP Laserjet P3005D Printer (HP-Q7813A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"72\",\"ITMITMNO\":\"90240021\",\"ITMNAM\":\"HP Laserjet P3005DN Printer (HP-Q7815A)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"73\",\"ITMITMNO\":\"90240042\",\"ITMNAM\":\"GOMUBANE 1 903-A00020\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"Y\"},{\"_id\":\"74\",\"ITMITMNO\":\"90240043\",\"ITMNAM\":\"GOMUBANE 2 (903-A00030)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"75\",\"ITMITMNO\":\"90240044\",\"ITMNAM\":\"SPRING GOMU 268-A00040\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"76\",\"ITMITMNO\":\"90240049\",\"ITMNAM\":\"903-A00070 & 71 MOLD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"77\",\"ITMITMNO\":\"902400
58\",\"ITMNAM\":\"GOMUBANE 903-A00070 (40p)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"78\",\"ITMITMNO\":\"90240063\",\"ITMNAM\":\"512MB PC2100 ECC DDR SDRAM (10K0069)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"79\",\"ITMITMNO\":\"90240076\",\"ITMNAM\":\"1X512MB RAM for IBM X3200 (41Y2726)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"80\",\"ITMITMNO\":\"90240077\",\"ITMNAM\":\"2X512MB RAM for IBM X3400 (39M5782)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"81\",\"ITMITMNO\":\"90240078\",\"ITMNAM\":\"2X1GB Chipkill RAM for X3400 (39M5785)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"82\",\"ITMITMNO\":\"90240079\",\"ITMNAM\":\"2X1GB Chipkill RAM for IBM X3400 (46C7418)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"83\",\
"ITMITMNO\":\"90240080\",\"ITMNAM\":\"1 X 2GB DDR3 SDRAM (2R x8) for X3400M2 (44T1481)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"84\",\"ITMITMNO\":\"90240083\",\"ITMNAM\":\"256MB RAM for NEC 5800/110Ed2 (RMC133/256)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"85\",\"ITMITMNO\":\"90240084\",\"ITMNAM\":\"128MB RAM for NEC 5800/110Ee (KVR133X72RC3/128)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"86\",\"ITMITMNO\":\"90240085\",\"ITMNAM\":\"256MB RAM for NEC 5800/110Ee (KVR133X72RC3/256)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"87\",\"ITMITMNO\":\"90240086\",\"ITMNAM\":\"512MB RAM for NEC 5800/110Ee (KVR133X72RC3/512)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"88\",\"ITMITMNO\":\"90240087\",\"ITMNAM\":\"128MB RAM for NEC 5800/110Eg (D1664B250)\",\"SYCDESC\":\"Mode
l\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"89\",\"ITMITMNO\":\"90310001\",\"ITMNAM\":\"256MB RAM for NEC 5800/51La (FIFO)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"90\",\"ITMITMNO\":\"90330001\",\"ITMNAM\":\"512MB 400MHz DDR RAM (KVR400X64C3A/512)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"O\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"91\",\"ITMITMNO\":\"CD-SC-221\",\"ITMNAM\":\"RL OF 10,000 PCS\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"92\",\"ITMITMNO\":\"N1000-GE-FE1108-U\",\"ITMNAM\":\"N1000 GE FE1108\",\"SYCDESC\":\"Parts\",\"ITMTYPE\":\"P\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"93\",\"ITMITMNO\":\"SM0120L100\",\"ITMNAM\":\"SM 1.2\" 100M\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"}]}"
And this have no problem
"{totalCount:15,success:true,error:\"\",singleInfo:\"\",data:[{\"_id\":\"0\",\"ITMITMNO\":\"*All\",\"ITMNAM\":\"\",\"SYCDESC\":\"\",\"ITMTYPE\":\"\",\"ITMSTATUS\":\"\",\"ITMSTPFLG\":\"\"},{\"_id\":\"1\",\"ITMITMNO\":\"00000001\",\"ITMNAM\":\"ITEM NAME FOR TESTING----------------------------X\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"2\",\"ITMITMNO\":\"00000013\",\"ITMNAM\":\"Huchison by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"3\",\"ITMITMNO\":\"00000019\",\"ITMNAM\":\"Swire A by Lot\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"4\",\"ITMITMNO\":\"00000653\",\"ITMNAM\":\"B'jour\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"5\",\"ITMITMNO\":\"00000729\",\"ITMNAM\":\"Sky Thunder\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"6\",\"ITMITMNO\":\"00001398\",\"ITMNAM\"
:\"ICBC\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"7\",\"ITMITMNO\":\"60230007\",\"ITMNAM\":\"CHIP RESISTOR (MCR18EZPF1000)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"8\",\"ITMITMNO\":\"90240042\",\"ITMNAM\":\"GOMUBANE 1 903-A00020\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"Y\"},{\"_id\":\"9\",\"ITMITMNO\":\"90240043\",\"ITMNAM\":\"GOMUBANE 2 (903-A00030)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"10\",\"ITMITMNO\":\"90240044\",\"ITMNAM\":\"SPRING GOMU 268-A00040\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"11\",\"ITMITMNO\":\"90240049\",\"ITMNAM\":\"903-A00070 & 71 MOLD\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"12\",\"ITMITMNO\":\"90240058\",\"ITMNAM\":\"GOMUBANE 903-A00070 (40p)\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"IT
MSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"13\",\"ITMITMNO\":\"CD-SC-221\",\"ITMNAM\":\"RL OF 10,000 PCS\",\"SYCDESC\":\"Model\",\"ITMTYPE\":\"M\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"},{\"_id\":\"14\",\"ITMITMNO\":\"N1000-GE-FE1108-U\",\"ITMNAM\":\"N1000 GE FE1108\",\"SYCDESC\":\"Parts\",\"ITMTYPE\":\"P\",\"ITMSTATUS\":\"U\",\"ITMSTPFLG\":\"N\"}]}"