DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Atas[/eluser]
Hello!

I'm trying to use IF STATMENTS with DMZ...

Code:

$oObject->select("publicacion.*, IF(moneda_id > 1, pub_precio * 1, pub_precio / 3.9) as result");

$oObject->having('result >=', $iMinRange);
$oObject->having('result <=', $iMaxRange);

This works fine if i use $oObject->get() to retrieve the data but if i use $oObject->get_paged($iPage, 10) i receive this error:

Code:

A Database Error Occurred

Error Number: 1054

Unknown column 'result' in 'having clause'

SELECT COUNT(*) AS `numrows` FROM (`publicacion`)
   WHERE `publicacion`.`pub_confirmada` = 1 AND `publicacion`.`pub_tipo` = 'xxx'
HAVING `result` >= 1 AND `result` <= 500

I suppose the count query doesn't add the if statment...

am i doing something wrong ?

Sorry for my english :red:

Thanks !