How do I write a _javascript_ with a query base on value
the users select from drop down select list.
For example user select IP = �123.124.135.225� and I
do a query of this IP address and display all the
fields to the same form which user select the ip. I
code is something like this
<SCRIPT LANGUAGE="_javascript_" TYPE="text/_javascript_">
function IP_OnChange()
{
with ( document.Form ) {
<cfquery datasource="CCSDataSource"
name="getrecord">
SELECT SA, ORG
FROM table
WHERE IP = P_IP.value;
</cfquery>
<cfoutput query = "getrecord">
P_IP.value = "#IP_vale#";
P_ORG.value = =
"#getrecord.ORG#";
���.
���.
P_ SA.value = "#getrecord.primary_SA#";
</cfoutput>
}
}
</script>
<table>
<tr><td align="right">IP Address</td>
<td><select name="P_IP" > <option value="0" ></option>
<cfoutput query="GetIP"><option
value="#GetIP.IP#">#GetIP.IP#</option></cfoutput>
</select></td></tr>
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
