SQL Query via python

Jeff Elkins jeffelkins at earthlink.net
Sat May 21 15:00:06 EDT 2005


On Saturday 21 May 2005 01:32 pm, Dennis Lee Bieber wrote:
> On Fri, 20 May 2005 23:57:01 -0400, Jeff Elkins

>  You have to remember that .execute(), using the (template,
> (arg...)) format, is designed to apply suitable quoting to the
> arguments. It does not parse the SQL to determine if arguments are being
> used as identifiers and not data values.
>
>  The above sample probably generated:
>
> SELECT name, month, day, category, city from bday
> WHERE "month" = 5

This is getting much clearer. Thanks much.

Jeff



More information about the Python-list mailing list