invalid row type for row 0 - coming from fusion table

10 views
Skip to first unread message

Laverne Davis

unread,
May 12, 2017, 11:03:03 AM5/12/17
to Google Visualization API
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;
  
}
Reply all
Reply to author
Forward
0 new messages