client-side here.
If you want a filtered query, you have to reload the form passing a
parameter. You could also load aal the data in the _javascript_ and do
evrything in JS.
> -----Original Message-----
> From: John Ho [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 1 juni 2004 20:17
> To: CF-Talk
> Subject: _javascript_ Onchange() function?
>
> Hi all
> 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]
