-
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, 3 months ago by
Sumit kumar.
-
This discussion was modified 6 years, 3 months ago by Sumit kumar.
-
This discussion was modified 6 years, 3 months ago by Forcetalks.
-
This discussion was modified 6 years, 3 months ago by Forcetalks.
-
This discussion was modified 6 years, 3 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 5 years, 9 months ago by Charan.
-
This reply was modified 5 years, 9 months ago by
Log In to reply.
