Select combobox Region ==> City

[viki1967]

Hi everyone.

Help with this problem.

With Google I found this script:

 
var regiondb = new Object()
regiondb["Assente"] = [{value:"Ferie", text:"Ferie"},
                      {value:"Festività abolita", text:"Festività abolita"},
                      {value:"Malattia", text:"Malattia"},
                      {value:"Infortunio", text:"Infortunio"},
                      {value:"Riposo Fisiologico", text:"Riposo Fisiologico"},
                      {value:"Riposo Compensativo", text:"Riposo"},
                      {value:"Permesso retribuito", text:"Permesso"},
                      {value:"Permesso Sind./ARCA", text:"Permesso Sind."},
                      {value:"Ricovero Ospedaliero", text:"Ricovero"},
                      {value:"Part-time", text:"Part-time"},
                      {value:"Assemblea Sindacale", text:"Assemblea"},
                      {value:"Sciopero", text:"Sciopero"},
                      {value:"Aspettativa", text:"Aspettativa"},
                      {value:"Carica Pubblica", text:"Carica Pubblica"},
                      {value:"Da giustificare", text:"Da giustificare"}];
 
regiondb["Presente"] = [{value:"Monoperatore", text:"Monoperatore"},
                        {value:"Coppia", text:"Coppia"},
                        {value:"Formazione a tre", text:"Formazione a tre"},
                        {value:"Appoggio", text:"Appoggio"},
                        {value:"Fuori sede", text:"Fuori sede"},
                        {value:"In sede", text:"In sede"}];
 
 
function setCities(chooser) {
    var newElem;
    var where = (navigator.appName == "Microsoft Internet Explorer") ? -1 : null;
    var cityChooser = chooser.form.elements["tipo_stato_giornaliero"];
    while (cityChooser.options.length) {
        cityChooser.remove(0);
    }
    var choice = chooser.options[chooser.selectedIndex].value;
    var db = regiondb[choice];
    newElem = document.createElement("option");
    newElem.text = "Seleziona valore";
    newElem.value = "";
    cityChooser.add(newElem, where);
    if (choice != "") {
        for (var i = 0; i < db.length; i++) {
            newElem = document.createElement("option");
            newElem.text = db[ i ].text;
            newElem.value = db[ i ].value;
            cityChooser.add(newElem, where);
        }
    }
 
 

I change this way:

Have a variable ( associated with the selected value from select Choose a Region ), which can be A or B.

I select the value Presente ( variable A ) from select Choose a Region :

1) When the variable is A, in select Choose a City is:

 
<option value="Fuori Sede">Fuori Sede</option>
<option value="In Sede">In Sede</option>
 

I select the value Presente ( variable B ) from select Choose a Region :

2) When the variable is B in select Choose a City is:

 
<option value="Coppia">Coppia</option>
<option value="Formazione a tre">Formazione a tre</option>
<option value="Appoggio">Appoggio</option>
<option value="Fuori Sede">Fuori Sede</option>
<option value="In Sede">In Sede</option>
 

Is possible?

Regards,
Viki

[acoder]

Oh, I see! I thought you wanted to get rid of the alert for "Presente".

The reason why you don't see the alert for Assente is that it's defined. To get around that, either create duplicates AssenteA and AssenteB and get rid of Assente, then change the code to add regionVar to 'choice' all the time (not just with "Presente"), OR (for an easier and probably better solution) rather than check that db is defined, just check that regionVar is not empty.

[viki1967]

Oh, I see! I thought you wanted to get rid of the alert for "Presente".

The reason why you don't see the alert for Assente is that it's defined. To get around that, either create duplicates AssenteA and AssenteB and get rid of Assente, then change the code to add regionVar to 'choice' all the time (not just with "Presente"), OR (for an easier and probably better solution) rather than check that db is defined, just check that regionVar is not empty.

Ok, i write:

[php]
var regionVar = "";
var reg = document.getElementById("reg");
for (i=0; i < reg.options.length; i++) {
if (reg.options[i].selected) {
regionVar = reg.options[i].value.split("-")[0];
break;
}
}

var choice = chooser.options[chooser.selectedIndex].value;

if (choice == "Presente") choice += regionVar;
var db = regiondb[choice];

if(regionVar != null) {
alert('KO');
return;
}
[/php]

But the regionVar is ever null....

[acoder]

Not null, empty:

