Re: [SQLObject] Selects with a timedelta...

2008-03-03 Thread Sam's Lists
Works great. Thank you!! On Sat, Mar 1, 2008 at 7:15 PM, Christopher Singley <[EMAIL PROTECTED]> wrote: > On Saturday 01 March 2008 13:07:38 Sam's Lists wrote: > > I'd like to do a select using a timedelta. I.e. I'd like one of the > > parameters to be that it was updated in the last week. > >

Re: [SQLObject] Selects with a timedelta...

2008-03-01 Thread Christopher Singley
On Saturday 01 March 2008 13:07:38 Sam's Lists wrote: > I'd like to do a select using a timedelta.  I.e. I'd like one of the > parameters to be that it was updated in the last week. Here's the way I'd do it: cutoff = datetime.datetime.now() - datetime.timedelta(days=7) rrunning = list(RRun.select(

[SQLObject] Selects with a timedelta...

2008-03-01 Thread Sam's Lists
Hi... I'm sure I should know this but I don't. I'd like to do a select using a timedelta. I.e. I'd like one of the parameters to be that it was updated in the last week. Here's what I have so far: timed = timedelta(days=7) rrunning = list(RRun.select(AND(RRun.q.progressID == 1,