Forums

OverviewV-Play 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.

Voted #1 for:

  • Easiest to learn
  • Most time saving
  • Best support

Develop Cross-Platform Apps and Games 50% Faster!

  • Voted the best supported, most time-saving and easiest to learn cross-platform development tool
  • Based on the Qt framework, with native performance and appearance on all platforms including iOS and Android
  • Offers a variety of plugins to monetize, analyze and engage users
FREE!
create apps
create games
cross platform
native performance
3rd party services
game network
multiplayer
level editor
easiest to learn
biggest time saving
best support