i used db_list DB API
select msisdn, sms_message, date(date_inserted) as date_i
from rn1071
order by date_inserted desc
limit 30 offset :ofst
at first look its ok.. but whenever it queries it adds '' on the value of :ofst.. w/c causes an error on postgres
example ofst=0
select msisdn, sms_message, date(date_inserted) as date_i
from rn1071
order by date_inserted desc
limit 30 offset '0'
TIA