Re: [ADMIN] Fw: pop-up multiselection array and where condition

From: Kevin Grittner <Kevin.Grittner(at)wicourts.gov>
Date: Wed Aug 29 2007 - 10:00:38 EDT

>>> On Wed, Aug 29, 2007 at 1:53 AM, in message <6e07a86b040326879dfe5a7bfb1337c5@164.129.1.43>, <giuseppe.derossi@email.it> wrote:
> I've to perform a where condition which includes the output from a
> multiselectio pop-up: ie user can choose one or more item from a pop-up
> munu, let's say (item1,item3,item10), then I want to send this set of
> values
> as an array or table via php to a query that should have as where condition
> some like that:
>
> select * from table1 where field1 is in (array{item1,item3,item10})
 

Have you tried?:  

select * from table1 where field1 in (item1,item3,item10)  

-Kevin  

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq Received on Wed Aug 29 10:03:39 2007