Yes you could do that, in the onchange paramater of the select box have it popup a new window.
Do the query in that new window, then user the following javascript. <script> opener.formname.streetname = 'qry.StreetName'; opener.formname.city = 'qry.City'; </script> If the form isn't named, and you only have 1 form on your page, you can use opener.forms[0].streetname Although this will cause a popup to show and disappear, I think a better way would be to just navigate to the same page with ?zip=12345 at the end of it. You'd have to cfparam all of your form fields this way, like <cfparam name="thisform.FirstName" default=""> Then in the form, <input type="text" name="FirstName" value="#thisform.FirstName#"> At the top of the page you'd need to do something like. <cfif isDefined(FORM.postalcode)> <cfset thisform = StructCopy(FORM)> </cfif> That will copy everything submitted through the form into the thisform structure, so if they filled out half of the form before selecting a postal code, it will load it all in the form. _____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:19 AM To: CF-Talk Subject: Re: which is the best way to do auto retrieval of Address... hmm.. are u saying... upon selected a postal code.. i callup a popup page which will perform a cfquery and do a matching... then pass back the matched value back to parent?? can I do that..?? if can... how shld i pass the value to and fro child and parent page...?? cheers han ----- Original Message ----- From: "Robert Obreczarek" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 2:44 PM Subject: RE: which is the best way to do auto retrieval of Address... > How about using frames? maybe an iframe/ilayer. that way > you could click on a name, and the info would pop in a another frame > > Robert > > -----Original Message----- > From: han peng [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 26, 2002 10:13 PM > To: CF-Talk > Subject: which is the best way to do auto retrieval of Address... > > > hi... i need to do a address input fields.. > where customer can choose their postal code.. and > his house number and streetname will be retrieved out automatically... > the codes below actually can do the work.. but because theres about > 100,000 data to be put into array...so it took almost like a minute to > load a page.... > sigh... > > anyone have a better idea.? > i did it this way coz customer wan to retrieve the data instantly.. > > > thanx > han > > > > > Javascript function: > > function display_Street(box1, box2) > { > var TotalStreetArray = box2.length; > for(i=0; i<TotalStreetArray; i++) > { > if(box2[i][0] == box1) > { > document.form.strStreetName.value = box2[i][1]; > document.form.strBlockNumber.value = box2[i][2]; > } > } > } > > > > > <!--- Database Queries ---> > <CFQUERY name="PostalCode_list" datasource="#request.DSN#" > cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#"> > SELECT a.strPostalCode, a.strBlockNumber, b.strStreetName > From tblPostalCode a, tblStreet b > WHERE a.strStreetNumber = b.strStreetNumber > ORDER BY a.strPostalCode > </CFQUERY> > > <cfset StreetName_array = arraynew(2)> > <CFSET i =1> > <CFLOOP query="PostalCode_list"> > <cfset StreetName_array[i][1] = "#trim(strPostalCode)#"> > <cfset StreetName_array[i][2] = "#trim(strStreetName)#"> > <cfset StreetName_array[i][3] = "#trim(strBlockNumber)#"> > <CFSET i = i + 1> > </CFLOOP> > <CFWDDX INPUT="#StreetName_array#" OUTPUT="MyWDDXPacket" > ACTION="CFML2WDDX"> > <CFWDDX INPUT="#MyWDDXPacket#" OUTPUT="DynamicJSCode" > ACTION="WDDX2JS" TOPLEVELVARIABLE="StreetName_array"> > <script><cfoutput>#DynamicJSCode#</cfoutput></script> > > > > <table width="100%" border="0" cellspan=0> > <tr> > <td width="5%">BLK/HSE NO.</td> > <td width="25%"><cfinput type="text" > name="strBlockNumber" size="5" maxlength="5" message="Please > enter your Block / House Number." required="Yes" onerror="setFocus" > value="#session.prospect.strBlockNumber#"></td> > <td width="5%">FLR.</td> > <td width="25%"><cfinput type="text" > name="strFloorNumber" size="5" maxlength="5" message="Please > enter your Floor Number." required="No" > value="#session.prospect.strFloorNumber#"></td> > <td width="5%">UNIT</td> > <td width="25%"><cfinput type="text" > name="strUnitNumber" size="5" maxlength="5" message="Please > enter your Unit Number." required="No" > value="#session.prospect.strUnitNumber#"></td> > <td width="5%"> </td> > <td width="5%"> </td> > </tr> > <tr> > <td>ST</td> > <td colspan =3><cfinput type="text" > name="strStreetName" size="50" maxlength="50" message="Please > enter your Street Name." required="Yes" onerror="setFocus" > value="#session.prospect.strStreetName#"></td> > <td>BLDG</td> > <td colspan =3><cfinput type="text" > name="strBuildingName" size="50" maxlength="50" message="Please > enter your Building Name." required="No" > value="#session.prospect.strBuildingName#"></td> > </tr> > <tr> > <td>PD</td> > <td><cfSELECT name="strPostalName" > display="strPostalCode" value="strPostalCode" > query="postalCode_list" size="1" message="Please choose your > Postal Code." required="Yes" > onerror="setFocus" Selected="#session.prospect.strPostalName#" > onChange="display_Street(this.options[this.selectedIndex].value, > StreetName_array);"></CFSELECT></td> > <td>TYPE</td> > <td><cfselect name="strAddressType" message="Please > enter your Housing Type." required="Yes" onerror="setFocus" > Selected="#session.prospect.strAddressType#" size="1"> > <option value="A" <cfif #session.prospect.strAddressType# eq > 'A'>SELECTED</cfif>>A</option> > <option value="B" <cfif #session.prospect.strAddressType# eq > 'B'>SELECTED</cfif>>B</option> > </cfselect></td> > <td> </td> > <td> </td> > <td> </td> > <td> </td> > </tr> > </table> > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
