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?
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;
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
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
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
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.
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
apex soql compile-error
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
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
edited 8 hours ago
Adrian Larson♦
113k19126266
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
asked 8 hours ago
SarahSarah
324
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.
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 |
add a comment |
1 Answer
1
active
oldest
votes
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.
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.
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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.
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.
answered 8 hours ago
Adrian Larson♦Adrian Larson
113k19126266
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.
answered 8 hours ago
Adrian Larson♦Adrian Larson
113k19126266
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
113k19126266
add a comment |
add a comment |
Sarah is a new contributor. Be nice, and check out our Code of Conduct.
Sarah is a new contributor. Be nice, and check out our Code of Conduct.
Sarah is a new contributor. Be nice, and check out our Code of Conduct.
Sarah is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
