Inserting values into sql node.js

Question

I have this:

var userRegister2 = "INSERT INTO GOT (USERNAME, PASSWORD, NAME, USERID) VALUES (?)";
ibmdb.open(ibmdbconnMaster, function (err, conn) {
  if (err) return console.log(err);
  conn.query(userRegister2, [registerDetails.username, registerDetails.password, registerDetails.name, registerDetails.userid], function (err, rows) {
    if (err) {
      console.log(err);
    }

    console.log("success!")


    res.render('index.ejs')

    conn.close(function () {
    });
  });
});

all looks good to me, but then what happens is I get this error:

 SQL0117N  The number of values assigned is not the same as the number of specified or implied columns or variables.

In my database table, I have only those 4 columns, so I am not sure what else to do?

You need to have the same number of parameter-markers as parameters, i.e values(?,?,?,?) — mao
– mao, Commented Apr 8, 2022 at 15:53
Try "INSERT INTO GOT (USERNAME, PASSWORD, NAME, USERID) VALUES ?" — Edward Radcliffe
– Edward Radcliffe, Commented Apr 8, 2022 at 15:57

mao · Accepted Answer · 2022-04-08 16:10:21Z

1

The solution is to change the code so that the number of parameter-markers matches the number of parameters.

In your case, that means VALUES (?,?,?,?) because you are supplying four parameters.

answered Apr 8, 2022 at 16:10

mao

12.4k2 gold badges15 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Inserting values into sql node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related