in website creating, query coming asp files according user-specified filters on client side of site. query contain escaped double quotes (for sql rules), vb-style escape "". however, when pass query javascript file run through mapping web service, escaped double quotes replaced javascript-style escaped quote, \" .
when ends going through ajax function query oracle db , plot points on google map, errors out because javascript-style escape characters ( \" ) somehow become ( \\" ), won't accepted sql. below sample test , see when debugging.
html hidden input assignment:
querystringinput.value = commandstr + wherestr proper query aspx.vb page (i know syntax good, literal of want show in js file):
"select cf.meterid ""meter id"", repid ""rep id"", division ""division"", opctr ""op center"", city ""city"", address ""address"", cf.premiseid ""premiseid"", daysonprem.premcount ""days bad on premise"", premrecurr.premcount ""premise recurrences"", ratecode ""ratecode"", meterform ""meter form"", meterstatus ""meter status"", meterpointstatus ""meter point status"", billingcycle ""billing cycle"", filename ""filename"", filedatetime ""file date/time"", latitude ""latitude"", longitude ""longitude"", failuretype ""fail type"", currentstatus ""current status"" communication_failures cf join (select meterid, premiseid, count(premiseid) premcount communication_failures group meterid, premiseid) daysonprem on daysonprem.meterid = cf.meterid join (select premiseid, count(premiseid) premcount (select meterid,premiseid, count(premiseid) premcount communication_failures group meterid, premiseid) group premiseid) premrecurr on premrecurr.premiseid = cf.premiseid division = 'western' , filedatetime >= to_date('06012016', 'mmddyyyy')" js command above query html hidden input variable (through testing, found needed in double quotes):
var querystringvalue = "\"" + document.getelementbyid('querystringinput').value + "\""; what shows in js file in place of query:
\"select cf.meterid \"meter id\", repid \"rep id\", division \"division\", opctr \"op center\", city \"city\", address \"address\", cf.premiseid \"premiseid\", daysonprem.premcount \"days bad on premise\", premrecurr.premcount \"premise recurrences\", ratecode \"ratecode\", meterform \"meter form\", meterstatus \"meter status\", meterpointstatus \"meter point status\", billingcycle \"billing cycle\", filename \"filename\", filedatetime \"file date/time\", latitude \"latitude\", longitude \"longitude\", failuretype \"fail type\", currentstatus \"current status\" communication_failures cf join (select meterid, premiseid, count(premiseid) premcount communication_failures group meterid, premiseid) daysonprem on daysonprem.meterid = cf.meterid join (select premiseid, count(premiseid) premcount (select meterid,premiseid, count(premiseid) premcount communication_failures group meterid, premiseid) group premiseid) premrecurr on premrecurr.premiseid = cf.premiseid division = 'western' , filedatetime >= to_date('06012016', 'mmddyyyy')\" subsequent error message (where can see triple-backslashes):
"{\"message\":\"invalid object passed in, \\u0027:\\u0027 or \\u0027}\\u0027 expected. (38): {querystring: \\\"select cf.meterid \\\"meter id\\\", repid \\\"rep id\\\", division \\\"division\\\", opctr \\\"op center\\\", city \\\"city\\\", address \\\"address\\\", cf.premiseid \\\"premiseid\\\", daysonprem.premcount \\\"days bad on premise\\\", premrecurr.premcount \\\"premise recurrences\\\", ratecode \\\"ratecode\\\", meterform \\\"meter form\\\", meterstatus \\\"meter status\\\", meterpointstatus \\\"meter point status\\\", billingcycle \\\"billing cycle\\\", filename \\\"filename\\\", filedatetime \\\"file date/time\\\", latitude \\\"latitude\\\", longitude \\\"longitude\\\", failuretype \\\"fail type\\\", currentstatus \\\"current status\\\" communication_failures cf join (select meterid, premiseid, count(premiseid) premcount communication_failures group meterid, premiseid) daysonprem on daysonprem.meterid = cf.meterid join (select premiseid, count(premiseid) premcount (select meterid,premiseid, count(premiseid) premcount communication_failures group meterid, premiseid) group premiseid) premrecurr on premrecurr.premiseid = cf.premiseid division = \\u0027western\\u0027 , filedatetime \\u003e= to_date(\\u002706012016\\u0027, \\u0027mmddyyyy\\u0027)\\\", connectionstring: \\\"provider=oraoledb.oracle.1;password=luvp1ck3ym0u#s;persist security info=true;user id=amiop;data source=pnhar200\\\"}\",\"stacktrace\":\" @ system.web.script.serialization.javascriptobjectdeserializer.deserializedictionary(int32 depth)\\r\\n @ system.web.script.serialization.javascriptobjectdeserializer.deserializeinternal(int32 depth)\\r\\n @ system.web.script.serialization.javascriptobjectdeserializer.basicdeserialize(string input, int32 depthlimit, javascriptserializer serializer)\\r\\n @ system.web.script.serialization.javascriptserializer.deserialize(javascriptserializer serializer, string input, type type, int32 depthlimit)\\r\\n @ system.web.script.serialization.javascriptserializer.deserialize[t](string input)\\r\\n @ system.web.script.services.resthandler.getrawparamsfrompostrequest(httpcontext context, javascriptserializer serializer)\\r\\n @ system.web.script.services.resthandler.getrawparams(webservicemethoddata methoddata, httpcontext context)\\r\\n @ system.web.script.services.resthandler.executewebservicecall(httpcontext context, webservicemethoddata methoddata)\",\"exceptiontype\":\"system.argumentexception\"}" so, workaround here keep formatting vb file behind, rather have javascript file reformat escape characters?
