[SOLVED] Query fields dependancy question (country - state)

Registration process. No user yet.

Table name "country_info"


2 Fields:

a) cb_country
We use this query: SELECT DISTINCT `country` FROM `country_info` ORDER BY country
Everything shows fine! No problem to select the country.


b) cb_state
Here we need to show all states of the selected country in the previous field. So we try like this:
SELECT DISTINCT `state` FROM `country_info` WHERE `country` = '[cb_country]' ORDER BY state
No way...
The pull down field is empty.

If we change the (`country` = '[cb_country]') part of the query with (`country` = 'Andorra') for example... the field works and shows the Andorra states. So we believe that there is something wrong with the '[cb_country]' part.


Can you please advise?

Thank you in advance...

You need to have CB Core Fields Ajax installed then under Integrations > CB Core Fields Ajax of your State field select your Country field for Update On. This will cause the state field to refresh when Country changes and will result in your substitution working based off your current selected country.

Forgive me i forgot to mention.

CB Core Fields Ajax is already installed and set but the result is no choices inside the states pull down menu.

Is this during profile edit or registration? frontend or backend? Ensure CB Core Fields Ajax it self is public and published in CB > Plugin Management. Ensure within CB > Configuration > User Profile that "Profile View Access Level" is set to something your users can actually access as it can block ajax endpoints. You should see a loader icon appear next to the State field when your change the value of your Country field.

Is this during profile edit or registration? frontend or backend?

Registration, Frontend

Ensure CB Core Fields Ajax it self is public and published in CB > Plugin Management.

Published and public!

Ensure within CB > Configuration > User Profile that "Profile View Access Level" is set to something your users can actually access as it can block ajax endpoints.

We are talking about the Registration process. No profile yet to have "Profile View Access Level"

You should see a loader icon appear next to the State field when your change the value of your Country field.

No... no loader shows when changing Country field.

What i see is this...
Before country select...


After country select...

Please PM backend super administrator login credentials and will take a look. Some reason the jQuery is failing to function or load to perform the ajax call.