Getting invalid row type. City and name are text. Can some one assist.
var selQry = "SELECT city,Name,category_id,subcategory_id FROM "+TABLE_ID+" ";
var data = FusionTables.Query.sql(selQry);
var cent=[1,2];
for(var i=0;i<data.rows.length;i++){
if(data.rows[i][2]==varMenu1 && data.rows[i][3]==varMenu2){
cent[0]=data.rows[i][0];
cent[1]=data.rows[i][1];
cent[2]=data.rows[i][2];
break;
}
}
}
Logger.log(cent);
return cent;
}