Pulling data from SQLite, but data is undefined

Question

I have a class project where I need to pull data from my SQLite DB and place it into <table>. But every time I reload the page I get this Table image and I was hoping for some help. I'm new to JavaScript and I need to finish this task in a few hours, I've tried to pull the data into an object and from the object into this line str += "<td>" + results.rows.item(i).Firstname + "</td>" and still it didn't work.

db.transaction(function (tx) {
    tx.executeSql('SELECT * FROM Customers_Table ', [], function (tx, results) {
        var len = results.rows.length, i;
        document.getElementById("tablea").innerHTML = '';
        var str = '';
        str += "<th>FirstName</th>";
        str += "<th>LastName</th>";
        str += "<th>Address</th>";
        str += "<th>City</th>";
        str += "<th>Email</th>";
        for (i = 0; i < len; i++) {
            str += "<tr>";
            str += "<td>" + results.rows.item(i).Firstname + "</td>";
            str += "<td>" + results.rows.item(i).Lastname + "</td>";
            str += "<td>" + results.rows.item(i).Address + "</td>";
            str += "<td>" + results.rows.item(i).City + "</td>";
            str += "<td>" + results.rows.item(i).Email + "</td>";
            str += "</tr>";

            document.getElementById("tablea").innerHTML += str;
            str = '';


        }

    });
});

Think about how to debug it. For example, try print_r(results); to see what you get, if anything. — Michael McGinnis
– Michael McGinnis, Commented Mar 3, 2020 at 5:32

Sunil Lama · Accepted Answer · 2020-03-02 23:18:37Z

1

Well, considering that you have data in results. It should be used as:

results.rows.item[i].Firstname

NOT

results.rows.item(i).Firstname

answered Mar 2, 2020 at 23:18

Sunil Lama

4,5391 gold badge21 silver badges48 bronze badges

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

11 Comments

Yuval Barzilai Over a year ago

if im using the [] then it will nor recognize the Firstname column

Yuval Barzilai Over a year ago

it giving me en error but is said "cannot read property 'Firstname' of undefined"

Sunil Lama Over a year ago

@YuvalBarzilai, just your result, do console.log(JSON.strigify(result));

Yuval Barzilai Over a year ago

im not using JSON, havent even imported anything

Sunil Lama Over a year ago

you dont have to import anything, after function (tx, results) { console.log(JSON.strigify(result)) to check if the results are coming after your query

|

Yuval Barzilai · Accepted Answer · 2020-03-03 20:21:43Z

0

Finally figured out the problem, the .Firstname and the rest didn't match the column names from the Db table, it was lowercase,look carefully at your code guys!!

answered Mar 3, 2020 at 20:21

Yuval Barzilai

11 bronze badge

Collectives™ on Stack Overflow

Pulling data from SQLite, but data is undefined

2 Answers 2

11 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related