ravi
(Raviverma 5688)
October 23, 2012, 1:04pm
1
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…
Thanks,
Is this possibly a SQL join issue? What is the sql query being generated?
Matt
ravi
(Raviverma 5688)
October 25, 2012, 10:51am
3
Hi Matt - How i can see the Generated SQL query? I’m using CDBCriteria in “CActiveDataProvider”. Please suggest
twisted1919
(Serban Cristian)
October 25, 2012, 1:37pm
4
Use ‘joinType’=>‘INNER JOIN’ in with().
alirz23
(Alirz23)
October 26, 2012, 2:19am
5
change the following lines in your config/main.php
// uncomment the following to show log messages on web pages
array(
'class'=>'CWebLogRoute',
),
jeroen84
(Jeroendenhaan)
October 26, 2012, 6:25am
6
That problem is discussed in the following wiki: Displaying, sorting and filtering HasMany & ManyMany relations in CGridView
It also has examples on github.