Hello 2009/10/10 Raymond O'Donnell <r...@iol.ie>: > I'm using PDO in PHP for database access (actually Zend Framework), and > following best practice by using parameters in prepared statements. > > My question is, what do people normally do when there's a variable > number of parameters? - for example: > > select ..... where item_id in ( ... ); >
You can use arrays here. select ... where item_id = ANY(string_to_array($1, ',')) Regards Pavel Stehule > In this case, I mightn't know how many values will go inside the > parentheses. > > Thanks, > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > r...@iol.ie > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
