FYI the comparisons to a DateTime column are better done against a similar datetime() object, rather than a string -
select(table.c.date_col < datetime.datetime(2007, 10, 19, 10, 23, 54)) On Apr 7, 2007, at 11:44 PM, rkennedy wrote: > > Hi Matthew, > > Your assessment was spot on. Apparently the start_time field also > needed an explicit reference to the database table import. The > following query now does the trick... > > events = > self.sess.query(model.Event).select_by(model.Event.c.start_time < > '2007-10-19 10:23:54') > > Thanks again for your help...much appreciated! > > Ryan > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---