Set multiple fields in prepared queries in NodeJS

Question

I am using 'mysql' library in Node

This is what i use instead of prepared statement, and works just fine :

 connection.query("update table set col1=? where col2=1",[val1],function(err,rows){
        //connection.release();
        if(!err) {
          //further code
          }
        });

However, this doesn't work for 2 unkowns :

    connection.query("update table set col1=? where col2=?",[val1],[val2],function(err,rows){
        //connection.release();
        if(!err) {
          //further code
          }
        });

The error message says "undefined is not a function". What am i doing wrong?

Andrius · Accepted Answer · 2015-11-14 11:53:12Z

9

You need to define the values in a single array, like this:

connection.query("update table set col1=? where col2=?",[val1,val2],function(err,rows){
    //connection.release();
    if(!err) {
      //further code
      }
    });

All the necessary functionality can be easily found here: https://github.com/felixge/node-mysql/#preparing-queries

answered Nov 14, 2015 at 11:53

Andrius

5,94922 silver badges28 bronze badges

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

4 Comments

user2473779 Over a year ago

Off-topic:Do you know about any similar complete module for PostgreSQL?

Andrius Over a year ago

Don't forget to mark the answer. You can use something like this, I suppose.

codeinprogress Over a year ago

Couple of my update values have comma (,) in them which is messing up the query. What do I do to get rid of that?

Andrius Over a year ago

Are you sure you're using the functionality I have provided? The library should escape values as written here.

Collectives™ on Stack Overflow

Set multiple fields in prepared queries in NodeJS

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related