I cant reproduce that exact outcome but to specify the "SET" clause of
an UPDATE, you want to use the "values" keyword:
table.update(table.c.id==1, values={'notes':func.concat(table.c.nodes,
'FOO')})
Also, you dont even need to use "func.concat" here as just saying
"table.c.nodes + 'FOO'" will generate the appropriate concatenation
construct.
On Jan 31, 2008, at 11:45 AM, Jim Musil wrote:
>
> It seems like the following update call is forcing func.concat to be a
> string:
>
> connection.execute(note_table.update(
> table.c.id==1,
> notes =
> func.concat(note_table.c.notes, 'NEW NOTE TO BE ADDED')
> )
> )
>
>
> This generates the following sql:
>
> UPDATE note_table SET notes='CONCAT(note_table.notes, %s)' WHERE
> note_table.id = 1;
>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
