Re: [Pypgsql-users] Parameters etc.

[Aaron H. <aaron@MetroNY.com>]

you can

"Insert into "tablenm" (column1, column2) Values (%(value1)s, 
%(value2)s)" % {'value1':'data1','value2':'data2')

%(varname)s looks up varname in a dict that you can pass

Or you can
value1 = 'data1'
value2 = 'data2'

"Insert into "tablenm" (column1, column2) Values (%(value1)s, 
%(value2)s)" % locals()


If you pass the dict in the execute method then the driver will format 
the strings properly

-Aaron

Dick Kniep wrote:
> Hi List,
> 
> Is it possible to write a simple "Insert into "tablenm" (column1,
> column2) Values (value1, value2)" instead of 
> "Insert into "tablenm" (column1, column2) Values (%s, %s)" and give the
> values as a tuple?
> 
> Kind regard
> D Kniep
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Pypgsql-users mailing list
> Pyp...@li...
> https://lists.sourceforge.net/lists/listinfo/pypgsql-users