Thread: Country Code
View Single Post
  #2 (permalink)  
Old June 2nd, 2008, 20:29
neoandr neoandr is offline
Member
 
Join Date: Oct 2007
Posts: 45
Thanks: 2
Thanked 3 Times in 3 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
neoandr is on a distinguished road
Re: Country Code

To all the screen, i worked on, Country code refers to country_code3_gid. I dont think, personally, that its possible to populate country_code2 value.

But still I can provide 2 workarounds.

1. Need to create country codes with 2 letter code. Simple as that.

Otherwise

2. You need to modify related XSL for display purpose alone. That is, u can modify 'Picklist' format to 'Dropdown' format and then display psuedo values with 2 letter codes which is actually mapped with 3 letter country codes by placing the following code in XSL dropdown template where the country_code3_gid is referred to.

<options>
<option name='PK' value='PAK'>PK</option>
<option name='US' value='USA'>US</option>
</options>

Hope this helps.
But there should be some reason country_code2_gid still exist in table even though code3 value is used.

Please do let us know if you find any direct solution for you issue.

Cheers!
Reply With Quote