It affects every query so I think this would do it;

connection = MySQLdb.connect(host='myhost', user='developer', passwd='sekrit', 
db='test');
cursor = connection.cursor();
cursor.execute('SELECT filter_id FROM product_filters')
data = cursor.fetchall()
for item in data:
  cursor.execute('SELECT 
f.keywords,f.notwords,f.tagwords,f.maxprice,f.minprice,f.cnet_categories, 
f.keywords_or FROM product_filters f WHERE f.filter_id =\ '+str(item[0])+' 
GROUP BY f.filter_id')
  filterdata = cursor.fetchall()

-- 
UnicodeDecodeError: 'ascii' codec can't decode certain bytes 
https://launchpad.net/bugs/57067

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to