Re: [SQLObject] func.NOW + INTERVAL

[Dave P. <dpo...@te...>]

On Fri, 2003-08-01 at 10:40, Ian Bicking wrote:
> On Fri, 2003-08-01 at 08:18, Dave Poirier wrote:
> > I'm trying to create a record in a database with a 'expires' field,
> > which records are deleted whenever expires <= NOW().  I seem to have
> > difficulty grasping how I can generate a query similar to:
> > 
> >  UPDATE records SET expires = NOW() + INTERVAL 30 DAY;
> > 
> > I've tried something like:
> > 
> >  Records.expires = func.NOW('INTERVAL 30 DAY')
> >  Records.expires = func.NOW() + 'INTERVAL 30 DAY'
> >  Records.expires = func.NOW() + '+ INTERVAL 30 DAY'
> >  Records.expires = func.DATE_ADD(func.NOW(),'INTERVAL 30 DAY')
> 
> func.NOW() + const('INTERVAL 30 DAY')

The query being sent to MySQL is:

  UPDATE session SET expires = (NOW() + __call__('INTERVAL 30 MINUTE'))
WHERE id = 2

MySQL complains with: 

  ProgrammingError: (1064, "You have an error in your SQL syntax near
'('INTERVAL 30 MINUTE')) WHERE id = 2' at line 1")


-Dave