-
How to resolve System in QueryException: unexpected token: ',' message in Salesforce?
after execution a message of System.QueryException: unexpected token: ',' is showing? can anyone tell me the reason ??
-
This discussion was modified 5 years, 10 months ago by
Sumit kumar.
-
This discussion was modified 5 years, 10 months ago by Sumit kumar.
-
This discussion was modified 5 years, 10 months ago by Forcetalks.
-
This discussion was modified 5 years, 10 months ago by Forcetalks.
-
This discussion was modified 5 years, 10 months ago by
-
2 Replies
-
Try this.......... By using BackSlash ''
public class ContactSearch {
public static list<contact> searchForContacts(string lastname ,string mailingCode)
{
String query = 'select id, name from contact where lastname ='' +lastname+ '' and MailingPostalCode = ''+mailingCode+''';
Contact[] myContacts = Database.query(query);
system.debug(myContacts);
return myContacts;}
}
-
Sumit,Please try removing comma (,) and replace it with AND operations as below.
String query = 'SELECT id, name FROM contact WHERE LastName =:lastname AND MailingPostalCode = :mailingCode';-
This reply was modified 5 years, 4 months ago by Charan.
-
This reply was modified 5 years, 4 months ago by
Log In to reply.
Popular Salesforce Blogs
5 Advanced Salesforce Reporting Features
Salesforce.com is one of the topmost CRM platforms in the world. Most of the features have got updates every year and new services are being…
What is Salesforce CMS: A Practical Guide
A hybrid content management system (CMS), Salesforce CMS enables you to generate, modify, arrange, and manage digital material from a single location. Publish content to channels like…
Role-Based Access Control in Salesforce Government Cloud
Salesforce Government Cloud is a robust, secure, and scalable cloud computing solution designed to meet the unique needs of public sector organizations. It provides a…
Popular Salesforce Videos
Salesforce Lightning Process Builder: Lightning Process Builder Basics
The Salesforce Lightning Process Builder is a new workflow tool that helps anyone in your company quickly and easily automate business processes such as employee…
Happy 2021 to the Salesforce Ohana
As 2020 comes to a close, the challenges of the past year give way to hopes of a new year full of love, cheer, &…
AMPscript Math Functions - Salesforce Marketing Cloud Functions in 5 minutes
Cameron Robert steps through how to use the AMPscript Math Functions in Salesforce Marketing Cloud. Key Moments: Introduction to AMPscript Math Functions (0:00) Add, Subtract,…
