You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The generated SQL Code works fine in phpmyadmin. I get the expected result (around 200 entries).
SELECT DISTINCT FROM ef_events WHERE ((ef_events.EF_STAMMDATEN_ID=? AND ef_events.GELOESCHT<>?) AND ef_events.IMPORTIERT<>?) ORDER BY ef_events.GESPERRT DESC,ef_events.EINGESTELLT_AM DESC
I also get the correct result with my usual doSelect statement:
$results = EfEventsPeer::doSelect($c);
However, if I try to get the same results using the PropelPager, I always get a totalRecordCount of 1 and 1 page.
A question for the Propel veterans here, since it's a very old version:
I have an issue with the Propel Pager and a having clause. The Criteria is:
The generated SQL Code works fine in phpmyadmin. I get the expected result (around 200 entries).
$results = EfEventsPeer::doSelect($c);
However, if I try to get the same results using the PropelPager, I always get a totalRecordCount of 1 and 1 page.
Strangely, I do get the number of hitsPerPage (in this case 10) in my result if available. When I loop through
Im sure the issue must be a wrong addHaving criterion, but I can't solve it myself.
Any ideas? Thx a lot!
The text was updated successfully, but these errors were encountered: