4 Related Select Boxes

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

4 Related Select Boxes

Andy Mcshane
Does anybody know of the exisitance of a CF Custom tag or a javascript snipet that will allow the creation of 4 related select boxes? I have seen tags and scripts for 2 & 3 related boxes but I do not think that my  javascript knowledge is up to the task of expanding those, neither do I really have the time to try. Any help would be greatly appreciated.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase Captivate from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=52

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1769
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

RE: 4 Related Select Boxes

Mike Tangorre
> From: Andy Mcshane [mailto:[hidden email]]
> Does anybody know of the exisitance of a CF Custom tag or a
> javascript snipet that will allow the creation of 4 related
> select boxes? I have seen tags and scripts for 2 & 3 related
> boxes but I do not think that my  javascript knowledge is up
> to the task of expanding those, neither do I really have the
> time to try. Any help would be greatly appreciated.

Andy,

qForms can handle this quite easily. Head over to
http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm and
check out the examples. The example is for 3 selects related but I have
adapted it to 4 and even 5 selects related without problem... The code is
pretty straightforward but if you need a hand, drop me a line offlist and I
will shoot you over some code.

HTH,

Mike



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1770
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

Re: 4 Related Select Boxes

Andy Mcshane
Thanks for your reply Mike, I will go and take a look at qforms right now!

>
> Andy,
>
> qForms can handle this quite easily. Head over to
> http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm 
> and
> check out the examples. The example is for 3 selects related but I have
> adapted it to 4 and even 5 selects related without problem... The code is
> pretty straightforward but if you need a hand, drop me a line offlist and
> I
> will shoot you over some code.
>
> HTH,
>
> Mike
>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how to get a fax number that sends and receives faxes using your current email address
http://www.houseoffusion.com/banners/view.cfm?bannerid=64

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1771
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

RE: 4 Related Select Boxes

Tangorre, Michael
In reply to this post by Andy Mcshane
> From: Andy McShane [mailto:[hidden email]]
> Thanks for your reply Mike, I will go and take a look at
> qforms right now!

