[sqlalchemy] Re: SQL newbie question: How to select the last message for each user

2007-05-16 Thread Noam Raphael
On 16/05/07, Glauco <[EMAIL PROTECTED]> wrote: > > are you searhing for ? > > select max( changeTime ) from OrderDiscount group by orderID ; ? > > i don't understand well what you are searching for > Thanks to all of you! I actually needed the last message itself - more than just its date. Tha

[sqlalchemy] Re: "set character set" in sqlalchemy?

2007-05-15 Thread Noam Raphael
On 15/05/07, Arnar Birgisson <[EMAIL PROTECTED]> wrote: > Hi there, > > You can include a command in the dburi that is executed upon > connection start. I use it all the time like this: > > mysql://user:[EMAIL > PROTECTED]:3306/dbname?init_command=set%20character%20set%20utf8 > Thanks for your he