SqlServer $queryRaw with 'in' operator
hi, I have been stuck with trying to do $queryRaw using in operator
I have array like this
I'm trying to do
not returning any result, but if I hard code those values it works fine
when I do console log using array join without prisma join it returned
the example in docs are for integers not strings
thanks in advance
I have array like this
const arr = ['john', 'tony', 'sarah']I'm trying to do
select * from table where name in (${Prisma.join(arr)})not returning any result, but if I hard code those values it works fine
when I do console log using array join without prisma join it returned
"/'john/',/'tony/',/'sarah/'", might be the problem here ?the example in docs are for integers not strings
thanks in advance
