另类的冲锋衣 · SSM框架,MyBatis-Plus的学习( ...· 1 周前 · |
卖萌的枇杷 · Send Email with Java ...· 1 周前 · |
力能扛鼎的剪刀 · iCloud备份怎么恢复到新手机?操作原来这 ...· 1 月前 · |
怕老婆的米饭 · ifanr 访谈:友盟,不只是数据服务平台 ...· 5 月前 · |
不拘小节的机器猫 · 凌晨外卖员被邻居嫂子囚禁欺负,三天后他软着腿 ...· 10 月前 · |
高大的小熊猫 · 有狄醉山的文吗? - 知乎· 1 年前 · |
叛逆的沙发 · 国家税务总局青岛市税务局· 1 年前 · |
讲道义的鸡蛋
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