Select the data conditions for Tizen database table

This function selects data conditions for database table in Tizen mobile.
function dataChange(value) {
    if (value != "all") {
        var html = document.getElementById("tbody01");
        html.innerHTML = "";
        db.transaction(function (t) {
            t.executeSql("SELECT * FROM tizenTable WHERE id=?", [value],
        function (tran, r) {
            for (var i = 0; i < r.rows.length; i++) {
                var id = r.rows.item(i).id;
                var title = r.rows.item(i).title;
                var context = r.rows.item(i).context;

                if (html) {
                    html.innerHTML += "<tr><td>" + id + "</td><td>" + title + "</td><td>" + context + "</td></tr>";
                }
            }
        },
        function (t, e) { alert("Error:" + e.message); }
     );
        });
    } else {
        dataView(db);
    }
}

Responses

0 Replies