DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Atas[/eluser]
[quote author="Lucas Alves" date="1283543391"]You have to set the "escape" to FALSE...

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

I think this will solve you problem[/quote]

Hi, i changed the "escape" value to FALSE but didn't work... if i use $oObject->get() to retrieve the data works fine, but if i use get_paged() doesn't work... 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

The count query doesn't add the if statment...

hut: