Dynamic select boxes - simple question.

[cy]

Hi all,
I would appreciate it if anyone could point me on this.
My JSP page has 3 select boxes for states, counties and, cities and the
counties and cities should be populated once the user chooses a state and so
forth for the cities too.
I will need to get the data from an Oracle database.

Thanks so much in advance.

[Matt Kruse]

cy wrote:

I would appreciate it if anyone could point me on this.
My JSP page has 3 select boxes for states, counties and, cities and
the counties and cities should be populated once the user chooses a
state and so forth for the cities too.
There are a number of solutions and approaches to implementing this. Search
the archives for this group for a lot of discussion about it.
If you are sure you want to implement this, you can use a library like mine
to get it done quickly and easily:
http://www.javascripttoolbox.com/dynamicoptionlist/
I will need to get the data from an Oracle database.

That is irrelevant in this context.
Where it comes from doesn't matter, and how you generate the HTML/JS doesn't
matter. As long as the correct javascript and html is generated and returned
to the browser, it will work.

--
Matt Kruse
Javascript Toolbox: http://www.JavascriptToolbox.com/

[cy]

Thanks Matt.
But, I cannot store all the values like Example1 shows. I need to get the
counties and cities from the database/file once a state is selected.

Any ideas?

Thanks.

"Matt Kruse" <ne********@mattkruse.com> wrote in message
news:ca*********@news1.newsguy.com...

cy wrote:

I would appreciate it if anyone could point me on this.
My JSP page has 3 select boxes for states, counties and, cities and
the counties and cities should be populated once the user chooses a
state and so forth for the cities too.
There are a number of solutions and approaches to implementing this.

Search the archives for this group for a lot of discussion about it.
If you are sure you want to implement this, you can use a library like mine to get it done quickly and easily:
http://www.javascripttoolbox.com/dynamicoptionlist/

I will need to get the data from an Oracle database.
That is irrelevant in this context.
Where it comes from doesn't matter, and how you generate the HTML/JS

doesn't matter. As long as the correct javascript and html is generated and returned to the browser, it will work.

--
Matt Kruse
Javascript Toolbox: http://www.JavascriptToolbox.com/

[Amir]

"Matt Kruse" <ne********@mattkruse.com> wrote in message
news:ca*********@news1.newsguy.com...

you can use a library like mine

to get it done quickly and easily:
http://www.javascripttoolbox.com/dynamicoptionlist/

Just curious ... where is the code for the "DynamicOptionList()" function?
According to my understanding, this would be the constructor function of the
"DynamicOptionList" object.

[cy]

Thanks Dave,
but, the data for counties and cities should be obtained from a database or
file in my case. They are hard coded in Example1.

Any ideas?
Thanks.
"cy" <ja********@bls.gov> wrote in message
news:ca**********@blsnews.bls.gov...

Hi all,
I would appreciate it if anyone could point me on this.
My JSP page has 3 select boxes for states, counties and, cities and the
counties and cities should be populated once the user chooses a state and so forth for the cities too.
I will need to get the data from an Oracle database.

Thanks so much in advance.

[Matt Kruse]

Amir wrote:

Just curious ... where is the code for the "DynamicOptionList()"
function? According to my understanding, this would be the
constructor function of the "DynamicOptionList" object.

In the js file...

// DynamicOptionList CONSTRUCTOR
function DynamicOptionList()

--
Matt Kruse
Javascript Toolbox: http://www.JavascriptToolbox.com/

[Matt Kruse]

cy wrote:

But, I cannot store all the values like Example1 shows.
Why not?
I need to get the counties and cities from the database/file
once a state is selected.

Then you should submit the form when a state is selected, do a query on the
server, and paint the appropriate select box when the html is returned. And
when you do that, it stops being a javascript question :)

--
Matt Kruse
Javascript Toolbox: http://www.JavascriptToolbox.com/

[Randy Webb]

Matt Kruse wrote:

I need to get the counties and cities from the database/file
once a state is selected.

Then you should submit the form when a state is selected, do a query on the
server, and paint the appropriate select box when the html is returned. And
when you do that, it stops being a javascript question :)

Or, simply dynamically load the appropriate .js file as the result of a
query sent to the server. Keeps from reloading/refreshing the page but
can be slow at times....
--
Randy
Chance Favors The Prepared Mind
comp.lang.javascript FAQ - http://jibbering.com/faq/

[kaeli]

In article <ca**********@blsnews.bls.gov>, ja********@bls.gov
enlightened us with...

Hi all,
I would appreciate it if anyone could point me on this.
My JSP page has 3 select boxes for states, counties and, cities and the
counties and cities should be populated once the user chooses a state and so
forth for the cities too.
I will need to get the data from an Oracle database.

Thanks so much in advance.

You can modify this javascript/CGI combo to instead have an onchange of
a select call a *servlet* (not a JSP page) that generates the
javascript. Note that this is merely an example of getting a client-side
event to trigger a server-side action. You need to make a javascript
that will change your options appropriately. I have an example of that
script, too, if you'd like.

This works only in DOM browsers and, for production, should be wrapped
in a check block to prevent bad things from happening on old browsers.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd">
<html>
<head>
<title> Test server-side JS </title>
</head>

<body>
<script type="text/javascript">
function checkIt(variable, value)
{
var newScript = "cgi-bin/validateJS.cgi?"+variable+"="+value;

var body = document.getElementsByTagName('body').item(0)
var scriptTag = document.getElementById('loadScript');
if(scriptTag) body.removeChild(scriptTag);
script = document.createElement('script');
script.src = newScript;
script.type = 'text/javascript';
script.id = 'loadScript';
body.appendChild(script)
}
</script>
<p>Test.</p>
<form id="f1" action="">
<input type="text" name="t1" id="t1" onChange="checkIt(this.name,
this.value)">
</body>
</html>

validateJS.cgi

#!/opt/x11r6/bin/perl
use CGI qw(:all);

my @valArray = split(/=/,$ENV{QUERY_STRING});

print "Content-type: text/javascript\n\n";

# myPass is the password
$myPass = "foobar";

if ("$valArray[1]" eq "$myPass")
{
print "alert(\"Success!!\")";
}
else
{
print "alert(\"Failure!!\")";
}

--
--
~kaeli~
God was my co-pilot... but then we crashed in the mountains
and I had to eat him.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace