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, ...))


More information about the Python-list mailing list