Resforce SOQL Query Error Bind variables only allowed in Apex code

Question

I have a controller action that needs to take the Account ID of the logged in user (parent) and make a SOQL query to find all of children associated with the parent. I receive the following error:

Bind variables only allowed in Apex code

After searching around I've learned that I can't use a variable in my SOQL query. However, I am looking for some help as to pull multiple children on a parent using a dynamic parent ID. My query currently looks like this:

@loanparts = client.query("select Loan_Risk__c from Loan_Part__c where Account__c = @account.Account__c")

score 1 · Accepted Answer · answered Sep 29 '14 at 14:05

1

Change your query to pass accountid as string, I don't know which programming language are you using. Please try this.

@loanparts = client.query("select Loan_Risk__c from Loan_Part__c where Account__c ='+AccountId+'")

answered Sep 29 '14 at 14:05

Chandresh Koyani

362
1
6

I'm using ruby. This worked perfectly. I just needed to convert accountid as a string. Thank you! – Questifer Sep 29 '14 at 18:54

Resforce SOQL Query Error Bind variables only allowed in Apex code

1 Answers1