How to get the number of rows from a sql query in GAS?

Question

My script allows a user query from a sheet a SQL database. Before letting the script write in the sheet the select's result, how can I know the number of rows I am getting from that query?

Multiplying the count of rows by the count of columns I want to warn the user if the query result size is over 10.000 cells so he is aware of crashing the sheet.

The method getColumnCount() works perfect but not for rows. I tried some other ways but nothing worked... any advice?

    var columnsNumber = resultmetadata.getColumnCount();
    ui.alert(columnsNumber); //this works

    var rowsNumber = resultmetadata.getRowCount();
    ui.alert(rowsNumber);  //this doesn't work

Thanks, Gerónimo

Which type of SQL database is used? – Robin Gertenbach Mar 01 '16 at 16:35 — Robin Gertenbach, Mar 01 '16 at 16:35

score 0 · Answer 1 · edited May 23 '17 at 11:50

0

Through this post How do I get the size of a java.sql.ResultSet? thanks to Martin Hawksey, I made this and worked perfect:

  if (result.last()) {  //query result
    var rowsNumber = result.getRow();
    result.beforeFirst(); // not rs.first() because the rs.next() below will move on, missing the first element
  }

edited May 23 '17 at 11:50

Community

1
1

answered Mar 02 '16 at 01:34

Gerónimo Tutusaus

37
6

How to get the number of rows from a sql query in GAS?

1 Answers1