Why do this?

Duncan Booth duncan.booth at invalid.invalid
Fri Oct 6 12:09:14 CEST 2006


Corrado Gioannini <gioco at nekhem.com> wrote:

> I often do things like this:
> 
>   sql = a_complex_select_sql % (id_foo, value_bar, ...)
>   cursor.execute(sql)
> 
> inside the body of a function (or a class method), where
> a_complex_select_sql is a string, containing several %s, %d ecc., 
> that is defined globally (or somewhere else in the class).
> 
I hope you have a good reason why you don't do:

  cursor.execute(a_complex_select_sql, (id_foo, value_bar, ...))

instead.



More information about the Python-list mailing list