[sqlalchemy] Re: Columns division: cast() doen't seem to work. Or how to use it ?

)AS CALCUL FROM Mytable) gives correct results. Thanks Dominique --~--~-~--~~~---~--~~ 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

[sqlalchemy] Re: Columns division: cast() doen't seem to work. Or how to use it ?

Mike, I just had a quick look. See further in a moment. Thank you very much for your time, your work and your help. I really appreciate Dominique --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group

[sqlalchemy] Re: Columns division: cast() doen't seem to work. Or how to use it ?

own type as explained in http://www.sqlalchemy.org/docs/05/types.html#types_custom, but without success. Any help would be much appreciated. I would really like to improve my level in both python and SA ;-). Some day, I'll help newbies ! Many thanks in advance Dominique

[sqlalchemy] Columns division: cast() doen't seem to work. Or how to use it ?

not correctly used or working in certain cases ? Thanks in advance for your answer Dominique #! /usr/bin/env python # -*- coding: utf-8 -*- #from __future__ import division from sqlalchemy import * from sqlalchemy.orm import * from sqlalchemy.sql import * import time metadata = MetaData() engine

[sqlalchemy] Re: Divide columns with possible zeroDivisionError

will be correctly ordered) If this can give you hints to help me... Thanks Dominique --~--~-~--~~~---~--~~ 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

[sqlalchemy] Re: Divide columns with possible zeroDivisionError

For those who may get stuck on this kind of things in the future: This works fine: session.execute(SELECT * ,(CASE WHEN Mytable.ColC = :i THEN :i WHEN Mytable.ColC :i THEN CAST(Mytable.ColB AS FLOAT) / Mytable.ColC END) AS Calcul FROM Mytable ORDER BY Calcul, {'i':0}) Thanks Dominique

[sqlalchemy] Divide columns with possible zeroDivisionError

I want ? Additional question: I ordered Essential SqlAlchemy on the French Amazon, but haven't received it yet (may be still on print ?). Does anybody know if it has been issued already in the US ? Many thanks in advance for helping me Dominique

[sqlalchemy] Re: Cannot abort wxPython thread with SQLAlchemy

that way, then the check event flag approach you're using would be able to work. -Peter That's exactly what I am going to do. Many thanks for your help Dominique --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Cannot abort wxPython thread with SQLAlchemy

, the thread doesn't abort and goes on till it sends the result. Does anybody knows how to tackle this issue ? Should I close the first session under the main App ? Something else ? Many thanks in advance for any hints Dominique --~--~-~--~~~---~--~~ You received

[sqlalchemy] Re: Cannot abort wxPython thread with SQLAlchemy

. Is it possible or am I trying to do something impossible ? Thanks Dominique --~--~-~--~~~---~--~~ 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