STRSQL = "UPDATE BRACKET16_"&tid&" SET NAME2 = "&TNM12&" WHERE POS = 17" conn.execute(strSQL)
Pretty straight forward right?? However, when it is executed I get"
[MySQL][ODBC 3.51 Driver][mysqld-5.6.33-log]Unknown column 'Bob' in 'field list' /STARTTOURNEY.ASP, line 49
When I run response.write I get the correct response :
UPDATE BRACKET16_73 SET NAME2= Bob WHERE POS = 17
The TNM12 variable returns the correct response of Bob when I do a response.write("TNM12")
Why is the statement looking for a different column name than NAME2??
Please keep in mind that I am using classic ASP with MySQL database. Not sure if that information helps or not.