Javascript, SQLite database query returning 'Object Object'

Question

I'm checking out the sqlite and html5 using Javascript, heres the code I'm using to create, my DB, create my table and insert values from 3 text boxes that I have

function Add2DB() 
{
    var Tname = document.getElementById('txtName').value;
    var Tprice = document.getElementById('txtPrice').value;
    var Tqty = document.getElementById('txtQTY').value;
    db.transaction(function (tx){
        tx.executeSql('INSERT INTO foo (name,price,qty) VALUES(?,?,?)',[Tname,Tprice,qty]);
        tx.executeSql('SELECT * FROM foo', [], function (tx, results){
            var len = results.rows.length;

            //For statements not allowed, just bring back first item in db
            alert(results.rows.item(0).text)
        });
    });
}

The problem I'm having is that whenever I iterate through this, It just says Object object. I think it is a Javascript problem I'm having, I'm not certain though

tx.executeSql('INSERT INTO foo (name,price,qty) VALUES(?,?,?)',[Tname,Tprice,qty]);

This line might not be right either and may not be actually inserting the mapped values right. Can someone please shed some light on this. Any help, or ideas would help me greatly. Thank you.

whoughton · Accepted Answer · 2011-03-31 16:49:03Z

1

Rather than an alert, if you use console.log (requiring Firefox with Firebug or a webkit-based browser) you can easily see more detail in what you're working with.

Try console.log("Results row: %o", results.rows.item(0).text);

If it is an object you'll be able to see into the object and better understand what it is. You'll need to look in the javascript console in those browsers.

answered Mar 31, 2011 at 16:49

whoughton

1,38511 silver badges21 bronze badges

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

3 Comments

whoughton Over a year ago

I'll note that I'm going to go with Tim's response above though. Mine may better give you better information about the error, but I think his might actually point out the actual error.

Kai CriticallyAcclaimed Cooper Over a year ago

well good news is there is content w/ the correct data wrapped up inside the Object. Now I have to figure out how to pull it out.

Kai CriticallyAcclaimed Cooper Over a year ago

Thank you, I got the data back I needed. I made another variable, called and the prop named I wanted and it returned: var obj = results.rows.item(i); alert(obj.name);

Collectives™ on Stack Overflow

Javascript, SQLite database query returning 'Object Object'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related