OK that one is fixed in r3467.
On Sep 6, 2007, at 12:02 PM, Koen Bok wrote:
>
> Tried that, but it just places the select statement within the insert
> statement without brackets:
>
> 2007-09-06 18:00:57,603 INFO sqlalchemy.engine.base.Engine.0x..90
> INSERT INTO request (id, metanumberstate) VALUES (%(id)s, SELECT
> coalesce(max(metanumber.id), %(coalesce)s)
> FROM metanumber)
> 2007-09-06 18:00:57,604 INFO sqlalchemy.engine.base.Engine.0x..90
> {'coalesce': 0, 'id': 1L}
> 2007-09-06 18:00:57,609 INFO sqlalchemy.engine.base.Engine.0x..90
> ROLLBACK
>
> If I put the brackets in by hand, it works fine...
>
> On Sep 6, 5:53 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
>> On Sep 6, 2007, at 10:28 AM, Koen Bok wrote:
>>
>>
>>
>>> Aight, that would be cool. So this still has to be implemented then,
>>> right?
>>
>> embedded select works eh ? try making your default that:
>>
>> default=select([func.max(metanumber.id)])
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
