|
|
相关文章推荐
|
无邪的弓箭 · <input type="email"> ...· 1 月前 · |
|
|
活泼的铁链 · Bank of China Europe ...· 1 月前 · |
|
|
兴奋的草稿本 · ASP.NET Core ...· 2 周前 · |
|
|
发财的李子 · Java线程池中三种方式创建 ...· 6 月前 · |
|
|
暗恋学妹的移动电源 · C# OUTLOOK - CSDN文库· 10 月前 · |
|
|
急躁的饭卡 · vba code to export ...· 1 年前 · |
|
|
爱旅游的肉夹馍 · R语言初级教程(12): ...· 1 年前 · |
The error is in your query string...If in ytour searchChm method control will not go inside any if condition then your final query string will be
Querystring>>>>SELECT id,firstname,lastname,email from Contact Where
Above string has no meaning because there is nothing after where ..
you can simply check in the end if there is nothing after where then remove where also to resolve the error..
Please check and let me know if this helps you
P.S. If my answer helps you to solve your problem please mark it as best answer. It will help other to find best answer.
Thanks,
Sandeep
Salesforce Certified Developer
You can simply replace your method with this method
public PageReference searchm(){ String querystring='SELECT id,firstname,lastname,email from Contact'; if(contList.firstname!=null && contList.lastname==null && contList.Email==null){ querystring += ' where firstname =\''+cont.firstname+'\''; }else if(contList.firstname!=null && contList.lastname!=null && contList.Email==null){ querystring += ' where firstname =\''+contList.firstname+'\'' +'and'+' '+'lastname =\''+contList.lastname+'\''; }else if(contList.firstname!=null && contList.lastname!=null && contList.Email!=null){ querystring += ' where firstname =\''+contList.firstname+'\'' +'and'+' '+'lastname =\''+contList.lastname+'\'' +'and'+' '+'Email =\''+contList.Email+'\''; }else if(contList.firstname==null && contList.lastname!=null && contList.Email!=null){ querystring += ' where lastname =\''+contList.lastname+'\'' +'and'+' '+'Email =\''+contList.Email+'\''; }else if(contList.firstname==null && contList.lastname==null && contList.Email!=null){ querystring += ' where Email =\''+contList.Email+'\''; }else if(contList.firstname!=null && contList.lastname==null && contList.Email!=null){ querystring += ' where firstname =\''+contList.firstname+'\'' +'and'+' '+'Email =\''+contList.Email+'\''; System.debug('Querystring>>>>'+ querystring); listContact=Database.query(querystring); System.debug('Querystring>>>>'+ querystring); return null;
I have removed where clause from main string and added where inside the loop..
Now as you have used else if ..so it will always go inside one if condition so no need to check and remove where..
You can simply replace your method wiuth above code, it will work
P.S. If my answer helps you to solve your problem please mark it as best answer. It will help other to find best answer.
Thanks,
Sandeep
Salesforce Certified Developer
You just need to add a space after 'where' at the line 22. Otherewise, the soql would be like 'select .... from contact wherefirstname....'.
String querystring='SELECT id,firstname,lastname,email from Contact Where ';
David
I agree with David, if control will go in any if condition then due to space it can give the same eror, but if it will not go then du eto space it can cause the same issue..
So the best solution is put where inside the conditions and provide the space..if you notice I haev provided the space before where clause to avoid spacing issue..
Please repalce your code and let us know if that helps you..
P.S. If my answer helps you to solve your problem please mark it as best answer. It will help other to find best answer.
Thanks,
Sandeep
Salesforce Certified Developer