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