fetch results from sqlite database

Question

i want to get the location from specific user and when i run this code it gets me error ' Uncaught TypeError: Cannot read property 'location' of undefined ' and i dont know how i can fixed. this is the code :

db.transaction(function(tx){
     tx.executeSql("SELECT location FROM users WHERE username='"+username+"'",[], success ); 
});

function success(tx,results){
     var city = results.rows.item[0].location;
}

Please make the example code a minimal, complete, verifiable example. — bignose
– bignose, Commented Apr 3, 2016 at 19:58

Pedro · Accepted Answer · 2016-04-03 20:14:07Z

1

You're using square brackets instead of parentheses when you call item on results.rows.

answered Apr 3, 2016 at 20:14

Pedro

4092 silver badges7 bronze badges

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

1 Comment

Pedro Over a year ago

No problem. Please select this as the answer and have a good day! :-)

Collectives™ on Stack Overflow

fetch results from sqlite database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related