[DB-SIG] Mysqldb python variable in request
samira M'Bata
bouataa at hotmail.com
Thu Jan 22 04:38:20 EST 2004
Hi!
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?
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
More information about the DB-SIG
mailing list