Some of you sent some good suggestions for my request..I was gone on vacation..and somehow lost them...Can you plea....ase resend it?

Laila

--- Laila Oommen <[EMAIL PROTECTED]> wrote:

> Has any one got a script to make this work?
>
> When the code is selected (using a dropdown selection box), 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


Reply via email to