|
|
|
Re:How to populate a CB Field with a Country List
|
|
Date: 2007/02/20 11:02
|
By: joseph
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 12 |   |
|
|
heymcd wrote:
The attached SQL contains the entire list of 70+ states, provinces and territories recognized by the US and Canadian postal services.
The list has been formatted so that US values are the top values, then a seperator, then the Canadian values.
Create your custom cb_state field.
Replace the 'YY' with your table pre-fix, replace the 'XX' with your fieldid.
Tested successfully using phpMyAdmin 2.8.1 against a mySQL 5.0.18 database.
All the best, Bill.
Can 'XX' any number that doesnt showed in my tables? Or any standar rules?
And how's when all goin wrong? Can I back to before insert it?
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:How to populate a CB Field with a Country List
|
|
Date: 2007/02/20 11:25
|
By: joseph
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 12 | |
|
|
heymcd wrote:
The attached SQL contains the entire list of 70+ states, provinces and territories recognized by the US and Canadian postal services.
The list has been formatted so that US values are the top values, then a seperator, then the Canadian values.
Create your custom cb_state field.
Replace the 'YY' with your table pre-fix, replace the 'XX' with your fieldid.
Tested successfully using phpMyAdmin 2.8.1 against a mySQL 5.0.18 database.
All the best, Bill.
Can 'XX' any number that doesnt showed in my tables? Or any standar rules?
And how's when all goin wrong? Can I back to before insert it?
|
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:How to populate a CB Field with a Country List
|
|
Date: 2007/02/20 11:28
|
By: joseph
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 12 | |
|
|
heymcd wrote:
The attached SQL contains the entire list of 70+ states, provinces and territories recognized by the US and Canadian postal services.
The list has been formatted so that US values are the top values, then a seperator, then the Canadian values.
Create your custom cb_state field.
Replace the 'YY' with your table pre-fix, replace the 'XX' with your fieldid.
Tested successfully using phpMyAdmin 2.8.1 against a mySQL 5.0.18 database.
All the best, Bill.
Can 'XX' any number that doesnt showed in my tables? Or any standar rules?
And how's when all goin wrong? Can I back to before insert it?
|
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:How to populate a CB Field with a Country List
|
|
Date: 2007/03/03 09:41
|
By: moomola
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 17 | |
|
|
Hi there,
I see this thread a bit late but as this is a field I know; the official and standard list of country and territory codes is available here:
http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/index.html
This is iso 3166 list
Best
|
|
|
The administrator has disabled public write access. |
|
|
|
|
Re:How to populate a CB Field with a Country List
|
|
Date: 2007/04/13 15:44
|
By: spacewalk
|
Status: User
|
|
|
Karma: 2
|
|
Fresh Joomlapolitan
| Posts: 15 | |
|
|
In case you use it, the original downloadable list of U.S. states here (from the original Joomlapolis tutorial) contains an error: both Nevada and New Hampshire are #28.
Post edited by: spacewalk, at: 2007/04/13 16:27
|
|
|
The administrator has disabled public write access. |
|
 |
|
Re:How to populate a CB Field with a Country List
|
|
Date: 2007/05/17 05:27
|
By: dartagnan
|
Status: User
|
|
|
Karma: -1
|
|
Junior Joomlapolitan
| Posts: 46 | |
|
|
Hi guys,
I am wondering something, I recently made the countrylist population and it worked fine. But now everything is messed up for countrylist and for statelist. I think it is after I made some tests with the cb advanced search and performing "update of search fields", but I am not sure...
Anyway what happens is that the order is completely wrong. However, when I go to the database, everything is still in the same order....
Any idea where it may come from?
thanks
Planet Asia Asian tradition culture and community
|
|
|
The administrator has disabled public write access. |
|
|
