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...