I required an error while inserting this dataset in my database: I am programing on express/node.js
this.db.run("INSERT INTO bestellung(rid,bid,tableno,drink,price,validation) VALUES(`"+ridJSON.id+"`,`"+bidJSON.id+"`,"+tableno+","+ name+","+kpreis+","+validation+")", (err) =>
{
if (err)
{
return console.log(err.message);
}
console.log('Row was added to the table');
});
This is my express.js code. And this is the error I am receiving:
Connected to the chinook database.
SQLITE_ERROR: no such column: 89ce87ff-3e55-4660-b958-bc0cfd108413
Here is basically what I am trying to do: I want to insert two types of uuid into my database. I am using BLOB to save the uuid. This seems to work fine with uuid.v1() but using uuid.v4() doesn´t seem to work out.
Since it is both almost the same data:
a3f7f1a0-72b3-11eb-80b9-835df2abaa17 = v1 89ce87ff-3e55-4660-b958-bc0cfd108413 = v4
I wonder why it wont work...
Please help me! I am really getting crazy about this error. I already googled the error and the usage of uuid. It seems fine the way I am using it. Thank you in advance!