OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » How do you refer to value in a Select list

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How do you refer to value in a Select list

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do you refer to value in a Select list [message #384294]

Tue, 03 February 2009 03:09

Derek N
Messages: 80
Registered: September 2002

Member

Hi

I have a select list named P1_prod.

My definition of the select list is:

SELECT product_name d, id r FROM products ORDER BY 1;

I created a validation. How do I refer to the product id from the select list. :P1_prod.id does not seem to work.

Thanks

Report message to a moderator

Re: How do you refer to value in a Select list [message #384305 is a reply to message #384294]

Tue, 03 February 2009 03:40

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

your attempt will not work. You would have selected the selected list of P1_prod ( using select list / lov and pressing the enter) against the page variable and stored the return value. where is the question for further reference for validation using the prodlist name.

Report message to a moderator

Re: How do you refer to value in a Select list [message #384318 is a reply to message #384294]

Tue, 03 February 2009 04:45

Derek N
Messages: 80
Registered: September 2002

Member

Are you saying that I should use the product name and not the id in my validation?

Thanx

Report message to a moderator

Re: How do you refer to value in a Select list [message #384338 is a reply to message #384318]

Tue, 03 February 2009 07:33

c_stenersen
Messages: 255
Registered: August 2007

Senior Member

If you want to do the validation based on the id, simply use :P1_prod.

The item will always contain the return value of the select list (id in your case). The display value is not what you refer to, it's only shown in the select list, not stored in the item. :P1_prod is stored as a simple value, not a record of some sort.

Report message to a moderator

Re: How do you refer to value in a Select list [message #384354 is a reply to message #384294]

Tue, 03 February 2009 08:44

Derek N
Messages: 80
Registered: September 2002

Member

Thanks, would try and let you know.

Report message to a moderator

Previous Topic:	Display value in text field
Next Topic:	Mailto url and page items

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 14 06:59:29 CST 2026