Re: [web2py] Re: How to replace this native query with DAL

2012-02-09 Thread Bruce Wade
Sorry I just seen this message now, I ended up deleting it by accident and wondering why no-one responded. I will try this today. I didn't know there was a seconds() method attached to the date. Will respond back in a couple of hours when I get to work. -- Thanks, Bruce On Mon, Feb 6, 2012 at

Re: [web2py] Re: How to replace this native query with DAL

2012-02-09 Thread Bruce Wade
To answer your question, happen_time is a column of cash_journal. The point of this call, is we allow people to cancel the site within 72 hours so any money they have made in that time if they cancel they do not get. IE: payback_types = ['s','p'], s = sponsor bonus, p = product bonus We use

[web2py] Re: How to replace this native query with DAL

2012-02-06 Thread Niphlod
hum happen_time is a column of db.cash_journal ? and you want only the records that satisfy the conditions on the query, and in addition, that the difference in seconds between happen_time and now is less than seconds (259200) ? Without a test db I can't confirm, but can you try something