• 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 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.
 
 
 
 
  • October 20, 2008
  • Like
  • 0
Hi
 
I have required to develop a salesforce custom page for account details insert, edit and view.
All things work successfully except "Parent Account"(Field Display Name) or "Parent" (Field Name),
It gives a compile time error as:
 
 
Error: ; nested exception is: common.exception.ApiQueryException: numberoflocations__c, ownership, parent, phone, prev_created_by__c ^ ERROR at Row:1:Column:237 No such column 'parent' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
 
Any feedback please.
Thanks for your time.
 
Muhammad Idrees,
Beyond Vision - software Developer
 
 
 
 
 
  • October 14, 2008
  • Like
  • 1
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.

 

 

 

 
  • October 13, 2008
  • Like
  • 0
Hi
 
I have required to develop a salesforce custom page for account details insert, edit and view.
All things work successfully except "Parent Account"(Field Display Name) or "Parent" (Field Name),
It gives a compile time error as:
 
 
Error: ; nested exception is: common.exception.ApiQueryException: numberoflocations__c, ownership, parent, phone, prev_created_by__c ^ ERROR at Row:1:Column:237 No such column 'parent' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
 
Any feedback please.
Thanks for your time.
 
Muhammad Idrees,
Beyond Vision - software Developer
 
 
 
 
 
  • October 14, 2008
  • Like
  • 1
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.
 
 
 
 
  • October 20, 2008
  • Like
  • 0
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.

 

 

 

 
  • October 13, 2008
  • Like
  • 0