The reusethecube part allows you to use the three selects related multiple
times on the same page.
This tag was developed by
Len Bucchino for WorkArea.com
weblinc.com
If you use it, be sure to thank him.
I've cut and pasted my call to it, let me know if you need any help.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education & Training Professional
Development & Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
>>-----Original Message-----
>>From: Stephen Cassady [mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, July 25, 2002 12:21 PM
>>To: CF-Talk
>>Subject: CF_ThreeSelectsRelated : Difficulty when using Default Values
>>
>>I am experiencing some difficulty with the CF_ThreeSelectsRelated when
>>utilizing the DEFAULT1,2,3 values. I was wondering if there are any
>>common mistakes I could be making with the setup that would result in
>>the following problem:
>>
>>
>>
>>When populating with DEFAULT values:
>>
>>The First Box: acts fine
>>
>>The Second Box:
>>Won't refresh third box correctly
>>
>>The Third Box:
>>Lists the choices for the First box's set, not the set chosen.
>>
>>
>>
>>
>>
>>EXAMPLE:
>>
>>
>>(Data Set)
>>--- Not Selected --- --- n/a --- n/a 3 64 7
>>Canada Alberta Calgary 1 11 1
>>Canada Alberta Edmonton 1 11 2
>>Canada Ontario Toronto 1 5 3
>>Canada Ontario Ottawa 1 5 4
>>USA California Los Angeles2 18 5
>>USA New York New York 2 47 6
>>
>>
>>
>>(Query)
>>
>>SELECT RegionCountry.CountryName, RegionState.StateName,
>>RegionCity.CityName, RegionCountry.RegionCountryID,
>>RegionState.RegionStateID,
>> RegionCity.RegionCityID
>>FROM RegionCountry LEFT OUTER JOIN
>> RegionState ON RegionCountry.RegionCountryID =
>>RegionState.RegionCountryID LEFT OUTER JOIN
>> RegionCity ON RegionState.RegionStateID =
>>RegionCity.RegionStateID
>>WHERE (RegionCountry.Active = '1') AND (RegionState.Active = '1')
>>AND (RegionCity.Active = '1')
>>ORDER BY RegionCountry.CountryName
>>
>>
>>
>>
>>
>>What I select:
>>[picture lost in plain text]
>>
>>
>>What I get on Default:
>>[picture lost in plain text]
>>
>>As you can see, the use of the site with out a default works correctly!
>>Canada, Ontario, and Choice of Toronto and Ottawa. But if I prepopulate
>>for those values, the system actually defaults to Canada � Ontario �
>>Calgary!
>>
>>Do you have any suggestions?
>>Thank you for your time.
>>
>>
>>Stephen R. Cassady
>>[EMAIL PROTECTED]
>>http://www.lopedia.com
>>
>>
>>
>>
>>
>><CFIF isDefined("form.formresponse")>
>> <CF_ThreeSelectsRelated
>> QUERY="q_threeLocations"
>> HTMLAFTER1="<BR>"
>> HTMLAFTER2="<BR>"
>> NAME1="country"
>> NAME2="state"
>> NAME3="city"
>> VALUE1="RegionCountryID"
>> VALUE2="RegionStateID"
>> VALUE3="RegionCityID"
>> DISPLAY1="CountryName"
>> DISPLAY2="StateName"
>> DISPLAY3="CityName"
>> DEFAULT1="#form.country#"
>> DEFAULT2="#form.state#"
>> DEFAULT3="#form.city#"
>> SIZE1="1"
>> SIZE2="1"
>> SIZE3="1"
>> AUTOSELECTFIRST="YES"
>> MULTIPLE3="No"
>>FORCEWIDTH1=""
>>FORCEWIDTH2=""
>>FORCEWIDTH3=""
>>FormName="addnewtarget">
>>
>>
>>
>><CFELSE>
>>
>> <CF_ThreeSelectsRelated
>> QUERY="q_threeLocations"
>> HTMLAFTER1="<BR>"
>> HTMLAFTER2="<BR>"
>> NAME1="country"
>> NAME2="state"
>> NAME3="city"
>> VALUE1="RegionCountryID"
>> VALUE2="RegionStateID"
>> VALUE3="RegionCityID"
>> DISPLAY1="CountryName"
>> DISPLAY2="StateName"
>> DISPLAY3="CityName"
>> DEFAULT1="3"
>> SIZE1="1"
>> SIZE2="1"
>> SIZE3="1"
>> AUTOSELECTFIRST="YEs"
>> MULTIPLE3="No"
>>FORCEWIDTH1=""
>>FORCEWIDTH2=""
>>FORCEWIDTH3=""
>>FormName="addnewtarget">
>>
>></CFIF>
>>
>>
>>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>>Archives: http://www.mail-archive.com/[email protected]/
>>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
______________________________________________________________________
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
