pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpop-up multiselection array and where condition
3+ messages / 2 participants
[nested] [flat]
* pop-up multiselection array and where condition
@ 2007-08-27 10:10 giuseppe.derossi@email.it
0 siblings, 0 replies; 3+ messages in thread
From: giuseppe.derossi@email.it @ 2007-08-27 10:10 UTC (permalink / raw)
To: pgsql-admin
Hi,
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})
is there a stright way to do that ?
thanks in advance and best regards
Giu
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
KILL BILL! scarica la colonna sonora del film: รจ in REGALO!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6614&d=20070827
^ permalink raw reply [nested|flat] 3+ messages in thread
* Fw: pop-up multiselection array and where condition
@ 2007-08-29 06:53 giuseppe.derossi@email.it
0 siblings, 1 reply; 3+ messages in thread
From: giuseppe.derossi@email.it @ 2007-08-29 06:53 UTC (permalink / raw)
To: pgsql-admin
Hi,
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})
is there a stright way to do that ?
thanks in advance and best regards
Giu
--
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
250 biglietti da visita Gratis + 42 modelli e Etichette per Indirizzo
Gratis + Porta biglietti Gratis -Offerta limitata!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6785&d=20070829
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Fw: pop-up multiselection array and where condition
@ 2007-08-29 14:00 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: giuseppe.derossi@email.it
0 siblings, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2007-08-29 14:00 UTC (permalink / raw)
To: giuseppe.derossi@email.it; pgsql-admin
>>> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-08-29 14:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-27 10:10 pop-up multiselection array and where condition giuseppe.derossi@email.it
2007-08-29 06:53 Fw: pop-up multiselection array and where condition giuseppe.derossi@email.it
2007-08-29 14:00 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox