[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.

[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.