Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression
Post: RE: Pagination with group by return oci_execute():...

kenjis Wrote: (04-12-2024, 06:09 PM) -- Check the SQL statement, then you may know something. https://codeigniter4.github.io/CodeIgniter4/testing/debugging.html#logging-all-sql-queries -- kenjis ...
443 Views
5 Replies
04-13-2024, 08:36 PM
just
    Thread: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression
Post: RE: Pagination with group by return oci_execute():...

Hi Kenjis, thanks for reply. i tried to var dump. and show query looks fine. event good without pagination from models. any specific Hints?
443 Views
5 Replies
04-13-2024, 08:00 PM
just
    Thread: Pagination with group by return oci_execute(): ORA-00979: not a GROUP BY expression
Post: Pagination with group by return oci_execute(): ORA...

        return $this; Code: -- $this->builder()             ->select(‘name, address’)             ->selectSum('TOTAL’)             ->groupBy(‘name’, ‘address')             ->limit($limit,  $offset);...
443 Views
5 Replies
04-12-2024, 01:31 PM
just

Theme © iAndrew 2016 - Forum software by © MyBB