Hi Guys - I’m having an issue, I have analyzed it and seems like if we use “relationship” with “together”=true in CDBCriteria than the paging results are not correct. How to correct those as I can’t use lazy loading.
Please suggest something guys…
Is this possibly a SQL join issue? What is the sql query being generated?
Hi Matt - How i can see the Generated SQL query? I’m using CDBCriteria in “CActiveDataProvider”. Please suggest
Use ‘joinType’=>‘INNER JOIN’ in with().
change the following lines in your config/main.php
// uncomment the following to show log messages on web pages
That problem is discussed in the following wiki: Displaying, sorting and filtering HasMany & ManyMany relations in CGridView
It also has examples on github.