matthewdavey wrote: Ok I dont get it? please explane your tutorial
I also had some issues getting country data for this tutorial:
www.joomlapolis.com/support/tutorials/10...b-query-field-plugin
that's why I posted my own sql file in the tutorial.
and as I said can you please explane
Import has been successfully finished, 258 queries executed.
what does the 258 queries executed mean? is the 258 queries the country's imported from
www.geonames.org
externally ?
The sql file executed 258 SQL statements to create and populate the country_info table in your database.
Not sure what more explanation you need here.
It does not connect to the geonames.org site.
The country_info.sql does it connect to
www.geonames.org
externally and look up its database or is it copied to mine?
If you execute the query from your phpmyadmin script with your joomla database selected, it will create and populate a country_info table in your joomla database.
How can I get CB Query field plugin to connect to
www.geonames.org
and get the post codes of Australia or towns of Australia is that possible?
I do not think geonames.org provides such a service - so I cannot help you here.
Can I edit country_info.sql to display the hole country name instead of au ?
Thanks
You can edit the sql file if you want (and if you are SQL literate) or you can just use phpmyadmin directly on the new country_info table that you have in your database after executing the original sql script.
But you should really study the table as it has the full country name in the table.
I am assuming now that your question refers to the value that is stored in your CB field.
Please read the tutorial again and specifically this line 6:
Set the 'Value Column' parameter to iso (this way the 2 character iso code will be stored in the CB database) or you can optionally put country here (if you want the full country name to be stored)
nant
