OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Column names to a listbox (APEX 3.2)

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

Column names to a listbox [message #479072]

Thu, 14 October 2010 08:56

Mattit
Messages: 3
Registered: October 2010
Location: Sidney, ne

Junior Member

Hey, folks. I'm trying to populate a listbox or dropdown with a list of column names from a given table.

I hunted around and found a quick query to get the result set I need. But no matter what I try whenever I use it (modified slightly) I get an error when I try to use it to populate a listbox.

Original query:
SELECT column_name FROM all_tab_cols where table_name ='SMT_INTERNAL';

Modified query:
SELECT column_name display_value, column_name return_value FROM all_tab_cols where table_name ='SMT_INTERNAL';

Help would be much appreciated.

Thanks,
-- Matt

Report message to a moderator

Re: Column names to a listbox [message #479155 is a reply to message #479072]

Thu, 14 October 2010 15:38

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

I get an error when I try to use it to populate a listbox.

It would, possibly, help if we knew which error it is.

Report message to a moderator

Re: Column names to a listbox [message #479159 is a reply to message #479155]

Thu, 14 October 2010 15:59

Mattit
Messages: 3
Registered: October 2010
Location: Sidney, ne

Junior Member

The error I get during the build wizard:

LOV query is invalid, a display and a return value are needed, the column names need to be different. If your query contains an in-line query, the first FROM clause in the SQL statement must not belong to the in-line query.

Report message to a moderator