I have a field (Searchvalues) that contains the search value as a test and the query returns two rows as it should. This is probably not the best way of doing it so any tips would be much appreaciated
Code: Select all
put "SELECT * FROM `scores` WHERE username LIKE '%" & line 1 of field "Searchvalues" & "%' OR Hero LIKE '%" & line 1 of field "Searchvalues" &"%'" into tSQL
put revDataFromQuery(tab,tab, gConnectionID, tSQL) & return after field "scores"