javascript SQLite SQL execution is disallowed [duplicate]

Question

i use the below code in order to display a form

    notesdb.transaction(function(t) {
    t.executeSql('SELECT buildingcode, buildingaddress FROM buildings WHERE buildingcode = ?', [BuildingCode], 
            function(t, result) {
                var rowaddress = result.rows.item(0);
                $('#displayflatcomments articleflatcomment').html('Κωδικός: <strong>' + rowaddress.buildingcode + '</strong>');
                $('#displayflatcomments articleflatcomment1').html('Διευθυνση: <strong>' + rowaddress.buildingaddress + '</strong>');
    });

    t.executeSql('SELECT id, BuildingCode, FlatNo, Comment, CommentMore, Closed, New FROM flatcomments WHERE New = 1 ORDER BY BuildingCode ASC', [], 
            function(t, result) {
                var rowcomment = result.rows.item(0);
                //alert(rowcomment.id);
                $('#displayflatcomments articleflatcomment2').html('Ονομα: <strong>' + rowcomment.Comment + '</strong>');
                $('#flatcommentdisplay').val(rowcomment.CommentMore.slice(0, rowcomment.CommentMore.length-16));



        $('#paycommentsdelete').click(function(){
            t.executeSql('DELETE FROM flatcomments WHERE id = ?', [rowcomment.id]); 
            $.mobile.changePage('#comments', 'slideup', false, true);
        });    
        $('#sub').unbind('click').click(function(){

        });
    });

});

I have delete button with paycomentsdelete id.

When I click it i receive Uncaught InvalidError: Failed to execute 'executeSql' on 'SQLTransaction': SQL execution is disallowed.

how can I fix it??

kaicarno · Accepted Answer · 2015-01-24 20:39:44Z

-1

A thought on this is that SQLite database files have to be writable by the server. (chmod 777). By default you can read from the database but not DELETE or modify.

Inspect your database file for write permissions and make sure writable is enabled. Hope that works.

answered Jan 24, 2015 at 20:39

kaicarno

4261 gold badge5 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

javascript SQLite SQL execution is disallowed [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related