if (regionVar != "") {

[viki1967]

Not null, empty:

if (regionVar != "") {

Not work, try it :

http://www.complessobandisticopalomb...967/select.asp

[acoder]

Sorry, that should be the other way round:

if (regionVar == "") {

[viki1967]

Sorry, that should be the other way round:

if (regionVar == "") {

Many thanks Acoder....

[php]
if(regionVar == "") {
alert('KO');
location.href="select.asp"
return;
}
[/php]

I hope close now.... thanks...

[acoder]

Many thanks Acoder....

You're welcome again!

[php]
if(regionVar == "") {
alert('KO');
location.href="select.asp"
return;
}
[/php]

Why reload the page?

I hope close now.

Probably not, LOL!

[viki1967]

You're welcome again!

Why reload the page?


Probably not, LOL!

Because I do not this effect:

http://www.complessobandisticopalomb...67/select2.asp

[acoder]

Then you do away with that by adding the option first before making the regionVar check:

newElem = document.createElement("option");
    newElem.text = "Seleziona valore";
    newElem.value = "";
    cityChooser.add(newElem, where);

[viki1967]

Then you do away with that by adding the option first before making the regionVar check:

newElem = document.createElement("option");
    newElem.text = "Seleziona valore";
    newElem.value = "";
    cityChooser.add(newElem, where);

sorry, i do not understand your data...

[acoder]

Swap that code and the regionVar check around:

var regionVar = "";
var reg = document.getElementById("reg");
for (i=0; i < reg.options.length; i++) {
    if (reg.options[i].selected) {
        regionVar = reg.options[i].value.split("-")[0];
        break;
    }
}
 
    var choice = chooser.options[chooser.selectedIndex].value;
 
    if (choice == "Presente") choice += regionVar;
    var db = regiondb[choice];
 
    newElem = document.createElement("option");
    newElem.text = "Seleziona valore";
    newElem.value = "";
    cityChooser.add(newElem, where);
 
    if (regionVar == "") {
      alert("KO");
      return;
    }
 
    if (choice != "" && regionVar != "")
 

[viki1967]

Thanks again Acoder !!!!

[acoder]

You're welcome yet again!

[viki1967]

You're welcome yet again!

Hi my friend Acoder.... I still... :-)

It is possible when you invoke the page select.asp have this situation ?

You explain:

1) in the select name="SelectMultipla" preselected first value of the list ( in this example = DVD );

2) in the select name="stato_dipendente" preselected value Presente;

3) in the select name="stato_dipendente" values Fuori sede and In sede;

Thanks for your help...
viki

[acoder]

1) in the select name="SelectMultipla" preselected first value of the list ( in this example = DVD );

2) in the select name="stato_dipendente" preselected value Presente;

3) in the select name="stato_dipendente" values Fuori sede and In sede;

No need for JavaScript, though you could use JavaScript too.

Just add selected to the options that need preselecting:

<option value="A-DVD" selected>DVD</option>

For the third select, just put the options in the HTML code.

[viki1967]

No need for JavaScript, though you could use JavaScript too.

Just add selected to the options that need preselecting:

<option value="A-DVD" selected>DVD</option>

For the third select, just put the options in the HTML code.

Thanks, i have:

[php]

<select size="8" id="reg" name="SelectMultipla" multiple="multiple">

<option>Select</option>
<option value="A-DVD" selected>DVD</option>
<option value="A-DVDR">DVDR</option>
<option value="B-CDR">CDR</option>
<option value="B-CD">CD</option>

</select>


<select name="stato_dipendente" onchange="setCities(this)">
<option>Seleziona stato giornaliero</option>
<option value="Assente">Assente</option>
<option value="Presente" selected>Presente</option>
</select></td>

<select name="tipo_stato_giornaliero">
<option>Seleziona tipo stato giornaliero</option>
</select>


[/php]


But the third select is empty.... not values In sede and Fuori sede...

http://www.complessobandisticopalomb...67/select2.asp

[acoder]

Yes, add them yourself in the HTML:

<select name="tipo_stato_giornaliero">
    <option>Seleziona tipo stato giornaliero</option>
    <option>In sede</option>
    <option>Fuori sede</option>
</select>

[viki1967]

Yes, add them yourself in the HTML:

<select name="tipo_stato_giornaliero">
    <option>Seleziona tipo stato giornaliero</option>
    <option>In sede</option>
    <option>Fuori sede</option>
</select>

Many thanks again... again mi friend Acoder... ;-)

[acoder]

Glad to help!

[viki1967]

Glad to help!

This is historic post with many answers... is unique post with many answers ?

[acoder]

It has a number of different threads of discussion relating to the same problem, so yeah, maybe unique in that respect, but some threads in the Access forum are pretty long with many contributors.

Hope others find it useful too.

[viki1967]

It has a number of different threads of discussion relating to the same problem, so yeah, maybe unique in that respect, but some threads in the Access forum are pretty long with many contributors.

Hope others find it useful too.

You are welcome and I'am very happy to found this Community !!!

[acoder]

Glad to hear it.

I think we'll leave it there, otherwise this thread could become a lot longer than it already is ;)