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

2007-05-16 Thread Noam Raphael
? Thanks again, Noam --~--~-~--~~~---~--~~ 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

[sqlalchemy] Re: set character set in sqlalchemy?

2007-05-15 Thread Noam Raphael
Michael's methods, but they didn't have any effect - question marks remained question marks and wrongly-encoded strings remained wrongly-encoded strings. Do you have any further ideas? Thanks (to you and to Michael), Noam --~--~-~--~~~---~--~~ You received

[sqlalchemy] Re: set character set in sqlalchemy?

2007-05-15 Thread Noam
I found something that works! Add ?charset=utf8 at the end of the url. Thanks again, Noam --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy

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

2007-05-15 Thread Noam
, according to the date (actually I'm only interested in the date). I know I can first select all users and then issue a select for each user to get the last message. But is it possible to do it with only one select, to save DB queries? Thanks, Noam