|
|
相关文章推荐
|
无邪的弓箭 · <input type="email"> ...· 1 月前 · |
|
|
活泼的铁链 · Bank of China Europe ...· 1 月前 · |
|
|
兴奋的草稿本 · ASP.NET Core ...· 2 周前 · |
|
|
安静的橙子 · 無法開啟具有連線錯誤的資料庫 - ...· 5 月前 · |
|
|
安静的热水瓶 · 将列表末尾的最后两项合并，没有逗号(Pyth ...· 1 年前 · |
|
|
魁梧的小蝌蚪 · java202304java学习笔记第六十三 ...· 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