Home » Developer & Programmer » Forms » How to handle data from multiple select boxes in pl/sql?
How to handle data from multiple select boxes in pl/sql? [message #303974] Mon, 03 March 2008 09:35 Go to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Hi,

I have to write a procedure to return a set of values depending on inputs provided.

However, in this case the input shall be in form of comma separated values.

For e.g. there is a multiple select box called colour on the UI, so the person can select multiple colours and its gets passed as 'Blue','Green','White'.

Now, I have to return all the records from a table where colour in ('Blue','Green','White').

How do I handle this? I mean it is passed as a variable pcolor to the SP.

How do I analyse this variable and extract the colors so I could compare it with the table and retrieve records?

Thanks,

Sharath
Re: How to handle data from multiple select boxes in pl/sql? [message #303976 is a reply to message #303974] Mon, 03 March 2008 09:43 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Have a look at the "Varying elements in IN list" example on AskTom
Re: How to handle data from multiple select boxes in pl/sql? [message #303978 is a reply to message #303976] Mon, 03 March 2008 09:48 Go to previous message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Thanks a lot Thomas
Previous Topic: Show Image In Tree
Next Topic: Tab canvas on Content Canvas
Goto Forum:
  


Current Time: Mon Dec 05 18:50:36 CST 2016

Total time taken to generate the page: 0.08992 seconds