Aug-28-2020, 02:49 PM
I am having trouble getting a database UPDATE query to run using variables. I get an error message of "1054 (42S22): Unknown column 'channel_bandwidth' in 'field list'". Update code is
thx
simdo01
cursor.execute("UPDATE tower_aps SET channel_bandwidth = '%s', \ color_code = '%s', tx_freq = '%s', cust_count = '%s' \ WHERE name = '%s'"% (chan,color,freq,sms,ap_name) )Everything I am reading says it's a quoting problem but I have tried many different variations.
thx
simdo01