Subject Re: [Firebird-general] where IN with param
Author Nando Dessena
Hello,
first of all, this is not a support list; next time please use
firebird-support instead.

As per your question...

e> SELECT *
e> FROM DATI
e> where ABBREVIA IN (:param)
e> i'm not able to setting the correct value?

e> :param = 'x','FOL' no good
e> :param = 'x,FOL' no good
e> :param = ''x'',''FOL'' no good
e> and so on......

You have no way to pass two values in a single param. Either use two
params or build your SQL string on the fly.

Ciao
--
Nando mailto:nandod@...