db.exec(`CREATE TABLE cmd (name varchar(20), value text)`);
table schema
#Need help with sqlite3 module
crimson tendon
fallow temple
You don’t have named parameters in your SQL statement but pass them as an object for names parameters. Either pass them as array instead or use named parameters in the SQL
crimson tendon
You don’t have named parameters in your SQL statement but pass them as an object...
i tried with [name,data], {name,data} and ...,name,data,... also
all return same error
fallow temple
And did you check that the table in SQLite actually has those two columns?
crimson tendon
i cant delete teh db rq to test
yeah
it for sure has it
fallow temple
You don’t need to delete it
crimson tendon
wtf, it shows me it added it to the dn
*db
still error thrown tho
fallow temple
Does the error come from that line though?
crimson tendon
hmm
/**
* @param {String} name
* @returns {Promise.<Command>}
*/
static async getCommand(name){
return new Promise(r=>{
db.all(`SELECT * FROM cmd WHERE name='?'`,[name],(err,rows)=>{
console.log("a2")
if(err)throw err;
r(rows[0])
})
})
}
its thrown in here?? lol
its coz of '', ok
it should be ? not '?'
ok, fixed