This is a known issue(I think). I posted the same problem and someone provided a customized version of it.
Let me track it down. 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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
