#difficulty with sql database "INSERT INTO" query

3 messages · Page 1 of 1 (latest)

heady nova
#
app.post('/customTask', function(request, response) {
    if (request.session.loggedin && request.session.isAdmin) {
        let username = request.body.name
        let taskid = parseInt(request.body.taskid)
        taskid = Math.trunc(taskid)
        let taskDescription = request.body.taskName
        let pointVal = parseInt(request.body.customPointVal)
        pointVal = Math.trunc(pointVal)
        let status = parseInt(request.body.status)
        status = Math.trunc(status)

        if(status == 0){
            var boolStatus = false
        } else if(status ==1){
            var boolStatus = true
        }
        console.log("Inserting task...")
        connection.query("INSERT INTO tasks (user, taskid, taskdescription, status, points) VALUES (?, ?, ?, ?, ?)", [username, taskid, taskDescription, boolStatus, pointVal], function(error, results, fields) {
            if (error) throw error;
            console.log(results)
            console.log('Task inserted successfully!')
            response.redirect('/admin')
        })
    }})
#

results:

OkPacket {
  fieldCount: 0,
  affectedRows: 1,
  insertId: 0,
  serverStatus: 2,
  warningCount: 0,
  message: '',
  protocol41: true,
  changedRows: 0
}
#

nothing is being added to the database when it's run :/