Using a placeholder with an inArray

I'm porting a query to a prepared statement, in the query I used to do something like:

.where(inArray(users.id), ['abc', 'def']))

.where(inArray(users.id), ['abc', 'def']))

After trying to move it to a prepared statement:

.where(inArray(users.id), placeholder("userIds"))

.where(inArray(users.id), placeholder("userIds"))

However, when I execute the pepared statement and pass { userIds: ['abc', 'def'] } I get a syntax error: PostgresError: syntax error at or near "$1"

1 Reply

Vovochka•12mo ago

Last solution works for me. https://discord.com/channels/1043890932593987624/1116352742026395658/1116370237185589338

Gaming

Programming

Using a placeholder with an inArray