javascript - How to add two bind params in knex? - Stack Overflow

admin管理员组

文章数量:1356808

I'm traying to select something from database and I have to use 2 bind params. With one param it works but with two i get this error "Undefined binding(s) detected when piling RAW query" error and "Expected 1 bindings, saw 2" in nodejs console.

How to use 2nd bind param?

Code that works:

knex.with('with_alias', knex.raw('select * from "lyrics" where "for_id" = "1" and "var" = ?', var)).select('*').from('with_alias')

I also tried but it didn't worked

knex.with('with_alias', knex.raw('select * from "lyrics" where "for_id" = ? and "var" = ?', var1, var2)).select('*').from('with_alias')

Thanks for help and sorry for bad english!

I'm traying to select something from database and I have to use 2 bind params. With one param it works but with two i get this error "Undefined binding(s) detected when piling RAW query" error and "Expected 1 bindings, saw 2" in nodejs console.

How to use 2nd bind param?

Code that works:

knex.with('with_alias', knex.raw('select * from "lyrics" where "for_id" = "1" and "var" = ?', var)).select('*').from('with_alias')

I also tried but it didn't worked

knex.with('with_alias', knex.raw('select * from "lyrics" where "for_id" = ? and "var" = ?', var1, var2)).select('*').from('with_alias')

Thanks for help and sorry for bad english!

• javascript
• mysql
• node.js
• knex.js

Share Improve this question Follow asked Jan 28, 2019 at 17:59 Pavel ProdanPavel Prodan 6922 silver badges77 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 7

Try to pass two variables in an array:

knex.with('with_alias', knex.raw('select * from "lyrics" where "for_id" = ? and "var" = ?', [var1, var2])).select('*').from('with_alias')

It should work.

本文标签： javascriptHow to add two bind params in knexStack Overflow