[sqlalchemy] Re: simple DateTime select

2007-04-07 Thread rkennedy
Thanks, Matthew. Looks like SA is still complaining about the global name not being defined. event = self.sess.query(model.Event).get_by(event_table.c.start_time '2007-10-19 10:23:54') The above code produces a similar error... NameError: global name 'event_table' is not defined When I try

[sqlalchemy] Re: simple DateTime select

2007-04-07 Thread rkennedy
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