[Pogaca]

Greetings everyone,

So, inside one function I have two queries, which is not a problem, I had other functions with over 7 queries. But, now I would like to insert JSON string inside SQLite database. It just does not work. I use this code so far:

function saveDataToDatabase() {
    
    saveFontValues();
    saveColors();
//    getCoordinatesOfBoxes();

    db.transaction(function(tx){
        tx.executeSql("CREATE TABLE IF NOT EXISTS template (id INTEGER NOT NULL PRIMARY KEY, colors TEXT, fonts TEXT)");
        
    });
    
    db.transaction(function(tx){
        tx.executeSql("INSERT INTO template VALUES(?,?,?)"[null, colors, fonts]);
    });
    
    }

Keep it in mind that colros and fonts are both JSON strings converted from Javascript object to string this way:

 colors = JSON.stringify(colorObj);

Is it wrong that I choose TEXT as expected value for JSON in table? What should i pick? After all. json string is a string. Problem is that when I use console.log, I see all values for colors, but when I try to insert them, nothing happens.

[Dormilich]

Is that IndexedDB?

[Pogaca]

No, it is not. This is what I use:
https://developer.ap...ptDatabase.html

[Dormilich]

So this is not a browser script?

[Pogaca]

Yes it is. Database is stored on client side. Not like PHP on server side. I simply use javascript and jQuery to create, update, delete, select (any query) for table. It worked well for most thing I have done but now it just won't insert JSON string.

[Dormilich]

Quote

tx.executeSql("INSERT INTO template VALUES(?,?,?)"[null, colors, fonts]);

Seems like there's a comma missing. but JS would complain about that.

This post has been edited by Dormilich: 10 April 2018 - 03:14 AM

[Pogaca]

Oh my, you are right. Than you so much!