Bertrand Croq wrote:

>hi,
>
>I am currently using sqlalchemy to build SQL queries and it's a fantastic 
>tool! By now, I am looking for a way to build:
>
> SELECT 'a_fixed_string', atable.col1, atable.col2
> FROM atable
>
>using the syntax:
>
> select([XXX, atable.c.col1, atable.c.col2])
>
>but I don't know what to put at XXX.
>
>Does anyone have a clue 
>  
>
try this:

select([literal('a_fixed_string'), atable.c.col1, atable.c.col2])

jo


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to