Solved

Oracle Apex How to set up Select list with submit page item

Posted on 2008-10-23
3
2,537 Views
Last Modified: 2013-12-07
I have an existing page that displays data for one location.   I need to revamp things and add multiple locations that will be in a select list with submit. so that when a location is chosen the page is resubmitted with the location chosens data.   All the queries are in pl/sql on an oracle database.  

Thank you.
0
Comment
Question by:pattisp1
  • 2
3 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 22789298
what is the question?  Which part of that do you need help with?
0
 

Author Comment

by:pattisp1
ID: 22799772
I am going from a static location of Michigan and we are adding another location in Indiana.   The default information on the page will be for Michigan.   I want the ability to pull down the drop down list for location and when I chose Indiana, the page is automatically refreshed with the data for the Indiana location.  I have the drop down already as a select list with submit but now I need to repopulate the data with the Indiana location chosen.   The data will be stored in an Oracle table.      
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 250 total points
ID: 22799811
how does your page know how to pull Michigan data?

I assume your report and chart regions have queries something like this?


select col1,col2, col3 from your_table where state_name = 'Michigan'

change that to

select col1,col2, col3 from your_table where state_name = :P20_STATE_CHOICE


where P20_STATE_CHOICE is the name of your select list item
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now