[sqlalchemy] Building a query with if(type = purchase, value, 0)

2009-04-05 Thread Wouter van Vliet
Hi Folks, After an hour or so of browsing the net and documentations, getting increasingly frustrated and being about to just - nah, I didn't really consider throwing sqlalchemy out of my project. But still. Anyway, I'm trying to make a select-query which would send something like this to

[sqlalchemy] Re: Building a query with if(type = purchase, value, 0)

2009-04-05 Thread Wouter van Vliet
Thanks for your suggestion, but no such luck. From the sql error I get I gathered that that just creates an actual if_ function.. On Apr 5, 9:08 pm, a...@svilendobrev.com wrote: try with func.if_() On Sunday 05 April 2009 21:19:29 Wouter van Vliet wrote: Hi Folks, After an hour

[sqlalchemy] Re: Building a query with if(type = purchase, value, 0)

2009-04-05 Thread Wouter van Vliet
5, 9:03 pm, Wouter van Vliet wou...@interpotential.com wrote: Thanks for your suggestion, but no such luck. From the sql error I get I gathered that that just creates an actual if_ function.. On Apr 5, 9:08 pm, a...@svilendobrev.com wrote: try with func.if_() On Sunday 05 April 2009