Why do this?

[Lawrence D'Oliveiro]

In message <Xns98547173763B6duncanbooth at 127.0.0.1>, Duncan Booth wrote:

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

I use the above when I can, when I can't I fall back on
<http://groups.google.co.nz/groups?selm=efc5b3$can$1@lust.ihug.co.nz>,
<http://groups.google.co.nz/groups?selm=efhn5v$fia$2@lust.ihug.co.nz>.