Code is a drop down pick list field..When one of the codes from the list is
selected, I want the other two fields to be populated using the
corresponding values in the database.
Actually, I am looking for an easy javascript coding to get this
accomplished.
Laila
From: Anthony Frey <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: onChange=populate()
Date: Wed, 22 Jun 2005 08:21:42 -0700 (PDT)
http://www.webpasties.com/xmlHttpRequest/xmlHttpRequest_tutorial_1.html
--- Laila Oommen <[EMAIL PROTECTED]> wrote:
> Has any one got a script to make this work?
>
> When the code is selected, I want the city and the
> state to be populated
> with values from database.
>
>
> <script language="javascript">
> function populate()
> </script>
>
> <tr>
> <td>CODE</td>
> <td colspan="2">
> <select name="code" onChange=populate()>
> <option selected>Select one</option>
> <cfquery name="getvalues">
> SELECT DISTINCT code
> FROM tblRegion
> </cfquery>
> <cfoutput query="code">
> <option value="">#code#</option>
> </cfoutput>
> </select>
> </td>
> </tr>
> <tr>
> <td>CITY</td>
> <td><input type="text" name="city"></td>
> </tr>
> <tr>
> <td>STATE</td>
> <td><input type="text" name="state"></td>
> </tr>
>
> Thanks
>
> Laila
>
>
>
----------------------------------------------------------
> To post, send email to [email protected]
> To unsubscribe:
> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
> To subscribe:
>
> http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>
Anthony C. Frey
214-529-1507
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
