No need to go to this extent ... there's a custom tag on the devex called TwoSelectsRelated that does it without a round trip ... Or you can write it yourself in JS with grouped output... You just have to make sure that you have all the data on the form page, which of course has the potential to slow the page down considerably, dependant upon how much data is being returned. In most cases it's not enough to create a significant problem tho.
Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > One old "trick" is to have a "hidden" (one pixel high) > frame at the top or > bottom of your screen. This frame can then be used for > return trips to the > server and the user sees nothing. The invisible Frame does > the server work > and refreshes itself (invisibly). Then you can use > cross-window Javascript > to access the new information from the visible frame. > 8/23/02 2:59 PM, "Ali Daniali" <[EMAIL PROTECTED]> wrote: >> is there a simple way of doing this without having to >> refresh the page? >> >> thanks, >> ali >> >> -----Original Message----- >> From: anand.vadul [mailto:[EMAIL PROTECTED]] >> Sent: Friday, August 23, 2002 2:49 PM >> To: CF-Talk >> Subject: RE: dynamic select boxes based on queries? >> >> >> You need to use javascript to submit the form >> as soon as the first dropdown box is changed. >> >> This will call a CF file that regenerates the same page >> It reads the first, gets the selection, and populates the >> the second dropdown box having the results based on >> selection >> of the first. >> >> HTH >> >> Anand >> >> -----Original Message----- >> From: Ali Daniali [mailto:[EMAIL PROTECTED]] >> Sent: Friday, August 23, 2002 5:40 PM >> To: CF-Talk >> Subject: dynamic select boxes based on queries? >> >> >> Hello, >> I was wondering if someone might know how I might be able >> to create a >> drop down select box list from a previous dynamically >> populated drop >> down select box selection. The second list's options are >> query results >> of the first selection. >> >> Thanks, >> Ali Daniali >> >> >> >> > __________________________________________________________ > ____________ > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
