There is no API. You may be able to do
from gluon.sql import Expression
db(query).update(field=Expression('table.field % 100','integer',db))this will break with the new DAL. On Apr 29, 7:47 am, elffikk <[email protected]> wrote: > hi, > how to use sql functions in dal expressions ? > > particularly I am interested in mod operator (%) for using on updates > > need somethings like that > db.table.update( (db.table.field+n) % db.table.count() )
