Xjyuk

Character descriptions

Why doesn't Adrian Toomes give up Spider-Man's identity?

How to deal with apathetic co-worker?

How can "научись" mean "take it and keep trying"?

Would the US government be able to hold control if all electronics were disabled for an indefinite amount of time?

What language is software running on the ISS written in?

This riddle is not to see but to solve

Arriving at the same result with the opposite hypotheses

Were Alexander the Great and Hephaestion lovers?

Should an arbiter claim draw at a K+R vs K+R endgame?

How did old MS-DOS games utilize various graphic cards?

Logarithm of exponential

How can I get an unreasonable manager to approve time off?

Soft question: Examples where lack of mathematical rigour cause security breaches?

What to do when surprise and a high initiative roll conflict with the narrative?

Overlapping String-Blocks

How to construct an hbox with negative height?

How to signal to my players that the following part is supposed to be played on fast forward?

Does Disney no longer produce hand-drawn cartoon films?

Cycle through MeshStyle directives in ListLinePlot

System.StringException: Unexpected end of expression

Is it possible to 'live off the sea'

Is open-sourcing the code of a webapp not recommended?

Do simulator games use a realistic trajectory to get into orbit?

SOQL Not Recognizing Field?

Class Error Unexpected token GlobalUnexpected Token - ListMaps gives error in Apex ClassUnexpected token error in triggerSOQL Query Error: Compile Error: unexpected token: 'SELECT' at line x column yUnexpected token triggerError compiling classUsing relationship queries with datacategoryHow to query NOT LIKE?Unexpected token error for apparent valid assignment?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

4

I have this apex code:

//testing code for above
List<Contact> contacts = new List<Contact>();
for (MtgPlanner_CRM__Transaction_Property__c lo : [SELECT MtgPlanner_CRM__Borrower_Name__c, MtgPlanner_CRM__Status__c FROM MtgPlanner_CRM__Transaction_Property__c])
 if (lo.MtgPlanner_CRM__Status__c == 'Closed')
 Contact c = [SELECT of_Closed_Loans, id FROM Contact WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c];
 if (!String.isBlank(c.of_Closed_Loans)
 c.of_Closed_Loans= Integer.valueOf(String.valueOf(c.of_Closed_Loans) + 1); 
 else 
 c.of_Closed_Loans= 1;
 
 contacts.add(c);
 
 
update contacts

In workbench's Apex Execute,

COMPILE ERROR: Unexpected token 'lo.MtgPlanner_CRM__Borrower_Name__c'.
LINE: 5 COLUMN: 77

It seems like it is not recognizing this part of the SOQL statement:

WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c]

However,
System.debug(lo.MtgPlanner_CRM__Borrower_Name__c) works fine.

I just want to get the Contacts that have id's equal to the MtgPlanner_CRM__Transaction_Property__c object's MtgPlanner_CRM__Borrower_Name__c field.

apex soql compile-error

share|improve this question

edited 8 hours ago

Adrian Larson♦

113k19126266

asked 8 hours ago

SarahSarah

324

New contributor

Sarah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

4

I have this apex code:

//testing code for above
List<Contact> contacts = new List<Contact>();
for (MtgPlanner_CRM__Transaction_Property__c lo : [SELECT MtgPlanner_CRM__Borrower_Name__c, MtgPlanner_CRM__Status__c FROM MtgPlanner_CRM__Transaction_Property__c])
 if (lo.MtgPlanner_CRM__Status__c == 'Closed')
 Contact c = [SELECT of_Closed_Loans, id FROM Contact WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c];
 if (!String.isBlank(c.of_Closed_Loans)
 c.of_Closed_Loans= Integer.valueOf(String.valueOf(c.of_Closed_Loans) + 1); 
 else 
 c.of_Closed_Loans= 1;
 
 contacts.add(c);
 
 
update contacts

In workbench's Apex Execute,

COMPILE ERROR: Unexpected token 'lo.MtgPlanner_CRM__Borrower_Name__c'.
LINE: 5 COLUMN: 77

It seems like it is not recognizing this part of the SOQL statement:

WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c]

However,
System.debug(lo.MtgPlanner_CRM__Borrower_Name__c) works fine.

I just want to get the Contacts that have id's equal to the MtgPlanner_CRM__Transaction_Property__c object's MtgPlanner_CRM__Borrower_Name__c field.

apex soql compile-error

share|improve this question

edited 8 hours ago

Adrian Larson♦

113k19126266

asked 8 hours ago

SarahSarah

324

New contributor

Sarah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have this apex code:

//testing code for above
List<Contact> contacts = new List<Contact>();
for (MtgPlanner_CRM__Transaction_Property__c lo : [SELECT MtgPlanner_CRM__Borrower_Name__c, MtgPlanner_CRM__Status__c FROM MtgPlanner_CRM__Transaction_Property__c])
 if (lo.MtgPlanner_CRM__Status__c == 'Closed')
 Contact c = [SELECT of_Closed_Loans, id FROM Contact WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c];
 if (!String.isBlank(c.of_Closed_Loans)
 c.of_Closed_Loans= Integer.valueOf(String.valueOf(c.of_Closed_Loans) + 1); 
 else 
 c.of_Closed_Loans= 1;
 
 contacts.add(c);
 
 
update contacts

In workbench's Apex Execute,

COMPILE ERROR: Unexpected token 'lo.MtgPlanner_CRM__Borrower_Name__c'.
LINE: 5 COLUMN: 77

It seems like it is not recognizing this part of the SOQL statement:

WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c]

