[DB-SIG] Mysqldb python variable in request
Marcos Sánchez Provencio
msanchez at grupoburke.com
Thu Jan 22 04:55:07 EST 2004
I am not an expert in mysql, but i believe column names can not be a
parameter. You should create the sql with the column names, and leave
only the value as a parameter.
cursor.execute(' select ' +target+ ' from Xml2Mysql where '
+constraint+ '=%s ',(constraint_value,))
samira M'Bata wrote:
> i hope someone could help me.
> I d like to make an sql statement with python, in which the column
> names will be parameter of a python function.
> Bevore I tried to define my definition, i tried this code:
> target= 'DataType'
> constraint= 'Location'
> #DataType and Location are two columns of my Table
> constraint_value= 'stuttgart'
> cursor.execute(""" select %s from Xml2Mysql where %s=%s """,(target,
> constraint, constraint_value))
> I think the problem comes from the fact that my columns names are not
> as a string type defined.
> Should I change something in my table definition?
More information about the DB-SIG