Giovanni Luca Bonelli asked 7 years ago
Hi Abu,
I have a problem while filtering or search data when I use logical operator (OR) in sql select_command.
If I write:
$g->select_command = "SELECT * FROM odldiceocc WHERE dlrl='DL/RL' OR cse='CSE'";
The table is correctly populated but autofilter or search button show random, wrong value.
If I write:
$g->select_command = "SELECT * FROM odldiceocc WHERE dlrl='DL/RL'";
autofilter or search button show correct value
How do you think about?
Thankyou in advance
2 Answers
Abu Ghufran answered 7 years ago
You can try putting ( ) around condition.
e.g.
$g->select_command = "SELECT * FROM odldiceocc WHERE (dlrl='DL/RL' OR cse='CSE')";
LucaYour Answer
