On 7/16/2010 7:39 AM, MRAB wrote:
Victor Subervi wrote:
Hi;
I have the following code:
cursor.execute('select MyTable from optionsDetails where Store=%s',
(store,))
options_tables = [item[0] for item in cursor]
for table in options_tables:
cursor.execute('select * from %' % table)
As has been explained to you repeatedly, you're doing it wrong.
You don't use a relational database to get a field which leads to
another table. Put the options in one table keyed by Store.
Go buy a copy of "Databases for Dummies":
http://www.amazon.com/Intranet-Databases-Dummies-Paul-Litwin/dp/0764502212
John Nagle
--
http://mail.python.org/mailman/listinfo/python-list