从数据库脚本DB中馈送数据

Question

我有此代码：

 var db = dbUtenti.getDb(); // 
 var results = db.query({TipoRecord: 'Utenti'});
 var dataSource = [["Codice", "Nome","Cognome","Data nascita", "email", "telefono"]];
 var dataRow = [];
      while (results.hasNext()) {
 var result = results.next();
   dataRow[0] = result.IdUtente;
   dataRow[1] = result.Cognome;
   dataRow[2] = result.Nome;
   dataRow[3] = result.DataNas;
   dataRow[4] = result.EmailUtente;
   dataRow[5] = result.Telefono;
   dataSource.push(dataRow.slice());
  }
  var dataRange = Charts.newDataTable()
      .addColumn(Charts.ColumnType.STRING, dataSource [0] [0])
      .addColumn(Charts.ColumnType.STRING, dataSource [0] [1])
      .addColumn(Charts.ColumnType.STRING, dataSource [0] [2]) 
      .addColumn(Charts.ColumnType.NUMBER, dataSource [0] [3])
      .addColumn(Charts.ColumnType.STRING, dataSource [0] [4])
      .addColumn(Charts.ColumnType.STRING, dataSource [0] [5])
    for (i=1;i<=dataSource.length;i++){
          dataRange.addRow([dataSource [i] [0], dataSource [i] [1], dataSource [i] [2],   dataSource [i] [3], dataSource [i] [4], dataSource [i] [5]])
         .build();
          };

，但我在行上遇到了一个错误。"。建造（）"这是错误："未定义"

"无法读取属性" 0"

我在哪里错了？谢谢你的帮助。

Raffaele

Answer 1

更改以下代码来自：

 for (i=1;i<=dataSource.length;i++){
          dataRange.addRow([dataSource [i] [0], dataSource [i] [1], dataSource [i] [2],   dataSource [i] [3], dataSource [i] [4], dataSource [i] [5]])
     .build();
          };

to：

 for (i=0;i<dataSource.length;i++){
          dataRange.addRow([dataSource [i] [0], dataSource [i] [1], dataSource [i] [2],   dataSource [i] [3], dataSource [i] [4], dataSource [i] [5]])
     .build();
          };

这是因为您在向量长度上迭代，请检查条件。