Sounds good! If this is your first time checking out qForms I think you
will be very impressed with the functionality it offers as well as the
complexities it abstracts (especially if you aren't a huge JS fan). Dan
Switzer did an excellent job and continues to build on it (I think
version 2.0 is in beta.. or coming out soon).

Mike

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1772
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

Re: 4 Related Select Boxes

Andy Mcshane
Well I must say it does look good but I cannot for the life of me find a
tutorial on setting up multiple related select boxes, am I missing something
here?


----- Original Message -----
From: "Tangorre, Michael" <[hidden email]>
To: "Javascript" <[hidden email]>
Sent: Monday, August 01, 2005 12:03 PM
Subject: RE: 4 Related Select Boxes


>> From: Andy McShane [mailto:[hidden email]]
>> Thanks for your reply Mike, I will go and take a look at
>> qforms right now!
>
> Sounds good! If this is your first time checking out qForms I think you
> will be very impressed with the functionality it offers as well as the
> complexities it abstracts (especially if you aren't a huge JS fan). Dan
> Switzer did an excellent job and continues to build on it (I think
> version 2.0 is in beta.. or coming out soon).
>
> Mike
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1773
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

RE: 4 Related Select Boxes

Tangorre, Michael
In reply to this post by Andy Mcshane
> From: Andy McShane [mailto:[hidden email]]
> Well I must say it does look good but I cannot for the life
> of me find a tutorial on setting up multiple related select
> boxes, am I missing something here?

You have to look at the code in Dan's example and determine how to get
the appropriate output using queries, etc for your usage.
If you are on AIM, IM me: mtangorre

Mike

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the mailserver that powers this list at
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1774
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

Re: 4 Related Select Boxes

Andy Mcshane
OK, thanks. I will take a look at the examples, see if my javascript blind
brain can figure it out. If I still get stuck I will install AIM and give
you a shout.

----- Original Message -----
From: "Tangorre, Michael" <[hidden email]>
To: "Javascript" <[hidden email]>
Sent: Monday, August 01, 2005 2:05 PM
Subject: RE: 4 Related Select Boxes


>> From: Andy McShane [mailto:[hidden email]]
>> Well I must say it does look good but I cannot for the life
>> of me find a tutorial on setting up multiple related select
>> boxes, am I missing something here?
>
> You have to look at the code in Dan's example and determine how to get
> the appropriate output using queries, etc for your usage.
> If you are on AIM, IM me: mtangorre
>
> Mike
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1775
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

Re: 4 Related Select Boxes

Andy Mcshane
In reply to this post by Tangorre, Michael
Hi Mike, I have been told at work that I cannot install AIM so I will have
to rely on this list for now. I have managed to get my data loaded but I can
only get 2 of my four select boxes to populate. This is really starting to
frustrate me, I was wondering if you post a code snipet on how you managed
to implement this?

Here is a little of what I have been trying to do.

<script src="/lib/qforms.js"></script>
</cfstoredproc>
 <SCRIPT LANGUAGE="JavaScript">
 <!--//
 // set the path to the qForms directory
 qFormAPI.setLibraryPath("/lib/");
 // this loads all the default libraries
 qFormAPI.include("*");
 // this is the default struct to use for the blank options to prefix
 // when populating a select box
 stcBlank = new Object();
 stcBlank[""] = " ";

 // create a structure to store all the team information in
 stcTeams = new Object();

 stcTeams = new Object();

  stcTeams["5"] = new Object();

   stcTeams["5"]["34"] = "Albania";
   stcTeams["5, 34"] = new Object();

    stcTeams["5, 34"]["203"] = "International";
    stcTeams["5, 34, 203"] = new Object();

     stcTeams["5, 34, 203"]["1814"] = "Senior";

     stcTeams["5, 34, 203"]["1954"] = "U21";

     stcTeams["5, 34, 203"]["1815"] = "U19";

     stcTeams["5, 34, 203"]["2844"] = "U17";

    stcTeams["5, 34"]["101"] = "Kategoria Superiore";
    stcTeams["5, 34, 101"] = new Object();

     stcTeams["5, 34, 101"]["2205"] = "Dinamo Tiran?";

     stcTeams["5, 34, 101"]["4583"] = "Egnatia Rrogozhin?";

     stcTeams["5, 34, 101"]["4584"] = "Elbasani";

     stcTeams["5, 34, 101"]["4585"] = "La?i";

     stcTeams["5, 34, 101"]["2443"] = "Lushnja";

     stcTeams["5, 34, 101"]["1029"] = "Partizani Tiran?";

     stcTeams["5, 34, 101"]["2444"] = "Shkumbini Peqin";

     stcTeams["5, 34, 101"]["2445"] = "Teuta Durr?s";

     stcTeams["5, 34, 101"]["2446"] = "Tirana";

     stcTeams["5, 34, 101"]["2448"] = "Vllaznia Shkod?r";

   stcTeams["5"]["138"] = "Armenia";
   stcTeams["5, 138"] = new Object();

    stcTeams["5, 138"]["302"] = "International";
    stcTeams["5, 138, 302"] = new Object();

     stcTeams["5, 138, 302"]["2096"] = "Senior";

     stcTeams["5, 138, 302"]["2577"] = "U21";

     stcTeams["5, 138, 302"]["2733"] = "U19";

     stcTeams["5, 138, 302"]["2794"] = "U17";
 // this example shows how you could pre-populate the form
 function setDefault(){
  objForm.Region.setValue("1");
  objForm.Country.setValue("1");
  objForm.Division.setValue("1");
 }
 //-->
 </SCRIPT>

<FORM ACTION="##" METHOD="POST" NAME="frmExample">
<P><B>Select a Region</B><BR>
<SELECT NAME="Region" STYLE="width: 200px;"
onChange="objForm.Country.populate(stcTeams[objForm.Region.getValue()],
null, null, stcBlank);">
 <OPTION VALUE=""></OPTION>
  <OPTION VALUE="5">Europe Non-EU</OPTION>
</SELECT></P>

<P><B>Select a country</B><BR>
<SELECT NAME="Country" STYLE="width: 200px;"
onChange="objForm.Division.populate(stcTeams[objForm.Region.getValue() + ','
+ objForm.Country.getValue()], null, null, stcBlank);">
<!----<SELECT NAME="Country" STYLE="width: 200px;"
onChange="alert([objForm.Region.getValue() + ',' +
objForm.Country.getValue()]);">---->
 <OPTION VALUE="">&nbsp;</OPTION>
</SELECT></P>

<P><B>Select a Division:</B><BR>
<SELECT NAME="Division" STYLE="width: 200px;"
onChange="objForm.Division.populate(stcTeams[objForm.Region.getValue() + ','
+ objForm.Country.getValue() + ',' + objForm.Division.getValue()], null,
null, stcBlank);">
 <!---// insert blank entries for Netscape //--->
 <OPTION VALUE="">&nbsp;</OPTION>
</SELECT></P>

<P><B>Select a Club:</B><BR>
<SELECT NAME="Club" STYLE="width: 200px;">
 <!---// insert blank entries for Netscape //--->
 <OPTION VALUE="">&nbsp;</OPTION>
</SELECT></P>


<P>
<INPUT TYPE="Submit" VALUE="Submit">
<INPUT TYPE="Reset">
<INPUT TYPE="Button" VALUE="Set Default" onClick="setDefault()">
</P>

</FORM>

<SCRIPT LANGUAGE="JavaScript1.1">
  // initialize the qForm object
  objForm = new qForm("frmExample");

  // make these fields required
  objForm.required("Region,Country,Division");
</script>


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1776
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Reply | Threaded
Open this post in threaded view
|

Re: 4 Related Select Boxes

invader zim
In reply to this post by Andy Mcshane
> Does anybody know of the exisitance of a CF Custom tag or a javascript
> snipet that will allow the creation of 4 related select boxes? I have
> seen tags and scripts for 2 & 3 related boxes but I do not think that
> my  javascript knowledge is up to the task of expanding those, neither
> do I really have the time to try. Any help would be greatly
> appreciated.
If you're still looking - try out iRelate @ www.cfitools.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:33:1969
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/33
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:33
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.33
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54