yeah its a bug, its all fixed (several issues with text columns) in
2368.
On Feb 28, 2007, at 4:46 PM, Dennis wrote:
>
> On Feb 28, 12:30 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
>> you have to show me what youre doing since from my understanding,
>> youre using literal text, and nothing should get added to that.
>
> Here is a quicky Test:
>
> from sqlalchemy import *
>
> e=create_engine('sqlite://memory')
> ts=Table('ts',e,
> Column ( 'id',Integer,primary_key=True),
> Column ( 'dat',Integer,nullable=False))
> ts.create()
>
> sel=select( [ "case when id > 5 then 'ok' else 'tolow' end as
> test" ] , from_obj=[ts], use_labels=True )
> print str(sel)
>
> ___
>
> And here is the output I get:
>
> SELECT case when id > 5 then 'ok' else 'tolow' end as test AS
> casewhenid5thenokelsetolowendastest
> FROM t
>
> Am I doing something wrong with the literal text block? Is there
> another way to specify one besides simply passing in a string.
>
> Thanks
> Dennis
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
