Javascript - Function to Count Unique Database Rows

Question

I am writing a Javascript function where I need to count the number of unique entry in a certain column in my SQLite Database. So far, what I have tried to do is to just simply count the number of entries present as I need that as a parameter when I populate entries. My function goes as such:

MasterTreeDB.transaction(function(transaction) {
    transaction.executeSql("SELECT COUNT(*) FROM MasterTreeTable", [],
        function(transaction, result) {
            //console.log(result.rows);
            console.log(result.rows.item(0));
        },
        function(transaction, error){
            // error occured
            console.log("Error occured");

        }
    );
});

However, this is what the console shows: Object {COUNT(*): 4}

I have also looked around and I saw a solution that involved changing results.row.item(0) to results.row.item(0)["count(*)"]. However, when I did that, the log showed undefined

I feel like I'm really close to getting the result I want and I'm missing something rather basic. Any help/input is very much appreciated, thank you in advance.

Try grouping by the column. example. stackoverflow.com/questions/6744803/… — Keith John Hutchison
– Keith John Hutchison, Commented Jan 7, 2014 at 1:26

David-SkyMesh · Accepted Answer · 2014-01-07 01:27:03Z

1

"count the number of unique entry in a certain column in my SQLite Database":

select TheColumn from MasterTreeTable group by TheColumn;

Then result.rows.length is the number of unique values contained in TheColumn.

answered Jan 7, 2014 at 1:27

David-SkyMesh

5,1721 gold badge35 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Javascript - Function to Count Unique Database Rows

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related