http://www.ashleyit.com/rs/main.htm
jon
----- Original Message -----
From: "han peng" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 1:13 AM
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>
>
>
______________________________________________________________________
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=coldfusiona
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
