link之家
链接快照平台
- 输入网页链接，自动生成快照
- 标签化管理网页链接
相关文章推荐
|
求醉的莴苣 · 数字孪生产品升级——游戏引擎！（万字解读） ...· 1 年前 · |
|
|
没有腹肌的豆腐 · 广州杀医案后：全省排查伤医倾向人群-新华网· 1 年前 · |
|
|
不要命的自行车 · 我们的日子（2023年李小冉、李乃文主演的电 ...· 2 年前 · |
|
|
会搭讪的石榴 · 【宾利飞驰】宾利飞驰口碑_宾利飞驰怎么样_宾 ...· 2 年前 · |
|
|
不羁的投影仪 · 微软的终极核弹来了！Windows ...· 2 年前 · |
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