Sebastián Esteller asked 10 years ago
When use select command in grid filters not works.
Is possible use select command and filters in showed results in grid.
Thanks
Abu Ghufran answered 10 years ago
Hello,
Sorry for that but I don't understand the question.
Please explain with some example.
tango answered 10 years ago
Hi Abu,
I faced the same problem also. This is what he meant:
Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND title LIKE '%ddf%') pg_tmp' at line 1 – SELECT count(*) as c FROM ( select (select name from option o where o.id = option1_id) name1, g.* from group g AND title LIKE '%ddf%') pg_tmp
The SQL becomes broken when we use select_command and try to do a filter.
Abu Ghufran answered 10 years ago
Hello Tango,
Can you email me grid code file for review (along with db sql) – at [email protected]
I am unable to generate this issue here.
Also tell me which version of lib are you using. (mentioned in lib/inc/jqgrid_dist.php header)
