Welcome Guest, Not a member yet? Register   Sign In
Pagination with Join queries
#4

(09-26-2023, 10:50 PM)udaopi Wrote:
(09-26-2023, 07:54 PM)kenjis Wrote: Check the SQL statement that was executed from Debug Toolbar.

I checked it, that key is not in the result

in database and vars tab,

this is screenshoot of executed queries

[Image: ss1.png]
Not all of the queries worked
AAAAAAAAAAAAAAKHH...!!!

I finally discovered the problem by accident ....!!

it turns out that each execution will delete the builder function in the variable.

in the code seen I do countAll() before doing findAll().
it turns out countAll() reset all the contents of $query except the model.

It seems that we can no longer use the same variable for a second execution without refilling the builder function

....
after 4 days, My stress immediately disappeared. hahahaha

thank you all... Smile
Reply


Messages In This Thread
Pagination with Join queries - by udaopi - 09-26-2023, 01:32 AM
RE: Pagination with Join queries - by kenjis - 09-26-2023, 07:54 PM
RE: Pagination with Join queries - by udaopi - 09-26-2023, 10:50 PM
RE: Pagination with Join queries - by udaopi - 09-27-2023, 01:08 AM



Theme © iAndrew 2016 - Forum software by © MyBB