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