Correction to code below... <CF_TwoSelectsRelated QUERY="QryGetCityStates" NAME1="SearchSTATE" NAME2="SearchCity" DISPLAY1="STATE" DISPLAY2="City" VALUE1="STATE" VALUE2="City" FORCEWIDTH1="70" FORCEWIDTH2="70" AUTOSELECTFIRST="No" HTMLBETWEEN="<BR>" FORMNAME="FormX">
Thanks! Rick Eidson Partner & CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -----Original Message----- From: Rick [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 9:57 AM To: CF-Talk Subject: Two Selects Does the two selects related tag not work in CFMX? Dropdown one has the correct info but when I select an item nothing happens in select two. <form action="index.cfm?t=results" method="post" name="FormX"> <cfquery datasource="#App_DataSource#" name="QryGetCityStates" username="#App_DataBaseUser#" password="#App_DataBasePass#"> SELECT DISTINCT STATE, City FROM TblMain WHERE State <> '' ORDER BY State </cfquery> <CF_TwoSelectsRelated QUERY="QryGetCityStates" NAME1="form.STATE" NAME2="form.City" DISPLAY1="STATE" DISPLAY2="City" VALUE1="STATE" VALUE2="City" FORCEWIDTH1="70" FORCEWIDTH2="70" AUTOSELECTFIRST="No" HTMLBETWEEN="<BR>" FORMNAME="FormX"> ...... </form> Nothing has been changed in the TwoSelectsRelated.cfm file. Rick Eidson Partner & CTO ArcRiver Technology, LLC http://www.arcriver.com/ Local Kansas City Music http://www.kcjukebox.com/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
