Great, thanks. That works.
Jim
On Jan 31, 10:53 am, Michael Bayer <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
