thanx ppl!! problem solved! but hmm.. anyone know how to hide the popup.. under the parent page.. so that the user dun even know theres a pop up to generate it...??!!
HAPPY MAN, han ----- Original Message ----- From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 28, 2002 1:29 AM Subject: RE: which is the best way to do auto retrieval of Address... > 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> > > > > > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
