CB Field - Select Country

I'm trying to integrate CB fields with a shopping cart so that existing users can purchase product without having to re-enter their address details etc. in the checkout fields. The cart requires a user's Country and State/Province to apply tax rules. I have created a State/Province single select drop down as there are only 7 states, however I was wondering if there is a plugin or another way to create a Country select dropdown that lists every country, or do I have to add every individual country as a value?

Best way to have a CBSubs compatible country dropdown field is to use CBSubs own countries database table and build a select field from it using CB Query Field. The below should work.

Field Type: Query Drop Down (Single Select)
Query: Value Column: country_iso_code2
Label Column: country_name
Group Column: country_region

I have tried adding this field, but I get an error message when I publish the field and try to edit a user in user manager:

An error has occurred.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `country_iso_code2`, `country_name`, country_region FROM `j17_comprofile' at line 1 SQL=SELECT `country_iso_code2`, `country_name`, country_region FROM `j17_comprofiler_countries` WHERE `country_region` != '' ORDER BY `country_region`, `country_name`


Can you please advise if I have the config correct in the following screenshots..

That doesn't make any sense. There's nothing wrong with the syntax. Directly copy and paste from the textarea above to the Query input and it should work fine as long as CBSubs Tax has been installed, which provides the geolocation tables.

In another topic it was discovered the below usage is needed if you want it to synchronize with CBSubs invoice address though.

Field Type: Query Drop Down (Single Select)
Query: Value Column: country_name
Label Column: country_name
Group Column: country_region

Thanks krileon

Not sure what happened. CBSubs Tax was already installed. I re-pasted the syntax (and double checked to make sure it was identical to what I had originally pasted) re-saved and it now magically displays the Country field in user edit without any error message!!! Perhaps I'd left a space/linebreak in the syntax...

Is there another field/syntax I have to use for selecting a State/Province? The Country field is displayed, but once a country is selected there are no region groups showing:
Group Column = country_region

Is this what is meant to happen?

The region is just used as the optgroup. You don't get to select a region in it. The optgroup will display as bold text in the dropdown with its countries below it.