On Mon, May 3, 2010 at 11:05 AM, Michael Bayer <mike...@zzzcomputing.com> wrote:
> you use values() for this:
>
> table.insert().values(col1=foo, col2=3, col3=func.custom_function('cheese'))
>
> if you want bind params:
>
> i = table.insert().values(col3=func.custom_function('mybind'))
> conn.execute(i, {'col1':'foo', 'col2':3, 'mybind':'cheese'})
>
> note that the name "col3" as a bind param is reserved for the internal use by
> the insert() construct.
>
>
Sweet! That works perfectly. Thanks!
Perhaps this could get added to the docs somehow?
(Like, in the insert() section?)
--
Jon
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
