**Update 2011.12.09 – I’ve posted an Oracle specific version of the Country/State/Province lookup SQL.
Every time I build a contact form/database I hit this problem. I need a set of tables for Country, State/Province lookup. “But, that’s like 60 records and I don’t wanna type out every state and province!”.
Every time, I hit the Google looking for SQL scripts – and I can’t seem to find anything, or I find that one script for mySQL. The last time I did this, I created a set of SQL scripts and I saved them. I forgot that I saved them – and made another SQL script. Doh.
This time when I was working on the new contact form for this site, I decided to write this blog post in hopes that the next time I need to do this – when I search Google my blog might come up and remind me not to re-invent the wheel. So I’ve included a zip with the SQL script here. This script is for SQL server 2005 – but will translate over to Oracle very easily.
If you find any problems with the script, or feel like adding more countries, feel free to pass those changes along to me!
Hello! Welcome back to Geospecialling, and welcome to the new site! This new site has been my existence for the past several weeks– but more on that later.
It’s been a crazy couple of months (since Autodesk University 2008), and we are getting closer to the end of the craziness. Let me sum things up, and hopefully gain your forgiveness for the lack of posts for two months. =) At AU we unveiled FullCircle, and the reception has been phenomenal. FullCircle is our newest product built made with RADE. So after returning from AU, and getting all that feedback from partners and customers we set to work finishin, testing, and polishing the first release of FullCircle – Standard Edition.
FullCircle has two main functions. First, it allows users to login and query data from their Oracle, SQL Server, and Access databases. The tabular information is then sent down as an Excel spreadsheet where users may edit or append data. This spreadsheet can then uploaded to FullCircle and processed. The updates/inserts are applied to the appropriate database table.
The second key function of FullCircle is for Adapx Capturx for Excel users. FullCircle allows Excel forms to be defined and saved. Users can then download the form templates from the repository, print the forms with Capturx, and fill them out. When the digital pen is docked, and the hand writing is processed back into Excel – these Excel files can then be processed with FullCircle. The inserts (or updates if needed) are processed and put into the appropriate database table(s). No temporary tables are used that require processing after the fact (unless of course, this is what you want to do), no custom coding.
On top of that we’ve been hard at work building this new site, setting up the new blogs, doing all that good stuff. I can finally see the light at the end of the tunnel…