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
AFter filter, editing/details not working in datagrid 4.2.8
Moderator: alexandrleonenko
-
- Junior
- Posts: 24
- Joined: Nov 2nd, '09, 14:29
Re: AFter filter, editing/details not working in datagrid 4.2.8
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]
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]
Re: AFter filter, editing/details not working in datagrid 4.2.8
Hi ! Check this : http://www.apphp.net/forum/viewtopic.php?f=11&t=2359. You might find it useful. @+
-
- Junior
- Posts: 24
- Joined: Nov 2nd, '09, 14:29
[SOLVED] Re: AFter filter, editing/details not working
Dear Lambro
Thank you very much. Your answer helps!
It solved the issue.
YV.
Thank you very much. Your answer helps!
It solved the issue.
YV.