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
