Subject | Re: [Firebird-general] where IN with param |
---|---|
Author | Nando Dessena |
Post date | 2004-01-04T10:12:57Z |
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@...
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@...