Skip site navigation (1) Skip section navigation (2)

Re: Fw: pop-up multiselection array and wherecondition

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <giuseppe(dot)derossi(at)email(dot)it>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fw: pop-up multiselection array and wherecondition
Date: 2007-08-29 14:00:38
Message-ID: 46D535B5.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
>>> On Wed, Aug 29, 2007 at  1:53 AM, in message
<6e07a86b040326879dfe5a7bfb1337c5(at)164(dot)129(dot)1(dot)43>, <giuseppe(dot)derossi(at)email(dot)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
 



In response to

pgsql-admin by date

Next:From: Robert TreatDate: 2007-08-29 14:44:17
Subject: Re: how is pitr replay interruption time determined?
Previous:From: Ben KimDate: 2007-08-29 13:41:03
Subject: Re: How to monitor resources on Linux.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group