ram asked 11 years ago
Hello,
i have downloaded free version of pgpgrid. The problem that i have is when i type custom SQL select command
example: "select * from table where somefield='something'; it works
But when i add date condition in where clause . eg: select * from table where somefield='something' and date between 'something' and 'something'.. it not working ….
Where is the problem?
Regards,
Ram
Abu Ghufran answered 11 years ago
ajay c answered 10 years ago
Abu,this is a great product, but documentation can definitely get better. I got stuck at the same problem as above, & struggled for many hours, but could not resolve it. Finally, I have programmed what I needed without using the grid. However, if you care to advise on the solution, it may be helpful. thanks !
ajay c answered 10 years ago
further to the note above, i tried out using the phpgrid lite instead of phpgrid control with the same piece of code & the same select statement, & I found that the select statement works properly with the date in the where condition. so possibly there is some peculiarity that I am missing in being able to achieve the same grid via your application.
Abu Ghufran answered 10 years ago
Ajay, thanks for the feedback. Better documentation is a desperate requirement.
If you can share your code at pastebin.com, and send me link for review.
There could be multiple reasons for it. One can also refer demo example-all.php when using WHERE clause in sql.
