Thank you..I am not familiar with it..is it efficient if the list is a
little too long?
Laila
From: Matthew Woodward <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: onChange=populate()
Date: Thu, 23 Jun 2005 07:19:53 -0500
Without doing a page refresh the only real way to accomplish this is to
pre-load your database information into javascript arrays (using CFWDDX is
probably the slickest way to handle this) and then the rest of the
functionality can be built completely in javascript similar to this:
http://javascriptkit.com/script/script2/multiplecombo.shtml
Matt
On Jun 23, 2005, at 7:10 AM, Laila Oommen wrote:
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
--
Matthew Woodward
[EMAIL PROTECTED]
----------------------------------------------------------
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
