-
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 6 years, 8 months ago by
Sumit kumar.
-
This discussion was modified 6 years, 8 months ago by Sumit kumar.
-
This discussion was modified 6 years, 8 months ago by Forcetalks.
-
This discussion was modified 6 years, 8 months ago by Forcetalks.
-
This discussion was modified 6 years, 8 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;}
}
- [adinserter block='9']
-
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 6 years, 2 months ago by Charan.
-
This reply was modified 6 years, 2 months ago by
Log In to reply.
Popular Salesforce Blogs
Salesforce Customer 360: A Comprehensive Overview & Advantages
Salesforce recently introduced Customer 360, a groundbreaking technology that provides companies with a unified, comprehensive view of their customers across all touchpoints in the rapidly…
Salesforce: How to detect "Impersonation" through code?
Hello Guys, I got a business requirement to implement for one of my client, they wanted me to prevent their application's access for impersonated user.…
Check Salesforce Org's Email Limits in Apex Programming
Since Salesforce works in a multi-tenant architecture, it is important to check org limits before executing any transaction. Specifically, Salesforce email limits in Apex become…
Popular Salesforce Videos
Accenture + Salesforce: Making an Impact
Our people and communities are important connection points for support. Hear more from our Salesforce professionals. Check out this video to learn everything you need…
How Salesforce Industries can Help Organizations to Save Millions?
Salesforce Industries i.e Vlocity empowers businesses with powerful platforms to boost collaboration and makes it easy to deliver great customer experiences. It provides tailored solutions…
How can Salesforce Field Service Help in Providing a Better Customer Experience?
Salesforce Field Service Management automates and optimizes the work of field service workers (agents, dispatchers, mobile technicians). It is part of the Service Cloud and…