Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-23
3
Medium Priority
?
2,602 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 74

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 74

Accepted Solution

by:
sdstuber earned 1000 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

Looking for the Wi-Fi vendor that's right for you?

We know how difficult it can be to evaluate Wi-Fi vendors, so we created this helpful Wi-Fi Buyer's Guide to help you find the Wi-Fi vendor that's right for your business! Download the guide and get started on our checklist today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

722 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