Dependent Select (Jquery/Ajax)

Hi all,

I am trying to make a dependent select box that will refresh without a page
load.

Select 1: Countries
Select 2: States/Provinces

I have a db table for countries, and one for states and provinces that are
related to those countries.

When a user selected a country, the second select needs to run a query on
the states and provinces table and populate with appropriate data.

Simple, it seems… but I have searched and searched, and am failing
miserably.

All examples I have seen show using CFSELECT and “bind” to a CFC. But
Lucee doesn’t support BIND in cfselect. So I need a workaround.

If anyone can answer this and show me a solid documented example, rather
than a code snippet, I would be so happy!

Thank you and I am very much looking forward to an answer.

LMGTFY :wink:

Hope that helps.

Aria Media Sagl
+41 (0)76 303 4477 cell
skype: ariamediaOn Tue, Jun 7, 2016 at 8:11 PM, Michael and Paola Kovnick < @Michael_and_Paola_Ko> wrote:

Hi all,

I am trying to make a dependent select box that will refresh without a
page load.

Select 1: Countries
Select 2: States/Provinces

I have a db table for countries, and one for states and provinces that are
related to those countries.

When a user selected a country, the second select needs to run a query on
the states and provinces table and populate with appropriate data.

Simple, it seems… but I have searched and searched, and am failing
miserably.

All examples I have seen show using CFSELECT and “bind” to a CFC. But
Lucee doesn’t support BIND in cfselect. So I need a workaround.

If anyone can answer this and show me a solid documented example, rather
than a code snippet, I would be so happy!

Thank you and I am very much looking forward to an answer.


Win a ticket to dev.objective from Lucee via Twitter, see
http://bit.ly/1UbTMWj for details, good luck and see you there…

You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/60dabc58-9572-41dd-b1e1-1d2697b4db0c%40googlegroups.com
https://groups.google.com/d/msgid/lucee/60dabc58-9572-41dd-b1e1-1d2697b4db0c%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

Yeah, was looking for a CFML example.On Tuesday, June 7, 2016 at 3:12:19 PM UTC-4, Nando Breiter wrote:

LMGTFY :wink:

Dependent Drop-down List in PHP using jQuery AJAX with Country State Example - Phppot

Hope that helps.

Aria Media Sagl
+41 (0)76 303 4477 cell
skype: ariamedia

On Tue, Jun 7, 2016 at 8:11 PM, Michael and Paola Kovnick < regio...@retrouvaille.org <javascript:>> wrote:

Hi all,

I am trying to make a dependent select box that will refresh without a
page load.

Select 1: Countries
Select 2: States/Provinces

I have a db table for countries, and one for states and provinces that
are related to those countries.

When a user selected a country, the second select needs to run a query on
the states and provinces table and populate with appropriate data.

Simple, it seems… but I have searched and searched, and am failing
miserably.

All examples I have seen show using CFSELECT and “bind” to a CFC. But
Lucee doesn’t support BIND in cfselect. So I need a workaround.

If anyone can answer this and show me a solid documented example, rather
than a code snippet, I would be so happy!

Thank you and I am very much looking forward to an answer.


Win a ticket to dev.objective from Lucee via Twitter, see
http://bit.ly/1UbTMWj for details, good luck and see you there…

You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/60dabc58-9572-41dd-b1e1-1d2697b4db0c%40googlegroups.com
https://groups.google.com/d/msgid/lucee/60dabc58-9572-41dd-b1e1-1d2697b4db0c%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.