http://www.artenscience.co.uk/artenscience/Blog/files/r10cipherv2openbeta.html
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Saturday, 17 January 2009
R10Cipher V2 Open Beta - Cross Platform Encryption for Text and Files
Thursday, 15 January 2009
Wrong macVCR Versions on MacWorld DVD ?
It seems that some of the DVD’s supplied with the February 2009 version of MacWorld magazine do not contain the free version of macVCR, Version 1.2. You can check for this from the About window. The About window for the correct version will look like this:
If your About window is different then you do not have the correct version. I apologise for this, but it is entirely out of my control. You can obtain the correct version from here:
http://www.artenscience.com/autoupdate/latestversions/macvcr1.2.zip
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Wednesday, 14 January 2009
Arten Science Looking for Bloggers / Reviewers / Journalists
Arten Science is looking for bloggers, reviewers and journalists. Anyone who is willing to write and publish a review of any of our software. Free licenses and a press kit are available. See here for more details:
http://www.artenscience.co.uk/artenscience/Pages/Press.html
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
macVCR 1.2 from Arten Science Free with MacWorld Magazine
My product macVCR, version 1.2 can be obtained for Free with the latest edition of MacWorld Magazize (UK). For More Details:
http://www.artenscience.co.uk/artenscience/Blog/files/macvcrfreemacworld.html
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Arten Science Google Adwords Experiment
Over on my Company blog I have written about our first Google Adwords experiment:
http://www.artenscience.co.uk/artenscience/Blog/Blog.html
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Tuesday, 13 January 2009
SQL Country Codes and Names Import Script for ArtenSUITE
If you are creating a database or website and need to populate a table with the Country Codes and Names then the following may be of use to you. I created this this morning for ArtenSUITE. Feel free to copy and modify this code. BAS_CHO_CCRY is the table name and the words prefixed with CRY_ are the column names.
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AF','Afghanistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AX','Aland Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AL','Albania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DZ','Algeria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AS','American Samoa',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AD','Andorra',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AO','Angola',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AI','Anguilla',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AQ','Antarctica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AG','Antigua and Barbuda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AR','Argentina',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AM','Armenia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AW','Aruba',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AU','Australia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AT','Austria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AZ','Azerbaijan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BS','Bahamas',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BH','Bahrain',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BD','Bangladesh',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BB','Barbados',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BY','Belarus',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BE','Belgium',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BZ','Belize',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BJ','Benin',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BM','Bermuda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BT','Bhutan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BO','Bolivia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BA','Bosnia and Herzegovina',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BW','Botswana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BV','Bouvet Island',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BR','Brazil',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IO','British Indian Ocean Territory',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BN','Brunei Darussalam',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BG','Bulgaria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BF','Burkina Faso',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BI','Burundi',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KH','Cambodia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CM','Cameroon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CA','Canada',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CV','Cape Verde',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KY','Cayman Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CF','Central African Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TD','Chad',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CL','Chile',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CN','China',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CX','Christmas Island',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CC','Cocos (Keeling) Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CO','Colombia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KM','Comoros',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CG','Congo',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CD','Congo, The Democratic Republic of the',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CK','Cook Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CR','Costa Rica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CI','Côte DIvoire',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HR','Croatia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CU','Cuba',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CY','Cyprus',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CZ','Czech Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DK','Denmark',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DJ','Djibouti',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DM','Dominica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DO','Dominican Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EC','Ecuador',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EG','Egypt',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SV','El Salvador',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GQ','Equatorial Guinea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ER','Eritrea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EE','Estonia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ET','Ethiopia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FK','Falkland Islands (Malvinas)',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FO','Faroe Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FJ','Fiji',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FI','Finland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FR','France',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GF','French Guiana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PF','French Polynesia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TF','French Southern Territories',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GA','Gabon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GM','Gambia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GE','Georgia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DE','Germany',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GH','Ghana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GI','Gibraltar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GR','Greece',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GL','Greenland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GD','Grenada',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GP','Guadeloupe',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GU','Guam',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GT','Guatemala',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GG','Guernsey',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GN','Guinea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GW','Guinea-Bissau',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GY','Guyana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HT','Haiti',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HM','Heard Island and McDonald Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VA','Holy See (Vatican City State)',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HN','Honduras',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HK','Hong Kong',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HU','Hungary',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IS','Iceland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IN','India',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ID','Indonesia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IR','Iran, Islamic Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IQ','Iraq',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IE','Ireland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IM','Isle of Man',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IL','Israel',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IT','Italy',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JM','Jamaica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JP','Japan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JE','Jersey',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JO','Jordan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KZ','Kazakhstan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KE','Kenya',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KI','Kiribati',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KP','Korea, Democratic Peoples Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KR','Korea, Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KW','Kuwait',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KG','Kyrgyzstan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LA','Lao Peoples Democratic Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LV','Latvia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LB','Lebanon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LS','Lesotho',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LR','Liberia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LY','Libyan Arab Jamahiriya',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LI','Liechtenstein',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LT','Lithuania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LU','Luxembourg',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MO','Macao',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MK','Macedonia, The Former Yugoslav Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MG','Madagascar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MW','Malawi',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MY','Malaysia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MV','Maldives',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ML','Mali',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MT','Malta',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MH','Marshall Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MQ','Martinique',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MR','Mauritania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MU','Mauritius',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('YT','Mayotte',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MX','Mexico',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FM','Micronesia, Federated States of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MD','Moldova, Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MC','Monaco',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MN','Mongolia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ME','Montenegro',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MS','Montserrat',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MA','Morocco',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MZ','Mozambique',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MM','Myanmar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NA','Namibia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NR','Nauru',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NP','Nepal',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NL','Netherlands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AN','Netherlands Antilles',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NC','New Caledonia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NZ','New Zealand',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NI','Nicaragua',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NE','Niger',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NG','Nigeria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NU','Niue',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NF','Norfolk Island',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MP','Northern Mariana Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NO','Norway',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('OM','Oman',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PK','Pakistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PW','Palau',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PS','Palestinian Territory, Occupied',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PA','Panama',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PG','Papua New Guinea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PY','Paraguay',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PE','Peru',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PH','Philippines',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PN','Pitcairn',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PL','Poland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PT','Portugal',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PR','Puerto Rico',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('QA','Qatar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RE','Reunion',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RO','Romania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RU','Russian Federation',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RW','Rwanda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BL','Saint Barthélemy',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SH','Saint Helena',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KN','Saint Kitts and Nevis',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LC','Saint Lucia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MF','Saint Martin',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PM','Saint Pierre and Miquelon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VC','Saint Vincent and the Grenadines',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('WS','Samoa',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SM','San Marino',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ST','Sao Tome and Principe',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SA','Saudi Arabia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SN','Senegal',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RS','Serbia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SC','Seychelles',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SL','Sierra Leone',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SG','Singapore',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SK','Slovakia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SI','Slovenia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SB','Solomon Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SO','Somalia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ZA','South Africa',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GS','South Georgia and the South Sandwich Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ES','Spain',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LK','Sri Lanka',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SD','Sudan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SR','Suriname',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SJ','Svalbard and Jan Mayen',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SZ','Swaziland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SE','Sweden',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CH','Switzerland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SY','Syrian Arab Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TW','Taiwan, Province Of China',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TJ','Tajikistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TZ','Tanzania, United Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TH','Thailand',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TL','Timor-Leste',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TG','Togo',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TK','Tokelau',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TO','Tonga',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TT','Trinidad and Tobago',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TN','Tunisia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TR','Turkey',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TM','Turkmenistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TC','Turks and Caicos Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TV','Tuvalu',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UG','Uganda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UA','Ukraine',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AE','United Arab Emirates',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GB','United Kingdom',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('US','United States',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UM','United States Minor Outlying Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UY','Uruguay',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UZ','Uzbekistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VU','Vanuatu',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VE','Venezuela',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VN','Viet Nam',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VG','Virgin Islands, British',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VI','Virgin Islands, U.S.',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('WF','Wallis And Futuna',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EH','Western Sahara',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('YE','Yemen',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ZM','Zambia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ZW','Zimbabwe',1,1,1);
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Thursday, 8 January 2009
Arten Science Using Paypal on our Website
I've just written an article on the Arten Science blog about how to use Paypal for purchasing software from our website.
http://www.artenscience.co.uk/artenscience/Blog/files/usingpaypalwithartenscience.html
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Wednesday, 7 January 2009
Top 100 Twitter Users in Derbyshire. Number 6 :-)
I'm number 6 in the top 100 Twitter users in Derbyshire, UK
www.twitter.com/stevechol
Errrr ... so what ?
But I suppose it's nice to be in the Top 10 :-)
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Arten Science New Website Live and Kicking :-)
Today I uploaded the new website for Arten Science. It was a big job to do as I have limited graphical skills, but I know what I like and I now have a website that in my opinion is clean and unfussy. Minimal even. As you can probably tell I am quite pleased with it. It is not 100% finished yet but most of the content is there.
The obvious answer would have been to hire a designer to do my website but I guess I am somewhat of a control freak and I can get it done much faster on my own and I am comfortable that I can go in when needed and edit the content or anything else without affecting anything.
A screenshot of my homepage is shown below, even better - go visit: www.artenscience.co.uk
I made the transition from iWeb to Rapidweaver as a web development tool and I am so pleased I did. While Rapidweaver takes slightly longer (couple of hours) to get used to it is far far more powerful than iWeb. It plays nicely with SEO and HTML without jumping through hoops. iWeb is great to get you started but you WILL outgrow it.
I also made the decision to switch from the Kagi Store to having PayPal 'Buy Now' buttons against each product. This looks better, works quicker, costs me less and I believe will be easier for my customers. Time will tell.
For the first time Arten Science has a blog with a proper RSS feed :-) http://feeds.feedburner.com/ArtenScienceRssFeed Subscribe now to be kept up to date with new products and updates to existing products.
www.artenscience.co.uk
Quality Commercial Software and Custom Software Development
Sunday, 4 January 2009
Arten Science New Website Design
I'm working on a new website design for Arten Science.
The New (very much a work in progress) site is here:
http://www.artenscience.com/artenscience/Home.html
The original site is here:
http://www.artenscience.co.uk/artenscience/Home.html
I think the new design is much better, less cluttered and cleaner.
Any thoughts ?
www.artenscience.co.uk
Commercial and Custom Software Development