stick "correlate=False" in the max_date select() statement, it needs
a hint to not do that. you might want to also just say max_date =
max_date.alias('maxtab') which also should prevent it from correlating.
On Jun 8, 2006, at 2:34 PM, facundo chamut wrote:
> max_date=select([func.max(tab.c.date)])
>
> >>> SELECT max(tab.date) FROM tab
>
> s=tab.select(tab.c.fecha==(max_fecha))
>
> >>>SELECT a_lot_of_stuff FROM tab WHERE tab.date = (SELECT max
> (tab.date ))
>
>
> note the lack of a FROM part in the last statement.
>
> what am I missing?
> Thanks,
>
> -Facundo.
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
