Hi; But what about this? sql = "select pic%d from %s where ID='%%s';" % (pic, store) cursor.execute(sql % id)
If I try and rewrite the last line like this: cursor.execute(sql, id) it doesn't work. What do? How about this one: cursor.execute("insert into categories (Store, Category, Parent) values('%s', '%s', Null)", (store, cat)) For some reason it puts single quotes around my variables! This doesn't happen if I change that comma for a percent sign! What do? How about this one: sql = 'select * from options%s where ID=%%s', (opTable[0].upper() + opTable[1:]) # cursor.execute(sql, id) cursor.execute('select * from options%s where ID=%s' % (opTable[0].upper() + opTable[1:], id)) The last one works, but if I comment it out and uncomment the middle line, it doesn't. Same here: sql = "update options%s set PriceDiff='%%s' where Field='%%s' and ID=%%s and Store='%%s'" % (opTable[0].upper() + opTable[1:]) # cursor.execute(sql, (value, opName, id, store)) cursor.execute('update options%s set PriceDiff="%s" where Field="%s" and ID=%s and Store="%s"' % (opTable[0].upper() + opTable[1:], value, opName, id, store)) Please help. TIA, beno TIA, beno
-- http://mail.python.org/mailman/listinfo/python-list