duplicate values in list item [message #364722] |
Tue, 09 December 2008 16:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
angelaldixon
Messages: 9 Registered: April 2008
|
Junior Member |
|
|
I have created a list item and populated it from v$timezone_names.
The items are displaying correctly but when I select an item it shows as if I selected something different.
As an example the first few entries in this table are:
TZNAME / TZABBREV
Africa/Algiers / LMT
Africa/Algiers / PMT
Africa/Algiers / WET
Africa/Algiers / WEST
Africa/Algiers / CET
Africa/Algiers / CEST
Africa/Cairo / LMT
Africa/Cairo / EET
Africa/Cairo / LMT
When I select the first 'Africa/Cairo' it displays 'Africa/Algiers', I am assuming because they have the same value in the second column. How do I avoid this from happening?
Also, when the items are displayed it is showing TZNAME, what I would like is 'TZNAME: TZABBREV' to show as the value in the pop list, is that possible?
thanks in advance
Angie
|
|
|
Re: duplicate values in list item [message #364784 is a reply to message #364722] |
Wed, 10 December 2008 00:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Do you have other triggers on these items? You have defined both items that you want populated in the LOV definition haven't you?
David
|
|
|