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********@mat tkruse.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********@mat tkruse.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 "DynamicOptionL ist()" function?
According to my understanding, this would be the constructor function of the
"DynamicOptionL ist" 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 "DynamicOptionL ist()"
function? According to my understanding, this would be the
constructor function of the "DynamicOptionL ist" object.

In the js file...

// DynamicOptionLi st CONSTRUCTOR
function DynamicOptionLi st()

--
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.javas cript FAQ - http://jibbering.com/faq/

[kaeli]

In article <ca**********@b lsnews.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(variabl e, value)
{
var newScript = "cgi-bin/validateJS.cgi? "+variable+"="+ value;

var body = document.getEle mentsByTagName( 'body').item(0)
var scriptTag = document.getEle mentById('loadS cript');
if(scriptTag) body.removeChil d(scriptTag);
script = document.create Element('script ');
script.src = newScript;
script.type = 'text/javascript';
script.id = 'loadScript';
body.appendChil d(script)
}
</script>
<p>Test.</p>
<form id="f1" action="">
<input type="text" name="t1" id="t1" onChange="check It(this.name,
this.value)">
</body>
</html>

validateJS.cgi

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

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

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

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

if ("$valArray[1]" eq "$myPass")
{
print "alert(\"Succes s!!\")";
}
else
{
print "alert(\"Failur e!!\")";
}

--
--
~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