Code: Select all
#
# works fine
#
put "select Name, Address, Town, Email, WebSite, Twitter, Facebook, Lat, Lon from Rescue where Country = " & quote & tCountry & quote & " and Name = " & quote & tRescueName & quote into tSQL
put revDataFromQuery(,,tDBid, tSQL) into tList
Code: Select all
#
# no error, but no results
#
put "select Name, Address, Town, Email, WebSite, Twitter, Facebook, Lat, Lon from Rescue where Country = :1 and Name = :2" into tSQL
put revDataFromQuery(,,tDBid, tSQL, "tCountry", "tRescueName") into tList