Find the Best Demos and Examples

Check out this quick tour to find the best demos and examples for you, and to see how the Felgo SDK can help you to develop your next app or game!

Forums

OverviewFelgo 1 Support › sqlite and record count

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #7042

    Michael

    Hi

    I’m trying code like this

            db.transaction(
                function(tx) {
                    var rs = tx.executeSql('SELECT count(*) FROM items where id=?',[item.id])
                    if(rs.rows.item(0).count>0)return

    however I get undefined for rs.rows.item(0).count

    I’ve also tried value and result etc instead of count – kinda driving me crazy (not so well documented). Has anyone else done this, and can tell me what the appropriate reference is i.e. rs.rows.item(0).<whatisthis> for the count situation?

     

    Thanks

    Michael.

    #7043

    Michael

    Never mind, I worked out a a solution.

    Using for(var propertyName in rs.rows.item(0)) I could see that the property is count(*), so ” rs.rows.item(0).count(*)” is illegal so the workaround is to label the resultset using something like:

    SELECT count(*) as count FROM items

    so you can use rs.rows.item(0).count

    Hope this helps someone, one day.

    Cheers,

    Michael.

Viewing 2 posts - 1 through 2 (of 2 total)

RSS feed for this thread

You must be logged in to reply to this topic.