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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
