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


Reply via email to