That <select should have another option at the very beginning with something like '- - Select something - -' its myArray[0]
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 6:03 PM To: CF-Talk Subject: RE: I don't know if this is even possible Not a whole lot of options if you cant use httprequests. I don't know a lot about working with government sites but without refreshing the page with a form submit or something.... you're going to have to have some JS (which is really all 'ajax' is) How big would all of the possible queries be if they were combined? if not very big, they could be stored in JS arrays with initial queries when the page loads and used from there to update the other fields. Something along these lines... <!--- put them into an array ---> var myArray = new Array(); myArray[0] = ''; <cfloop query="myquery"> myArray[#currentrow#] = '#myColumn#'; </cfloop> <!-- same query to populate the dropdown ---> <select name="mySelect" onchange="myJSFunction(this.selectedIndex);"> <cfloop query="myquery"> <option value="#A_Value_Column#">#A_Display_Column#</option> </cfloop> <!--- JS function to change the vlaue of some field ---> function myJSFunction(selIndex) { Somefield.value = myArray[document.forms[0].mySelect.selectedIndex]; } ...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 5:47 PM To: CF-Talk Subject: RE: I don't know if this is even possible Yeah, but I'm working on a US Gov't site, Ajax isn't 508 compliant. sas Scott A. Stewart ColdFusion Developer GNSI 11820 Parklawn Dr Rockville, MD 20852 (301) 770-9610 -----Original Message----- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 5:42 PM To: CF-Talk Subject: RE: I don't know if this is even possible Sure, it's possible. It's called Ajax: http://www.ajaxian.com/ http://www.cfajax.com/ http://www.robgonda.com/blog/projects/ajaxcfc/ > -----Original Message----- > From: Scott Stewart [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 10, 2006 3:35 PM > To: CF-Talk > Subject: I don't know if this is even possible > > But here goes. > > > > I have a text field and a hidden field that I want to > populate based on a > dropdown. Here's the trick, once the value of the dropdown is > passed, I want > the > > Hidden field and the text field to be based on queried values. > > > > Meaning: in the step between the drop down value being > selected and the text > and input boxes being populated I want to run a query and > populate the text > and input boxes based on the query results. > > > > Thanks > > > > sas > > > > Scott A. Stewart > > Webmaster/Developer > > > > > > 11820 Parklawn Dr > > Rockville, MD 20852 > > (301) 770-9610 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229109 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
