Tuesday 31 July 2012

Handle single quotes within query in javascript

We are facing the problem with single quote characters in string query with filters.When single quotes are inluded in strings (either in filter conditions or searchstring) used in query we handle with replace function as shown below.
Eg: 


var projname=document.getElementById('pg:myForm:pb:newrecord:'+Rowindex+':pInput').value;
Here 'projname' is string with single quotes.
now  we want to use this in query as shown below

sforce.connection.sessionId = '{!$Api.Session_ID}';
 var result = sforce.connection.query("Select Id,Name From Milestone1_Project__c where name ="+"'"+projname.replace("\'","\\'")+"'");
 var records = result.getArray("records");

To retrieve values
if(records.length!=0){
            for(var i=0;i<records.length;i++){
                          alert(records[i].name); 
            }
}

No comments:

Post a Comment

How to include a screen flow in a Lightning Web Component

 Hi, Assume  you have a flow called "Quick Contact Creation" and API Name for the same is "Quick_Contact_Creation". To i...