I have used the three select related tag and agreed it works quite well,
nate has done a good job.
However there is a lot of code bloat with that tag i.e. there is a lot of
javascript product that you do not use, and the control you have over the
page is not as great as if the webtricks version had 3 selects as you can
see exactly what is going on.
Also with the three selects tag you need 3 seperate tables to speicfy each
select value, where as the other approach will let you get away with 1 table
which is what I have to work with.
----- Original Message -----
From: "Hatton Humphrey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 3:28 PM
Subject: Re: Please help me achieve this with CF and Javascrip please
> I posted a link to the Three Selects Related tag. It does the same
> thing that you are looking for. Perhaps you might try downloading it
> and reading through the code of the tag to find the answer to your
question.
>
> Hatton
>
> Ian Vaughan wrote:
>
> >Hi
> >
> >I think you will find it is more difficult then you may think...
> >
> >I am using the sample code from webtricks.com. Their default is two
> >selects - what I need to find out is where to add javascript and
coldfusion
> >to build arrays for the third select box
> >
> >This is the actual code for two selects, need to find out how to build in
> >the extra logic to get three selects working on the same approach as
below?
> >
> >This is where I am having trouble.... and would appreciate some help
please
> >
> ><script language = "JavaScript">
> ><!--
> >// For each state, create an array to hold the area codes.
> >// Each state array will be identified by the two-character state
> >abbreviation
> ><cfoutput query="GetStates" group="State">
> > // Create the array
> > StateArray#StateCode# = new Array();
> > <cfset i = 0>
> > // Populate the array
> > <cfoutput>
> > <cfset i = i + 1>
> > StateArray#StateCode#[#i#] = #AreaCode#;
> > </cfoutput>
> ></cfoutput>
> >
> >// Function to populate the area codes for the state selected
> >function PopulateAreaCode() {
> > // Only process the function if the first item is not selected.
> > if (document.StateForm.StateCode.selectedIndex != 0) {
> > // Find the state abbreviation
> > var ThisState =
>
>document.StateForm.StateCode[document.StateForm.StateCode.selectedIndex].va
l
> >ue;
> > // Set the length of the arecode drop down equal to the length of
the
> >state's array
> > document.StateForm.AreaCode.length = eval("StateArray" + ThisState
+
> >".length");
> > // Put 'Select' as the first option in the area code drop-down
> > document.StateForm.AreaCode[0].value = "";
> > document.StateForm.AreaCode[0].text = "Select";
> > document.StateForm.AreaCode[0].selected = true;
> > // Loop through the state's array and populate the area code drop
> >down.
> > for (i=1; i<eval("StateArray" + ThisState + ".length"); i++) {
> > document.StateForm.AreaCode[i].value = eval("StateArray" +
> >ThisState + "[i]");
> > document.StateForm.AreaCode[i].text = eval("StateArray" +
ThisState
> >+ "[i]");
> > }
> > }
> >}
> >//-->
> ></script>
> >
> >
> >
> >
> >
> >----- Original Message -----
> >From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Thursday, December 05, 2002 2:08 PM
> >Subject: RE: Please help me achieve this with CF and Javascrip please
> >
> >
> >
> >
> >>It really shouldn't be difficult at all... what problems are you running
> >>into? have you got some semi-working code at all?
> >>
> >>-----Original Message-----
> >>From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> >>Sent: 05 December 2002 14:08
> >>To: CF-Talk
> >>Subject: Re: Please help me achieve this with CF and Javascrip please
> >>
> >>
> >>Just wondering if anybody else could shed some light on if this can
> >>
> >>
> >actually
> >
> >
> >>be accomplished??
> >>
> >>There must be a way of adding a third select dynamically to this code? I
> >>have been looking into it all morning with no success as of yet, but
would
> >>be interesting to hear views from the experienced professional
coldfusion
> >>and javascript developers on the list
> >>
> >>
> >>----- Original Message -----
> >>From: "Bob Haroche" <[EMAIL PROTECTED]>
> >>To: "CF-Talk" <[EMAIL PROTECTED]>
> >>Sent: Wednesday, December 04, 2002 4:23 PM
> >>Subject: Re: Please help me achieve this with CF and Coldfusion please
> >>
> >>
> >>
> >>
> >>>>I am using a piece of code for 2 related selects shown below. I would
> >>>>
> >>>>
> >>like
> >>
> >>
> >>>>to add a third select field and have this generated dynamically from a
> >>>>database using Coldfusion like the other two selects shown below.
> >>>>
> >>>>
> >>>Nate Weiss has a custom tag called Three Related Selects or something
> >>>similar on the MM Exchange.
> >>>
> >>>Re the script you posted, I've used that one to create a modified
> >>>
> >>>
> >version
> >
> >
> >>of
> >>
> >>
> >>>three related selects. In my case, I needed both selects 2 and 3
> >>>
> >>>
> >>(populated
> >>
> >>
> >>>with the same values) to change when select 1 was chosen. In my case
> >>>
> >>>
> >>select
> >>
> >>
> >>>3 wasn't controlled by select 2 but was also controlled by select 1.
The
> >>>situation was that user chooses "Animal Type" (select 1) and then
> >>>
> >>>
> >selects
> >
> >
> >>>"Primary Breed" (select 2) and "Secondary Breed" (select 3). Let me
know
> >>>
> >>>
> >>if
> >>
> >>
> >>>you're interested in that type of code.
> >>>
> >>>---------------
> >>>Regards,
> >>>Bob Haroche
> >>>O n P o i n t S o l u t i o n s
> >>>www.OnPointSolutions.com
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
