• Idrees
  • NEWBIE
  • 0 Points
  • Member since 2008

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 3
    Replies
Hi,
 
I have compnay name with apostrophy (') sign.
 
I want to find similar name inside find query but company name with this sign muformed query.
 
How I can escape this sign while writing query and still find exact matching name with ' sign.
 
Code:
var sstr =  "find {" + who + "*} in NAME FIELDS RETURNING "+table+"("+ fields+ ")"

where who have aposhrophy sign.
 
-thanks in advance 
Hi I have required to filter ACCOUNT records based on filter containing its name field with a value that also contains a ' (single quote). But when i execute this query as:
 
select id,name from account
where name = 'Claire's Ltd'
 
i found an error message as :
 
Query failed: MALFORMED_QUERY :
where name = 'Claire's Ltd'
 
Error at Row 2: Columns 22:
unexpected token: s
 
can any body help.
Thanks.
 
Muhammad Idrees,
Software Developer - Beyond Vision (Pvt.) Ltd.
 
 
 
 
Hi,
 
i am facing scenerio where i have to access page attributes from controller extension,
as

get and set 'showHeader' and 'sidebar' attribute of apex:page from Controller extension, means at runtime based on query string value.

Is it possible?

 

Any help would be highly appreciated,

Thanks in advance.