However,
System.debug(lo.MtgPlanner_CRM__Borrower_Name__c) works fine.

I just want to get the Contacts that have id's equal to the MtgPlanner_CRM__Transaction_Property__c object's MtgPlanner_CRM__Borrower_Name__c field.

apex soql compile-error

share|improve this question

edited 8 hours ago

Adrian Larson♦

113k19126266

asked 8 hours ago

SarahSarah

324

New contributor

Sarah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

//testing code for above
List<Contact> contacts = new List<Contact>();
for (MtgPlanner_CRM__Transaction_Property__c lo : [SELECT MtgPlanner_CRM__Borrower_Name__c, MtgPlanner_CRM__Status__c FROM MtgPlanner_CRM__Transaction_Property__c])
 if (lo.MtgPlanner_CRM__Status__c == 'Closed')
 Contact c = [SELECT of_Closed_Loans, id FROM Contact WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c];
 if (!String.isBlank(c.of_Closed_Loans)
 c.of_Closed_Loans= Integer.valueOf(String.valueOf(c.of_Closed_Loans) + 1); 
 else 
 c.of_Closed_Loans= 1;
 
 contacts.add(c);
 
 
update contacts

WHERE id = lo.MtgPlanner_CRM__Borrower_Name__c]

share|improve this question

edited 8 hours ago

Adrian Larson♦

113k19126266

asked 8 hours ago

SarahSarah

324

New contributor

Sarah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 8 hours ago

Adrian Larson♦

113k19126266

asked 8 hours ago

SarahSarah

324

New contributor

Sarah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 8 hours ago

Adrian Larson♦

113k19126266

edited 8 hours ago

Adrian Larson♦

113k19126266

asked 8 hours ago

SarahSarah

324

New contributor

Sarah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 hours ago

SarahSarah

324

1 Answer
1

active

oldest

votes

8

You need to add a preceding colon when using bind variables:

Correct

WHERE Field__c = :value

Incorrect

WHERE Field__c = value

See also: Using Apex Variables in SOQL and SOSL Queries (emphasis mine):

SOQL and SOSL statements in Apex can reference Apex code variables and expressions if they’re preceded by a colon (:). This use of a local code variable within a SOQL or SOSL statement is called a bind. The Apex parser first evaluates the local variable in code context before executing the SOQL or SOSL statement.

share|improve this answer

edited 8 hours ago

answered 8 hours ago

Adrian Larson♦Adrian Larson

113k19126266

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

Sarah is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f264723%2fsoql-not-recognizing-field%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

8

You need to add a preceding colon when using bind variables:

Correct

WHERE Field__c = :value

Incorrect

WHERE Field__c = value

See also: Using Apex Variables in SOQL and SOSL Queries (emphasis mine):

SOQL and SOSL statements in Apex can reference Apex code variables and expressions if they’re preceded by a colon (:). This use of a local code variable within a SOQL or SOSL statement is called a bind. The Apex parser first evaluates the local variable in code context before executing the SOQL or SOSL statement.

share|improve this answer

edited 8 hours ago

answered 8 hours ago

Adrian Larson♦Adrian Larson

113k19126266

add a comment | 

8

You need to add a preceding colon when using bind variables:

Correct

WHERE Field__c = :value

Incorrect

WHERE Field__c = value

See also: Using Apex Variables in SOQL and SOSL Queries (emphasis mine):

SOQL and SOSL statements in Apex can reference Apex code variables and expressions if they’re preceded by a colon (:). This use of a local code variable within a SOQL or SOSL statement is called a bind. The Apex parser first evaluates the local variable in code context before executing the SOQL or SOSL statement.

share|improve this answer

edited 8 hours ago

answered 8 hours ago

Adrian Larson♦Adrian Larson

113k19126266

add a comment | 

You need to add a preceding colon when using bind variables:

Correct

WHERE Field__c = :value

Incorrect

WHERE Field__c = value

See also: Using Apex Variables in SOQL and SOSL Queries (emphasis mine):

SOQL and SOSL statements in Apex can reference Apex code variables and expressions if they’re preceded by a colon (:). This use of a local code variable within a SOQL or SOSL statement is called a bind. The Apex parser first evaluates the local variable in code context before executing the SOQL or SOSL statement.

share|improve this answer

edited 8 hours ago

answered 8 hours ago

Adrian Larson♦Adrian Larson

113k19126266

WHERE Field__c = :value

WHERE Field__c = value

share|improve this answer

edited 8 hours ago

answered 8 hours ago

Adrian Larson♦Adrian Larson

113k19126266

answered 8 hours ago

Adrian Larson♦Adrian Larson

113k19126266

answered 8 hours ago

Adrian Larson♦Adrian Larson

113k19126266