AFter filter, editing/details not working in datagrid 4.2.8

[urtrivedi]

after search keyword, all rows comes with rid=-1, so if you click on edit, it gives blank form.

HOw to overcome this issue, (My version is 4.2.8)
I have already written sql with out *, that is I have written all column names.

I am getting following error

Errors:

1) SELECT * FROM rates WHERE SELECT IN ('-1' , '1' )
[nativecode=1064 ** 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 'SELECT IN ('-1' , '1' )' at line 1]


Kindly help

[yudthaphon]

Hello all
I also encounter the same problem.
I filtered and found my record. When I clicked detail,
the datagrid show blank edit mode with a notice (shown below).
I use PHP DataGrid Pro (AJAX enabled) version 6.4.1

Thank you.
YV.

the error reports:
Notice: Undefined offset: -1 in C:\AppServ\www\mtms\datagrid\datagrid.class.php on line 3805

error:

1) SELECT user.* FROM user WHERE IN ('-1' , '1' ) ORDER BY DESC LIMIT 0, 25
[nativecode=1064 ** 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 'IN ('-1' , '1' ) ORDER BY DESC LIMIT 0, 25' at line 1]

[lambro]

Hi ! Check this : http://www.apphp.net/forum/viewtopic.php?f=11&t=2359. You might find it useful. @+

[yudthaphon]

Dear Lambro
Thank you very much. Your answer helps!
It solved the issue.
YV.