[Deprecated] DMZ 1.6.2 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
It must because that's the expected result. If you do this:

Code:

// set up query
$count = $object->count();

// Later...
$object->where('fun', TRUE)->get();

You will get unexpected results on the second query, because it contains everything in the first query. DMZ clears the query data whenever a query is run on the database.

If you want both the full query count, and want a subset for pagination, you can either put your query building into a method and run through it twice, or you can do this:

Code:

$count = $object->get_clone();
// force $db to be by-value
$count->db = unserialize(serialize($count->db));
$total = $count->count();

The hack trick in the middle is to ensure that $db doesn't get cleared by the count(). This is actually a bug, I just discovered, because in DMZ 1.6, get_clone() should be doing this automatically. In the next version of DMZ, you will be able to skip that step (as it will be automatic).

Also note that if you have already added items to the select or order_by statements, your count query may return unexpected results.