How to write a parameterized SQL query in javascript?

Question

how to write a parameterized SQL Query in javascript ?

i am trying this but getting an error

i am also tried this 2 still getting syntax error

let sql =select * from q_users where firstname=?,[${name}];

let sql =select * from q_users where firstname=?,${name};

let sql =`select * from q_users where firstname=?,${[name]}`;
db.query(sql)
.then((data)=>{
    console.log(data);
});

baao · Accepted Answer · 2018-04-15 08:49:12Z

0

The easiest would be to just stick to the extensive documentation - and learning basic javascript. The statement

let sql =`select * from q_users where firstname=?,${[name]}`;

makes no sense, it's just a string with an array at its end. It might be helpful to read up about template strings to get to know them and how to use them properly.

The docs explain to pass two arguments to db.query(). So you will need something like

let sql = 'select * from q_users where firstname=?';
db.query(sql, [name]).then(...);

Also, avoid using name as a variable's name.

answered Apr 15, 2018 at 8:49

baao

73.5k18 gold badges152 silver badges208 bronze badges

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

2 Comments

Ajay Kumbhare Over a year ago

but sometimes i have different parameters length then how can i handle dynamic ? like let sql = 'select * from q_users where firstname=?'; db.query(sql, [name]).then(...); let sql = 'select * from q_users where firstname=? and lastname=?'; db.query(sql, [name,lname]).then(...); here i don't want to reWrite db.query()

baao Over a year ago

You'd obviously pass a single array. db.query(sql, [param1, param2, param3]). @AjayKumbhare ... Again, the docs have all your questions covered in detail

Collectives™ on Stack Overflow

How to write a parameterized SQL query in javascript?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related