Solved

onclick action for a dropdown box

Posted on 2013-12-18
6
401 Views
Last Modified: 2013-12-23
I have a question
I know the logic on how to implement it yet I don't know how to actually do it.
Can someone help me out please.
So here it is ....

1. I have a pl\sql query that populates a dropdown box by default
2. on click of the dropdown box (the down arrow) I want a different query to populate the dropdown box


How do I implement this .....

what is the syntax for the onclick in a dropdown
0
Comment
Question by:selhamwy
  • 3
  • 2
6 Comments
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39726909
I think the answer might be in here:
http://jquery-plugins.net/jquery-cascading-dropdown-plugin

I'll add the jQuery Zone to the question.
0
 

Author Comment

by:selhamwy
ID: 39726997
Ray,

thanks but no that does not help.

let me explain further...

the first dropdown  value is different regarding the value
but it always pulls the same second query

let us take this for example

Default Query 1:
Department: IT

Dropdown Query 2:
Department: (lists all departments)

The default is specific to the one person and if you want to change it then it lists all of them.
0
 
LVL 52

Expert Comment

by:Scott Fell, EE MVE
ID: 39727125
For the dropdown, you would probably want to use change http://api.jquery.com/change/

$('.myDropdown').change(function(){
    //do stuff

});

Open in new window


As far as populating the drop down, do you want to use ajax or a page refresh?  Does the drop down always show the same data?   There are a lot of ways to do this.  Can you detail what data you need to save if any from one drop down to the other.  Do you mean to have 2 chained dropdowns http://www.appelsiini.net/projects/chained
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39727132
Can you please post a link to a web page (any page) that demonstrates this?  I don't quite follow the description, but if I see it in action maybe I can show you how it's done.
0
 

Accepted Solution

by:
selhamwy earned 0 total points
ID: 39727481
I got it working

here is the code

if ( $objResult["FIELD"]  == $row ["FIELD"] ) {
	echo '<option selected value="' . $objResult["FIELD"] . '">' . $objResult["FIELD"] . '  </option>'; 
}
else { 
	echo '<option value="' . $row['FIELD'] . '">' . $row['FIELD'] . '  </option>'; 
}

Open in new window

0
 

Author Closing Comment

by:selhamwy
ID: 39735706
I found a way to resolve in HTML
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

759 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

21 Experts available now in Live!

Get 1:1 Help Now