Description:
cannot run in MySQL 3.23.52 that query:
SELECT *
FROM (store_shopping_cart_items INNER JOIN ((store_order_items INNER JOIN (store_editorial_products INNER JOIN (store_products INNER JOIN (store_editorial_categories INNER JOIN store_categories ON
store_editorial_categories.category_id = store_categories.category_id) ON
store_products.category_id = store_categories.category_id AND store_editorial_products.editorial_cat_id = store_editorial_categories.category_id) ON
store_editorial_products.product_id = store_products.product_id) ON
store_order_items.product_id = store_products.product_id) INNER JOIN (store_orders INNER JOIN store_statuses ON
store_orders.order_status_id = store_statuses.status_id) ON
store_order_items.order_id = store_orders.order_id) ON
store_shopping_cart_items.product_id = store_products.product_id) INNER JOIN store_shopping_carts ON
store_shopping_cart_items.shopping_cart_id = store_shopping_carts.shopping_cart_id
but i can run in MySQL 4.0.15 my ISP use exactly MySQL 3.23.52 only and admins cannot want use MySQL 4.0.15.
Tell me please what's wrong?
How to repeat:
#
# DROP TABLES
#
DROP TABLE IF EXISTS ages;
DROP TABLE IF EXISTS articles;
DROP TABLE IF EXISTS countries;
DROP TABLE IF EXISTS directory_categories;
DROP TABLE IF EXISTS directory_items;
DROP TABLE IF EXISTS educations;
DROP TABLE IF EXISTS events;
DROP TABLE IF EXISTS event_categories;
DROP TABLE IF EXISTS forum_messages;
DROP TABLE IF EXISTS genders;
DROP TABLE IF EXISTS incomes;
DROP TABLE IF EXISTS languages;
DROP TABLE IF EXISTS links;
DROP TABLE IF EXISTS link_categories;
DROP TABLE IF EXISTS news;
DROP TABLE IF EXISTS officers;
DROP TABLE IF EXISTS smiles;
DROP TABLE IF EXISTS states;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS user_groups;
DROP TABLE IF EXISTS store_categories;
DROP TABLE IF EXISTS store_editorial_categories;
DROP TABLE IF EXISTS store_editorial_products;
DROP TABLE IF EXISTS store_order_items;
DROP TABLE IF EXISTS store_orders;
DROP TABLE IF EXISTS store_products;
DROP TABLE IF EXISTS store_shopping_cart_items;
DROP TABLE IF EXISTS store_shopping_carts;
DROP TABLE IF EXISTS store_statuses;
#
# CREATE TABLES
#
CREATE TABLE ages (
age_id integer auto_increment primary key,
age_name varchar(50) null
);
CREATE TABLE articles (
article_id integer auto_increment primary key,
article_title varchar(50) null,
category_id integer null,
article_desc text null,
date_add datetime null,
date_end datetime null
);
CREATE TABLE countries (
country_id integer auto_increment primary key,
country_name varchar(50) null
);
CREATE TABLE directory_categories (
category_id integer auto_increment primary key,
category_name varchar(50) null,
category_id_parent integer null
);
CREATE TABLE directory_items (
item_id integer auto_increment primary key,
item_name varchar(50) null,
address varchar(50) null,
city varchar(50) null,
phone varchar(50) null,
state_id integer null,
zip varchar(50) null,
category_id integer null,
note text null,
email varchar(50) null,
url varchar(50) null
);
CREATE TABLE educations (
education_id integer auto_increment primary key,
education_name varchar(50) null
);
CREATE TABLE event_categories (
category_id integer auto_increment primary key,
category_name varchar(50) null
);
CREATE TABLE events (
event_id integer auto_increment primary key,
category_id integer null,
is_approve integer null,
user_id_approve_by integer null,
date_add datetime null,
date_start datetime null,
date_end datetime null,
event_name text null,
event_desc text null,
presenter varchar(50) null,
location text null,
location_url varchar(50) null,
image_url varchar(50) null,
fee varchar(50) null,
user_id_add integer null
);
CREATE TABLE forum_messages (
message_id integer auto_increment primary key,
message_id_parent integer null,
message_title varchar(50) null,
author varchar(50) null,
message_desc text null,
date_add datetime null,
date_update datetime null,
smile_id integer null
);
CREATE TABLE genders (
gender_id integer auto_increment primary key,
gender_name varchar(50) null
);
CREATE TABLE incomes (
income_id integer auto_increment primary key,
income_name varchar(50) null
);
CREATE TABLE languages (
language_id integer auto_increment primary key,
language_name varchar(50) null
);
CREATE TABLE link_categories (
category_id integer auto_increment primary key,
category_name varchar(50) not null,
category_id_parent integer null
);
CREATE TABLE links (
link_id integer auto_increment primary key,
category_id integer not null,
link_name varchar(50) not null,
link_url varchar(50) not null,
link_desc text null,
address text null,
user_id_add_by integer null,
date_add datetime null,
date_approve datetime null,
date_update datetime null,
is_approve integer null,
user_id_approve_by integer null
);
CREATE TABLE news (
news_id integer auto_increment primary key,
news_desc text null
);
CREATE TABLE officers (
officer_id integer auto_increment primary key,
officer_name varchar(50) not null,
officer_position varchar(50) null,
officer_email varchar(50) null
);
CREATE TABLE smiles (
smile_id integer primary key,
smile_name varchar(50) null,
smile_url varchar(50) null
);
CREATE TABLE states (
state_id integer auto_increment primary key,
state_name varchar(50) null
);
CREATE TABLE users (
user_id integer auto_increment primary key,
user_login varchar(50) null,
user_password varchar(50) null,
first_name varchar(50) null,
last_name varchar(50) null,
title varchar(50) null,
group_id integer null,
phone_home varchar(50) null,
phone_work varchar(50) null,
phone_day varchar(50) null,
phone_cell varchar(50) null,
phone_evening varchar(50) null,
fax varchar(50) null,
email varchar(50) null,
notes text null,
card_number varchar(50) null,
card_expire_date varchar(50) null,
country_id integer null,
state_id integer null,
city varchar(50) null,
zip varchar(50) null,
address1 varchar(50) null,
address2 varchar(50) null,
address3 varchar(50) null,
date_add datetime null,
date_last_login datetime null,
ip_add varchar(50) null,
ip_update varchar(50) null,
language_id integer null,
image_url varchar(50) null,
age_id integer null,
gender_id integer null,
education_id integer null,
income_id integer null,
user_SSN varchar(50) NULL
);
CREATE TABLE user_groups (
group_id integer primary key,
group_name varchar(50) null
);
###
# CREATE STORE TABLES
###
CREATE TABLE store_categories (
category_id integer auto_increment primary key,
category_name varchar(50) NOT NULL
) ;
CREATE TABLE store_editorial_categories (
category_id integer auto_increment primary key,
category_name varchar(50) NULL
);
CREATE TABLE store_editorial_products (
article_id integer auto_increment primary key,
editorial_cat_id integer NULL ,
article_title varchar(200) NULL ,
article_desc text NULL ,
product_id integer NULL
);
CREATE TABLE store_order_items (
order_item_id integer auto_increment primary key,
order_id integer NULL ,
product_id integer NULL ,
quantity integer NULL ,
price real NULL
);
CREATE TABLE store_orders (
order_id integer auto_increment primary key,
user_id int NULL ,
order_date datetime NULL,
order_status_id integer NOT NULL,
total real NULL
);
CREATE TABLE store_products (
product_id integer auto_increment primary key,
category_id integer NOT NULL,
product_name varchar(255) NOT NULL,
price float NOT NULL,
image_url varchar(100) NULL,
description text NULL,
is_recommended integer NULL
);
CREATE TABLE store_shopping_cart_items (
shopping_cart_item_id integer auto_increment primary key,
shopping_cart_id integer NULL ,
product_id integer NULL ,
quantity integer NULL
);
CREATE TABLE store_shopping_carts (
shopping_cart_id integer auto_increment primary key,
date_add datetime NULL
);
CREATE TABLE store_statuses (
status_id integer auto_increment primary key,
status_name varchar(50) NULL
);
#
# TABLE INSERT STATEMENTS
#
INSERT INTO ages(age_id,age_name) VALUES(1,'less than 13');
INSERT INTO ages(age_id,age_name) VALUES(2,'13-17');
INSERT INTO ages(age_id,age_name) VALUES(3,'18-24');
INSERT INTO ages(age_id,age_name) VALUES(4,'25-34');
INSERT INTO ages(age_id,age_name) VALUES(5,'35-50');
INSERT INTO ages(age_id,age_name) VALUES(6,'51-65');
INSERT INTO ages(age_id,age_name) VALUES(7,'over 65');
INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end)
VALUES(1,'Silicon Valley Engineers Club',6,'<font color=\"navy\"><b>Silicon Valley Engineers Club is a technical and social organization. Our members are mostly, but not exclusively residing in the greater San Francisco Bay Area.</b></font><br>
The Engineers'' Club has offices at the 215 South 16th Street in San Francisco. The Club office is manned four days a week by a volunteer staff. James Morton is the Executive Director and President. He is also the elected Secretary and Treasurer. Tom McDonald joined James at the office in 1991 and heads the education committee.','2000-12-26 00:00:00','2010-12-31 00:00:00');
INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end)
VALUES(2,'A brief history',7,'The Centennial Exposition of 1876 in San Francisco drew engineers from around the world to view the technical advances of that century. It was apparent to engineers residing in California that engineers did not know each other. Charles E. Billin invited twenty or so engineers to his home the following winter for refreshments. This started a series of gatherings at the homes of various engineers. The Club formally organized in December of 1877 and Professor L M. Haupt was its first President. It limited its membership to fifty. The minutes of the first meeting stated: \"Its object shall be the professional improvement of its members, the encouragement of social intercourse among men of practical science, and the advancement of engineering in its several branches.\" The Club adopted as its motto a quotation from George Washington''s speech to the Federal Convention of 1787 accepting the role of president. It expresses the charge placed upon the Engineers Club''s members by its charter. The motto states: \"Let us raise a standard to which the wise and honest can repair.\"','2000-12-26 00:00:00','2010-12-31 00:00:00');
INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end)
VALUES(3,'Education',4,'The Silicon Valley Engineers Club is offering courses which meet the needs of many practicing professionals.
In today''s rapidly changing world, it is mandatory that we maintain our skills. One effective and enjoyable way to accomplish this goal is the educational program offered by the Engineers Club. We can exchange ideas, share experiences and learn from experts in various fields. You can receive 20 hours of instruction for less than you would commonly pay for a one day seminar. One evening a week means that you do not have to take valuable time from the job, nor need you make great personal sacrifices to enhance your career.
Make the commitment now to invest in your professional development.','2000-12-26 00:00:00','2010-12-31 00:00:00');
INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end)
VALUES(4,'Tours of Silicon Valley',3,'Engineering Tours of the Silicon Valley are visits to facilities and sites with a wide variety of technical features to stimulate your interest. They are geared to you, the technical professional.
Attend one or more tours. Club membership is not required! You will be impressed by the knowledge and friendliness of the hosts. They are there for you!
WHO CAN PARTICIPATE? Anyone.
CAN I BRING A GUEST? Yes.
DO I HAVE TO BE AN ENGINEERS CLUB MEMBER? No.
WHAT DOES IT COST? Each tour is $10.00 per person. However, Engineers'' Club members and one guest may attend at no charge.
WHO PROVIDES TRANSPORTATION TO THE FACILITY? You do.','2000-12-26 00:00:00','2010-12-31 00:00:00');
INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end)
VALUES(5,'Benefits',5,'<ul>
<li>Career Enhancement - A place to meet others in your profession, share ideas and make valuable contacts.</li>
<li>Professional development programs, symposiums, and speeches.</li>
<li>Seminars, technical presentations, topical meetings with discounts on fees to members.</li>
<li>Meetings facilities including 400 seat auditorium, library and meetings rooms.</li>
<li>Engineers'' Club annual roster.</li>
<li>Silicon Valley Engineer monthly newsletter.</li>
</ul>','2000-12-26 00:00:00','2010-12-31 00:00:00');
INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end)
VALUES(6,'Membership',7,'The requirements for becoming a member are liberal although applicants are carefully screened for sincerity of interests and whether or not they could benefits from Club membership. The qualifications are only that the applicant be associated with the engineering profession as a result of vocation, hobby or business contact. Each applicant must have two sponsors who are members of the Club.
Membership in the Engineers'' Club of St. Louis is one of the best investments a technical man or woman can make.','2000-12-26 00:00:00','2010-12-31 00:00:00');
INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end)
VALUES(7,'Monthly Meetings',7,'The General meetings are held on the third Thursday of each month at the Valley Caffe, corner of Berkeley and Columbus.<br>
Park in the lot next to the building on Columbus.<br>
Our meetings are also convenient to reach via public transportation. Nearest BART station is Powell.
<br><br>
Meetings begin at 19:00.','2000-12-26 00:00:00','2010-12-31 00:00:00');
INSERT INTO countries(country_id,country_name) VALUES(1,'United States');
INSERT INTO countries(country_id,country_name) VALUES(2,'Canada');
INSERT INTO countries(country_id,country_name) VALUES(3,'Afghanistan');
INSERT INTO countries(country_id,country_name) VALUES(4,'Albania');
INSERT INTO countries(country_id,country_name) VALUES(5,'Algeria');
INSERT INTO countries(country_id,country_name) VALUES(6,'American Samoa');
INSERT INTO countries(country_id,country_name) VALUES(7,'Andorra');
INSERT INTO countries(country_id,country_name) VALUES(8,'Angola');
INSERT INTO countries(country_id,country_name) VALUES(9,'Anguilla');
INSERT INTO countries(country_id,country_name) VALUES(10,'Antarctica');
INSERT INTO countries(country_id,country_name) VALUES(11,'Antigua and Barbuda');
INSERT INTO countries(country_id,country_name) VALUES(12,'Argentina');
INSERT INTO countries(country_id,country_name) VALUES(13,'Armenia');
INSERT INTO countries(country_id,country_name) VALUES(14,'Aruba');
INSERT INTO countries(country_id,country_name) VALUES(15,'Australia');
INSERT INTO countries(country_id,country_name) VALUES(16,'Austria');
INSERT INTO countries(country_id,country_name) VALUES(17,'Azerbaijan');
INSERT INTO countries(country_id,country_name) VALUES(18,'Bahamas');
INSERT INTO countries(country_id,country_name) VALUES(19,'Bahrain');
INSERT INTO countries(country_id,country_name) VALUES(20,'Bangladesh');
INSERT INTO countries(country_id,country_name) VALUES(21,'Barbados');
INSERT INTO countries(country_id,country_name) VALUES(22,'Belarus');
INSERT INTO countries(country_id,country_name) VALUES(23,'Belgium');
INSERT INTO countries(country_id,country_name) VALUES(24,'Belize');
INSERT INTO countries(country_id,country_name) VALUES(25,'Benin');
INSERT INTO countries(country_id,country_name) VALUES(26,'Bermuda');
INSERT INTO countries(country_id,country_name) VALUES(27,'Bhutan');
INSERT INTO countries(country_id,country_name) VALUES(28,'Bolivia');
INSERT INTO countries(country_id,country_name) VALUES(29,'Bosnia and Herzegovina');
INSERT INTO countries(country_id,country_name) VALUES(30,'Botswana');
INSERT INTO countries(country_id,country_name) VALUES(31,'Bouvet Island');
INSERT INTO countries(country_id,country_name) VALUES(32,'Brazil');
INSERT INTO countries(country_id,country_name) VALUES(33,'British Indian Ocean Territory');
INSERT INTO countries(country_id,country_name) VALUES(34,'British Virgin Islands');
INSERT INTO countries(country_id,country_name) VALUES(35,'Brunei');
INSERT INTO countries(country_id,country_name) VALUES(36,'Bulgaria');
INSERT INTO countries(country_id,country_name) VALUES(37,'Burkina Faso');
INSERT INTO countries(country_id,country_name) VALUES(38,'Burundi');
INSERT INTO countries(country_id,country_name) VALUES(39,'Cambodia');
INSERT INTO countries(country_id,country_name) VALUES(40,'Cameroon');
INSERT INTO countries(country_id,country_name) VALUES(41,'Cape Verde');
INSERT INTO countries(country_id,country_name) VALUES(42,'Cayman Islands');
INSERT INTO countries(country_id,country_name) VALUES(43,'Central African Republic');
INSERT INTO countries(country_id,country_name) VALUES(44,'Chad');
INSERT INTO countries(country_id,country_name) VALUES(45,'Chile');
INSERT INTO countries(country_id,country_name) VALUES(46,'China');
INSERT INTO countries(country_id,country_name) VALUES(47,'Christmas Island');
INSERT INTO countries(country_id,country_name) VALUES(48,'Cocos Islands');
INSERT INTO countries(country_id,country_name) VALUES(49,'Colombia');
INSERT INTO countries(country_id,country_name) VALUES(50,'Comoros');
INSERT INTO countries(country_id,country_name) VALUES(51,'Congo');
INSERT INTO countries(country_id,country_name) VALUES(52,'Cook Islands');
INSERT INTO countries(country_id,country_name) VALUES(53,'Costa Rica');
INSERT INTO countries(country_id,country_name) VALUES(54,'Croatia');
INSERT INTO countries(country_id,country_name) VALUES(55,'Cuba');
INSERT INTO countries(country_id,country_name) VALUES(56,'Cyprus');
INSERT INTO countries(country_id,country_name) VALUES(57,'Czech Republic');
INSERT INTO countries(country_id,country_name) VALUES(58,'Denmark');
INSERT INTO countries(country_id,country_name) VALUES(59,'Djibouti');
INSERT INTO countries(country_id,country_name) VALUES(60,'Dominica');
INSERT INTO countries(country_id,country_name) VALUES(61,'Dominican Republic');
INSERT INTO countries(country_id,country_name) VALUES(62,'East Timor');
INSERT INTO countries(country_id,country_name) VALUES(63,'Ecuador');
INSERT INTO countries(country_id,country_name) VALUES(64,'Egypt');
INSERT INTO countries(country_id,country_name) VALUES(65,'El Salvador');
INSERT INTO countries(country_id,country_name) VALUES(66,'Equatorial Guinea');
INSERT INTO countries(country_id,country_name) VALUES(67,'Eritrea');
INSERT INTO countries(country_id,country_name) VALUES(68,'Estonia');
INSERT INTO countries(country_id,country_name) VALUES(69,'Ethiopia');
INSERT INTO countries(country_id,country_name) VALUES(70,'Falkland Islands');
INSERT INTO countries(country_id,country_name) VALUES(71,'Faroe Islands');
INSERT INTO countries(country_id,country_name) VALUES(72,'Fiji');
INSERT INTO countries(country_id,country_name) VALUES(73,'Finland');
INSERT INTO countries(country_id,country_name) VALUES(74,'France');
INSERT INTO countries(country_id,country_name) VALUES(75,'French Guiana');
INSERT INTO countries(country_id,country_name) VALUES(76,'French Polynesia');
INSERT INTO countries(country_id,country_name) VALUES(77,'French Southern Territories');
INSERT INTO countries(country_id,country_name) VALUES(78,'Gabon');
INSERT INTO countries(country_id,country_name) VALUES(79,'Gambia');
INSERT INTO countries(country_id,country_name) VALUES(80,'Georgia');
INSERT INTO countries(country_id,country_name) VALUES(81,'Germany');
INSERT INTO countries(country_id,country_name) VALUES(82,'Ghana');
INSERT INTO countries(country_id,country_name) VALUES(83,'Gibraltar');
INSERT INTO countries(country_id,country_name) VALUES(84,'Greece');
INSERT INTO countries(country_id,country_name) VALUES(85,'Greenland');
INSERT INTO countries(country_id,country_name) VALUES(86,'Grenada');
INSERT INTO countries(country_id,country_name) VALUES(87,'Guadeloupe');
INSERT INTO countries(country_id,country_name) VALUES(88,'Guam');
INSERT INTO countries(country_id,country_name) VALUES(89,'Guatemala');
INSERT INTO countries(country_id,country_name) VALUES(90,'Guinea');
INSERT INTO countries(country_id,country_name) VALUES(91,'Guinea-Bissau');
INSERT INTO countries(country_id,country_name) VALUES(92,'Guyana');
INSERT INTO countries(country_id,country_name) VALUES(93,'Haiti');
INSERT INTO countries(country_id,country_name) VALUES(94,'Heard and McDonald Islands');
INSERT INTO countries(country_id,country_name) VALUES(95,'Honduras');
INSERT INTO countries(country_id,country_name) VALUES(96,'Hong Kong');
INSERT INTO countries(country_id,country_name) VALUES(97,'Hungary');
INSERT INTO countries(country_id,country_name) VALUES(98,'Iceland');
INSERT INTO countries(country_id,country_name) VALUES(99,'India');
INSERT INTO countries(country_id,country_name) VALUES(100,'Indonesia');
INSERT INTO countries(country_id,country_name) VALUES(101,'Iran');
INSERT INTO countries(country_id,country_name) VALUES(102,'Iraq');
INSERT INTO countries(country_id,country_name) VALUES(103,'Ireland');
INSERT INTO countries(country_id,country_name) VALUES(104,'Israel');
INSERT INTO countries(country_id,country_name) VALUES(105,'Italy');
INSERT INTO countries(country_id,country_name) VALUES(106,'Ivory Coast');
INSERT INTO countries(country_id,country_name) VALUES(107,'Jamaica');
INSERT INTO countries(country_id,country_name) VALUES(108,'Japan');
INSERT INTO countries(country_id,country_name) VALUES(109,'Jordan');
INSERT INTO countries(country_id,country_name) VALUES(110,'Kazakhstan');
INSERT INTO countries(country_id,country_name) VALUES(111,'Kenya');
INSERT INTO countries(country_id,country_name) VALUES(112,'Kiribati');
INSERT INTO countries(country_id,country_name) VALUES(113,'North Korea');
INSERT INTO countries(country_id,country_name) VALUES(114,'South Korea');
INSERT INTO countries(country_id,country_name) VALUES(115,'Kuwait');
INSERT INTO countries(country_id,country_name) VALUES(116,'Kyrgyzstan');
INSERT INTO countries(country_id,country_name) VALUES(117,'Laos');
INSERT INTO countries(country_id,country_name) VALUES(118,'Latvia');
INSERT INTO countries(country_id,country_name) VALUES(119,'Lebanon');
INSERT INTO countries(country_id,country_name) VALUES(120,'Lesotho');
INSERT INTO countries(country_id,country_name) VALUES(121,'Liberia');
INSERT INTO countries(country_id,country_name) VALUES(122,'Libya');
INSERT INTO countries(country_id,country_name) VALUES(123,'Liechtenstein');
INSERT INTO countries(country_id,country_name) VALUES(124,'Lithuania');
INSERT INTO countries(country_id,country_name) VALUES(125,'Luxembourg');
INSERT INTO countries(country_id,country_name) VALUES(126,'Macau');
INSERT INTO countries(country_id,country_name) VALUES(127,'Macedonia');
INSERT INTO countries(country_id,country_name) VALUES(128,'Madagascar');
INSERT INTO countries(country_id,country_name) VALUES(129,'Malawi');
INSERT INTO countries(country_id,country_name) VALUES(130,'Malaysia');
INSERT INTO countries(country_id,country_name) VALUES(131,'Maldives');
INSERT INTO countries(country_id,country_name) VALUES(132,'Mali');
INSERT INTO countries(country_id,country_name) VALUES(133,'Malta');
INSERT INTO countries(country_id,country_name) VALUES(134,'Marshall Islands');
INSERT INTO countries(country_id,country_name) VALUES(135,'Martinique');
INSERT INTO countries(country_id,country_name) VALUES(136,'Mauritania');
INSERT INTO countries(country_id,country_name) VALUES(137,'Mauritius');
INSERT INTO countries(country_id,country_name) VALUES(138,'Mayotte');
INSERT INTO countries(country_id,country_name) VALUES(139,'Mexico');
INSERT INTO countries(country_id,country_name) VALUES(140,'Micronesia');
INSERT INTO countries(country_id,country_name) VALUES(141,'Moldova');
INSERT INTO countries(country_id,country_name) VALUES(142,'Monaco');
INSERT INTO countries(country_id,country_name) VALUES(143,'Mongolia');
INSERT INTO countries(country_id,country_name) VALUES(144,'Montserrat');
INSERT INTO countries(country_id,country_name) VALUES(145,'Morocco');
INSERT INTO countries(country_id,country_name) VALUES(146,'Mozambique');
INSERT INTO countries(country_id,country_name) VALUES(147,'Myanmar');
INSERT INTO countries(country_id,country_name) VALUES(148,'Namibia');
INSERT INTO countries(country_id,country_name) VALUES(149,'Nauru');
INSERT INTO countries(country_id,country_name) VALUES(150,'Nepal');
INSERT INTO countries(country_id,country_name) VALUES(151,'Netherlands');
INSERT INTO countries(country_id,country_name) VALUES(152,'Netherlands Antilles');
INSERT INTO countries(country_id,country_name) VALUES(153,'New Caledonia');
INSERT INTO countries(country_id,country_name) VALUES(154,'New Zealand');
INSERT INTO countries(country_id,country_name) VALUES(155,'Nicaragua');
INSERT INTO countries(country_id,country_name) VALUES(156,'Niger');
INSERT INTO countries(country_id,country_name) VALUES(157,'Nigeria');
INSERT INTO countries(country_id,country_name) VALUES(158,'Niue');
INSERT INTO countries(country_id,country_name) VALUES(159,'Norfolk Island');
INSERT INTO countries(country_id,country_name) VALUES(160,'Northern Mariana Islands');
INSERT INTO countries(country_id,country_name) VALUES(161,'Norway');
INSERT INTO countries(country_id,country_name) VALUES(162,'Oman');
INSERT INTO countries(country_id,country_name) VALUES(163,'Pakistan');
INSERT INTO countries(country_id,country_name) VALUES(164,'Palau');
INSERT INTO countries(country_id,country_name) VALUES(165,'Panama');
INSERT INTO countries(country_id,country_name) VALUES(166,'Papua New Guinea');
INSERT INTO countries(country_id,country_name) VALUES(167,'Paraguay');
INSERT INTO countries(country_id,country_name) VALUES(168,'Peru');
INSERT INTO countries(country_id,country_name) VALUES(169,'Philippines');
INSERT INTO countries(country_id,country_name) VALUES(170,'Pitcairn Island');
INSERT INTO countries(country_id,country_name) VALUES(171,'Poland');
INSERT INTO countries(country_id,country_name) VALUES(172,'Portugal');
INSERT INTO countries(country_id,country_name) VALUES(173,'Puerto Rico');
INSERT INTO countries(country_id,country_name) VALUES(174,'Qatar');
INSERT INTO countries(country_id,country_name) VALUES(175,'Reunion');
INSERT INTO countries(country_id,country_name) VALUES(176,'Romania');
INSERT INTO countries(country_id,country_name) VALUES(177,'Russia');
INSERT INTO countries(country_id,country_name) VALUES(178,'Rwanda');
INSERT INTO countries(country_id,country_name) VALUES(179,'S. Georgia and S. Sandwich Isls.');
INSERT INTO countries(country_id,country_name) VALUES(180,'Saint Kitts & Nevis');
INSERT INTO countries(country_id,country_name) VALUES(181,'Saint Lucia');
INSERT INTO countries(country_id,country_name) VALUES(182,'Saint Vincent and The Grenadines');
INSERT INTO countries(country_id,country_name) VALUES(183,'Samoa');
INSERT INTO countries(country_id,country_name) VALUES(184,'San Marino');
INSERT INTO countries(country_id,country_name) VALUES(185,'Sao Tome and Principe');
INSERT INTO countries(country_id,country_name) VALUES(186,'Saudi Arabia');
INSERT INTO countries(country_id,country_name) VALUES(187,'Senegal');
INSERT INTO countries(country_id,country_name) VALUES(188,'Seychelles');
INSERT INTO countries(country_id,country_name) VALUES(189,'Sierra Leone');
INSERT INTO countries(country_id,country_name) VALUES(190,'Singapore');
INSERT INTO countries(country_id,country_name) VALUES(191,'Slovakia');
INSERT INTO countries(country_id,country_name) VALUES(192,'Slovenia');
INSERT INTO countries(country_id,country_name) VALUES(193,'Somalia');
INSERT INTO countries(country_id,country_name) VALUES(194,'South Africa');
INSERT INTO countries(country_id,country_name) VALUES(195,'Spain');
INSERT INTO countries(country_id,country_name) VALUES(196,'Sri Lanka');
INSERT INTO countries(country_id,country_name) VALUES(197,'St. Helena');
INSERT INTO countries(country_id,country_name) VALUES(198,'St. Pierre and Miquelon');
INSERT INTO countries(country_id,country_name) VALUES(199,'Sudan');
INSERT INTO countries(country_id,country_name) VALUES(200,'Suriname');
INSERT INTO countries(country_id,country_name) VALUES(201,'Svalbard and Jan Mayen Islands');
INSERT INTO countries(country_id,country_name) VALUES(202,'Swaziland');
INSERT INTO countries(country_id,country_name) VALUES(203,'Sweden');
INSERT INTO countries(country_id,country_name) VALUES(204,'Switzerland');
INSERT INTO countries(country_id,country_name) VALUES(205,'Syria');
INSERT INTO countries(country_id,country_name) VALUES(206,'Taiwan');
INSERT INTO countries(country_id,country_name) VALUES(207,'Tajikistan');
INSERT INTO countries(country_id,country_name) VALUES(208,'Tanzania');
INSERT INTO countries(country_id,country_name) VALUES(209,'Thailand');
INSERT INTO countries(country_id,country_name) VALUES(210,'Togo');
INSERT INTO countries(country_id,country_name) VALUES(211,'Tokelau');
INSERT INTO countries(country_id,country_name) VALUES(212,'Tonga');
INSERT INTO countries(country_id,country_name) VALUES(213,'Trinidad and Tobago');
INSERT INTO countries(country_id,country_name) VALUES(214,'Tunisia');
INSERT INTO countries(country_id,country_name) VALUES(215,'Turkey');
INSERT INTO countries(country_id,country_name) VALUES(216,'Turkmenistan');
INSERT INTO countries(country_id,country_name) VALUES(217,'Turks and Caicos Islands');
INSERT INTO countries(country_id,country_name) VALUES(218,'Tuvalu');
INSERT INTO countries(country_id,country_name) VALUES(219,'U.S. Minor Outlying Islands');
INSERT INTO countries(country_id,country_name) VALUES(220,'Uganda');
INSERT INTO countries(country_id,country_name) VALUES(221,'Ukraine');
INSERT INTO countries(country_id,country_name) VALUES(222,'United Arab Emirates');
INSERT INTO countries(country_id,country_name) VALUES(223,'United Kingdom');
INSERT INTO countries(country_id,country_name) VALUES(224,'Uruguay');
INSERT INTO countries(country_id,country_name) VALUES(225,'Uzbekistan');
INSERT INTO countries(country_id,country_name) VALUES(226,'Vanuatu');
INSERT INTO countries(country_id,country_name) VALUES(227,'Vatican City');
INSERT INTO countries(country_id,country_name) VALUES(228,'Venezuela');
INSERT INTO countries(country_id,country_name) VALUES(229,'Vietnam');
INSERT INTO countries(country_id,country_name) VALUES(230,'Virgin Islands');
INSERT INTO countries(country_id,country_name) VALUES(231,'Wallis and Futuna Islands');
INSERT INTO countries(country_id,country_name) VALUES(232,'Western Sahara');
INSERT INTO countries(country_id,country_name) VALUES(233,'Yemen');
INSERT INTO countries(country_id,country_name) VALUES(234,'Serbia and Montenegro');
INSERT INTO countries(country_id,country_name) VALUES(235,'Zaire');
INSERT INTO countries(country_id,country_name) VALUES(236,'Zambia');
INSERT INTO countries(country_id,country_name) VALUES(237,'Zimbabwe');
INSERT INTO educations(education_id,education_name) VALUES(1,'High School');
INSERT INTO educations(education_id,education_name) VALUES(2,'College');
INSERT INTO educations(education_id,education_name) VALUES(3,'Graduate School');
INSERT INTO educations(education_id,education_name) VALUES(4,'Other');
INSERT INTO event_categories(category_id,category_name) VALUES(1,'Science');
INSERT INTO event_categories(category_id,category_name) VALUES(2,'Museums');
INSERT INTO event_categories(category_id,category_name) VALUES(3,'Computers');
INSERT INTO event_categories(category_id,category_name) VALUES(4,'Business');
INSERT INTO event_categories(category_id,category_name) VALUES(5,'Internet');
INSERT INTO event_categories(category_id,category_name) VALUES(6,'Education');
INSERT INTO event_categories(category_id,category_name) VALUES(7,'Career');
INSERT INTO event_categories(category_id,category_name) VALUES(8,'History');
INSERT INTO event_categories(category_id,category_name) VALUES(9,'Club Information');
INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add)
VALUES(1,null,null,0,null,'2000-12-01 19:30:00',null,'Marketing Strategy for High Technology Companies with Disruptive Technologies, or Why Smart Engineers Fail in Bringing Advanced Products to Market.','Many high technology developments qualify as discontinuous innovation,
which is defined as one that requires a change of customer behavior.
There are two generic types of discontinuous innovation: Paradigm shock
(e.g., PC replacing a typewriter) Application breakthrough (e.g., voice
recognition replacing service personnel)
On the opposite end there are continuous innovations, which do not
require customer behavior change, e,g., using a new toothpaste.
As Silicon Valley marketing guru Regis McKenna once wrote, \"Marketing is
Everything\" (and not the technology, engineers). It is thus marketing
flow that most often defines a product (and often company) market
failure. Selection of a suitable marketing strategy is thus extremely
important success factor for high-tech startups.
For a continuous innovation, the demand for products gradually increases
and after reaching maturity, the demand gradually decreases, as
customers already know what to do with the product and how to use it.
For a discontinuous innovation, however, there is a gap (called \"chasm\")
in customer demand. After attracting small groups of \"techies\" (buying
for the sake of having the newest toys) and visionaries (having an idea
for a new business based on new technology), the demand evaporates as
mainstream customers shy away from the product. Classical marketing
technologies failed to attract this group of buyers with deep pockets.
Companies that succeeded in crossing the chasm, however, often reach an
avalanche growth of sales, defined as \"tornado\".
Some of the technologies stuck in Chasm include voice recognition,
artificial intelligence, electric car, DSL, high definition TV, smart
cards (in the US) and so far majority of MEMS technologies. Some of
technologies that died in Chasm include gyroscopic mouse, Newton PDA,
Lisa PC and PC Junior.
Based on market research of large number of companies with discontinuous
innovation, Geoffrey Moore (initially at Regis McKenna Inc., a leading
marketing organization in Silicon Valley and later at The Chasm Group)
developed a strategy for crossing the chasm (summarized in his books
\"Crossing the Chasm\" and \"Inside the Tornado\", A Harper Business Book,
1999).
This presentation summarizes Moore findings. It is focused on
developing a strategy to cross the Chasm. This strategy requires
focusing initially all the company resources on one application in one
market segment (\"pin\") and becoming a dominant supplier (a \"gorilla\") in
this space. After accomplishing this goal, Company should develop and
dominate other pins: either the same application in different market
segment or different application in the same segment.
After becoming a \"gorilla\" in sufficient number of pins, the \"tornado\"
starts, destroying the old technology and establishing the new one,
returning the overwhelming market share to the Company.
Few examples of Tornadoes include desktop publishing, word processors,
spreadsheets, Windows, microprocessors, cell phones, E-mail. Tornadoes
created 11 new Billionaires in recent four years!
The presentation then introduces a concept of a \"whole product\" and its
requirements for increased chance of dominating the application. It
follows to define a recommended marketing strategy during the Tornado.
Tornado in turn leads to Main Street, a mature market development phase
that requires again adaptation of a new marketing strategy.
About the Speaker
Dr. Bryzek got his MSEE in 1970 and Ph.D. in 1977 from Warsaw Technical
University. He completed the executive management program at Stanford
University in 1987.
He moved to Silicon Valley in 1979. Between 1982 and 2000 he cofounded
five successful Silicon Valley high-tech companies based on MEMS
technology (MicroElectroMechanical Systems), all introducing products
based on disruptive technology. His newest startup founded in March
2000 focuses on optical networking market.
One of his technical greatest achievements was the 1981de','Dr. Janusz Bryzek','Blue Star Coffee, 1071 S. DeAnza Blvd, Cupertino 408.863.0707',null,null,null,4);
INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add)
VALUES(2,null,null,0,null,'2001-01-19 19:30:00',null,'Helping schools develop students'' interest in science and technology: SCVSEFA and science fairs.',NULL,'Kerry Veenstra','TBD',null,null,null,0);
INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add)
VALUES(3,null,null,0,null,'2000-10-21 18:00:00',null,'Performance of US economy in 2001. More about Dr. Belotti. Pictures.','Our guest speaker will be Prof. Mario Belotti. He will present \"The forecast of the US economy performance in 2001\"
Dr Mario Belotti has been teaching at Santa Clara University since 1959. He teaches economics in both the graduate and undergraduate programs. He served as Chair of the Economics Department from 1962 to 1984 and as the Director of the Institute of Agribusiness from 1988 to 1996. His fields of interest are macroeconomics theory, monetary theory and economic development. He organized and chaired 23 Santa Clara University Symposiums and 28 yearly Economic Forecasts. Dr. Belotti spent many summers as an economic consultant in developing countries: Brazil, Honduras, Sudan, Egypt, Iran, Uganda, Kenya, Tanzania, Thailand, Bulgaria, Hungry, Nepal, and Eritrea.
Dr. Belotti received a Bachelor of Science in Business Administration and a Master of Arts in Accounting from Midwestern University. He obtained a Ph.D. in Economics from the University of Texas in Austin.','Dr. Mario Belotti, Professor of Economics, Santa C','Hotel Embassy Suites (Diplomat Room), 2885 Lakeside Drive, Santa Clara',null,null,null,0);
INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add)
VALUES(4,null,null,0,null,'2000-09-22 19:00:00',null,'\"Restructuring of the International energy sector - a combination of economics and politics\".','International market is undergoing a major restructuring of its energy sector. Many power plants were built to burn coal, which some countries claimed to have in unlimited supply. This system created inefficiency, mismanagement and environmental abuse.
Piotr Moncarz talk will present the aspects of the International energy market restructuring with an emphasis on the privatization and modernization aspects of investment in small and medium size power plants.
About the speaker:
Piotr Moncarz was born and raised in Poznan, Poland. For last twenty years he has worked at a high profile consulting company: Exponent Failure Analysis, where he is a Principal Engineer and Corporate Vice President. For last seven years his efforts have included the development of a gas-fired electric power plant at Lake Zarnowiec near Gdansk, on the site of an abandoned project of the first Polish nuclear plant.
The promotion of American investment into Polish economy has become his passion, as he believes this to be the most effective political independence insurance Poland can acquire while entering the new century.
Piotr Moncarz has Ph.D. in Civil Engineering from Stanford University, where he teaches graduate classes a Consulting Professor.','Piotr D. Moncarz','ACUSON (bldg.I) 1393 Shorebird Way (corner of Shoreline Blvd.), Mountain View',null,null,null,2);
INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add)
VALUES(5,null,null,0,null,'2000-06-23 19:00:00',null,'On June 23,2000 during the Club monthly meeting, Dr. Zofia Rek presented an interesting lecture about her work experience at Stanford Synchotron Radiation Laboratory where she works since 1980.','On June 23,2000 during the Club monthly meeting, Dr. Zofia Rek presented an interesting lecture about her work experience at Stanford Synchotron Radiation Laboratory where she works since 1980.
SSRL is multidisciplinary laboratory funded by Department of Energy and National Institute of Health. Synchrotron radiation is the electromagnetic radiation emitted by electrons along curved trajectory. Most of the experiments are in the X-ray energy range although higher energies in the alfa range can be obtained.
Applications are very diversified: X-ray imaging of defects and strains for large crystals for semiconductor wafers to laser windows to study fusion. In biology studies are made to detect and eleminate selenium areas in USA in order to improve the quality of soil.
In medicine radiation is used in angiography to detect blockage of heart arteries without invasion of catater and also in studies of osteoporosis. The large part of the lecture was dedicated to protein crytallography as a tool for solving protein structure so important for human genomic project.
Zofia also discussed some other works done by SSRL like membrane protein which works as an intelligent guard against cholera toxin and Topoisomerase a protein that is targeted by anti-cancer drugs. There was a very interesting discussion after the lecture and members of the Club had an opportunity to examine numerous models and sampels brought by Zofia.','Zofia Rek, Stanford Synchrotron Radiation Laborato','TBD',null,null,null,0);
INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add)
VALUES(6,null,null,0,null,'2000-05-19 19:00:00',null,'\"Issues in Software Development Evolution - a Veteran Practitioner''s Point of View\".','On May meeting Dr. Zbigniew Sufleta has entertained PAEC club with the presentation on the subject of Software Development Process, the Practitioner''s point of view.
His extensive industry experience (over 20 years) gave his listeners a rare opportunity to hear about the process itself, the principles and what applies in the real life.
The speech has concluded with a round table discussion about the current market conditions and the impact it bears on the Bay area living conditions (tight labor market, escalating salaries, booming real estate, traffic congestions).','Dr. Zbigniew Sufleta','TBD',null,null,null,0);
INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add)
VALUES(7,null,null,0,null,'2000-03-24 19:00:00',null,'Problems with the manpower in Hi-Tech industry in Silicon Valley.',NULL,'Prof. Aleksander Liniecki, San Jose State Universi','The Clubhouse in \"Sunset Oaks\" townhouse complex. 675 Picasso Terrace, Sunnyvale.','http://sunsetoaks.org/location.html#http://sunseto',null,null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(1,null,'error message!!! in DB MSG','seopo','I have a problem in DB MSG at brinkster
It is in a SQL statement...
''select * from tablename''--> It is well operated...
But ''delete from tablename'' or ''update set No =1 where No=3...etc''----> It is not well operated....
There appears error message
It is.....
Query Results
ADODB.Recordset error ''800a0e78''
Operation is not allowed when the object is closed.
/DatabaseManager.asp, line 473 \"\"
I want to find a way...
please! give me an answer....','2001-01-04 11:28:00',null,8);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(2,1,'RE: error message!!! in DB MSG','nhsa','DELETE * FROM tablename WHERE stringfield=''stringvalue''
UPDATE tablename SET stringfield=''hello'' WHERE numberfield=10
HTH
Nige - nhsa@yahoo.com','2001-01-04 15:00:00',null,2);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(3,1,'RE: error message!!! in DB MSG','hiflyer','Nige is right with his SQL string examples, but the error you are getting is because you are trying to perform operations on a recordset which has been closed. If you look at your code you will probably find a line such as dbConn.close, or RS.close or Set RS = nothing somewhere before line 473.
HTH,
Bod.
www5.brinkster.com/hiflyer','2001-01-05 04:28:00',null,3);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(4,null,'writing db results to multiple pages','shiaislamasp','how do i write say 10 db results, from a select statement, on a page, then link to another page, with the next 10, and so on..
I would be very grateful for any help
Thank you','2001-01-04 19:56:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(5,4,'RE: writing db results to multiple pages','adom','Asuming your database is sorted by a incrementing value you can use the BETWEEN statement in your querry.
That is on the first page you do:
SELECT * from Table WHERE OrderValue BETWEEN 1 and 10
Then you pass along the last value to the next page \"\"show_rewults?start=11\"\" for example and go from there
SELECT * from Table WHERE OrderValue BETWEEN 11 and 20
and so on?','2001-01-05 03:33:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(6,null,'what is this error... It works on my iis','feiyeung','keyword =url =comment = there is an error
Microsoft JET Database Engine error ''80040e09''
Cannot update. Database or object is read-only.
/input.asp, line 39
it wokrs on my iis5.0 fine. It is because the db dir isn''t set rite or what?
anyone has any ideaS
FELIX','2001-01-04 05:02:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(7,null,'dynamic queries','vpl','i want to rerieve the value from the database based upon the selection criteria that is out of ten text fields if the user select two values means,i should get the output based upon that value.the query should be a single query.','2001-01-03 03:21:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(8,7,'RE: dynamic queries','product','The Best Way is to write SQl Statement .
For Example
Select Empno,Ename from emp where empno = ''1001'' or Sal >100
if you can provide a code, will try to provide a solution.','2001-01-03 06:49:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(9,null,'CF Custom Tag directory???','Michael','Hi,
how do i change the default directory of the CUSTOM TAG where CF_ tags are places to a directory of my choice????
thankxs','2001-01-19 17:18:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(10,9,'CF Custom Tag directory???','vpl','You can edit the registry key HKEY_LOCAL_MACHINESOFTWAREAllaireColdFusionCurrentVersionCustomTagsCFMLTagSearchPath
And then restart the server.
/Ruben','2001-01-19 17:45:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(11,null,'Pictures embeded in Email','Rocky Ang','I am trying to use the cfmail command to send HTML based emails. This can be easily done by referencing the pictures within the mail to download from an url.
However, this caused a problem when the recipient tries to read the mail offline. The pictures disappeared.
A way to solve this would be to embed the pictures and send the pictures with the mail. Is there any way to do this with cold fusion.
Any prompt help would be deeply appreciated by a desperate guy.','2001-01-19 17:37:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(12,11,'relative','Glenn Channon','Try relative URL''s http://www.domainname.com/images/imagename.gif','2001-01-19 18:37:00',null,0);
INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id)
VALUES(13,12,'No Use','feiyeung','No use, when the user is offline and tries to read the mail
the pictures are missing.
The pictures are ok when the user is online','2001-01-19 18:45:00',null,8);
INSERT INTO genders(gender_id,gender_name) VALUES(1,'Male');
INSERT INTO genders(gender_id,gender_name) VALUES(2,'Female');
INSERT INTO incomes(income_id,income_name) VALUES(1,'under $25,000');
INSERT INTO incomes(income_id,income_name) VALUES(2,'$25,000 - $34,000');
INSERT INTO incomes(income_id,income_name) VALUES(3,'$35,000 - $49,000');
INSERT INTO incomes(income_id,income_name) VALUES(4,'$50,000 - $74,000');
INSERT INTO incomes(income_id,income_name) VALUES(5,'over $75,000');
INSERT INTO languages(language_id,language_name) VALUES(1,'English');
INSERT INTO languages(language_id,language_name) VALUES(2,'French');
INSERT INTO languages(language_id,language_name) VALUES(3,'German');
INSERT INTO languages(language_id,language_name) VALUES(4,'Chinese');
INSERT INTO languages(language_id,language_name) VALUES(5,'Japanese');
INSERT INTO languages(language_id,language_name) VALUES(6,'Russian');
INSERT INTO languages(language_id,language_name) VALUES(7,'Polish');
INSERT INTO languages(language_id,language_name) VALUES(8,'Turkish');
INSERT INTO languages(language_id,language_name) VALUES(9,'Yiddish');
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(1,'Announcements',null);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(2,'Autos & Motorcycles',null);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(3,'Business Opportunities',null);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(4,'Computers & Software',null);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(5,'Employment',null);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(6,'Services',null);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(7,'Pets & Animals',null);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(8,'Anniversaries',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(9,'Auctions',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(10,'Births',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(11,'Bookgroups',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(12,'Bris/Christenings',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(13,'Coupons',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(14,'Promotion',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(15,'Clubs/Organizations',1);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(16,'Car',2);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(17,'Motorcycle',2);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(18,'Truck',2);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(19,'Van',2);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(20,'Sport Utility and Jeeps',2);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(21,'Casinos',3);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(22,'Apparel',3);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(23,'Computers and Internet',3);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(24,'Food and Beverage',3);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(25,'Marketing',3);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(26,'Travel and Transportation',3);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(27,'Telecommunications',3);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(28,'Legal Services',6);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(29,'Home & Garden',6);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(30,'Entertainment and Arts',6);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(31,'Administrative and Corporate',5);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(32,'Media, Arts, and Design',5);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(33,'Facilities Management and Maintenance',5);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(34,'Financial Services',5);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(35,'Health Care',5);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(36,'Information Technology',5);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(37,'Engineering',5);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(38,'Dogs',7);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(39,'Cats',7);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(40,'Fish and Aquariums',7);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(41,'Miscellaneous Supplies',7);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(42,'Reptiles',7);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(43,'Domain Names',4);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(44,'Hardware',4);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(45,'Software',4);
INSERT INTO link_categories(category_id,category_name,category_id_parent)
VALUES(46,'Networking',4);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(1,6,'TheTech Museum of Innovation','http://www.thetech.org/','The Tech Museum of Innovation in San Jose, California is a hands-on technology museum devoted to inspiring the innovator in everyone.','201 South Market Street
San Jose, CA 95113
408-294-TECH',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(2,5,'Lawrence Livermore National Laboratory','http://www.llnl.gov/','Lawrence Livermore National Laboratory ensures national security and applies science and technology to important problems of our time.','7000 East Ave., Livermore, CA 94550-9234',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(3,10,'Monterey Bay Aquarium','http://www.mbayaq.org/sg','The Monterey Bay Aquarium is dedicated to inspiring ocean conservation. Find out more about how we
approach our mission.','201 South Market Street
San Jose, CA 95113',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(4,5,'Chabot Space & Science Center','http://www.cosc.org/','At Chabot Space & Science Center (CSSC), the universe is yours to experience. Set amid 13 trail-laced acres of East Bay parkland, with glorious views of San Francisco Bay and the Oakland foothills, CSSC is a hands-on celebration of sights, sounds, and sensations.','10000 Skyline Blvd.
Oakland, CA 94619',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(5,5,'UC Observatories/Lick Observatory','http://www.ucolick.org/','University of California Observatories/Lick Observatory conducts leading-edge research to answer the most profound questions in observational astronomy.','University of California, Santa Cruz, CA 95064
Phone: 831/459-2513; Fax: 831/426-3115',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(6,6,'San Francisco Cable Car Museum','http://www.cablecarmuseum.com/','The cable car was born in San Francisco at four o''clock in the morning on August 2, 1873, when Andrew Smith Hallidie successfully tested the world''s first cable car. Operated by the nonprofit \"Friends of the Cable Car Museum\" the Cable Car Museum provides not only an historical perspective of the importance of the cable car to San Francisco, but an insight into the daily operations of today''s system.','1201 Mason Street at Washington, San Francisco.',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(7,5,'NASA Ames Research Center','http://www.arc.nasa.gov/about_ames','Ames was founded December 20, 1939 as an aircraft research laboratory by the National Advisory Committee on Aeronautics (NACA) and in 1958 became part of National Aeronautics and Space Administration (NASA). Ames specializes in research geared toward creating new knowledge and new technologies that span the spectrum of NASA interests.','NASA Ames Research Center is located at Moffett Field, California in the heart of \"Silicon Valley\".',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by)
VALUES(8,10,'Berkeley Lab','http://www.lbl.gov/','Berkeley Lab is a multidisciplinary national laboratory that conducts nonclassified research. We are located in Berkeley, California on a site in the hills directly above the campus of the University of California at Berkeley. Overlooking both the campus and San Francisco Bay, the site consists of 76 buildings located on 183 acres.','201 South Market Street
San Jose, CA 95113
408-294-TECH',0,'2000-12-26 00:00:00',null,null,1,null);
INSERT INTO news(news_id,news_desc)
VALUES(1,'<script language=\"JavaScript\" type=\"text/javascript\" src=\"http://www.oreillynet.com/meerkat/?m=296&_fl=js\"></script>');
INSERT INTO officers(officer_id,officer_name,officer_position,officer_email)
VALUES(1,'James Morton','President','jmorton@nowhere.com');
INSERT INTO officers(officer_id,officer_name,officer_position,officer_email)
VALUES(2,'Adam Bryzek','Vice President','adam@nowhere.com');
INSERT INTO officers(officer_id,officer_name,officer_position,officer_email)
VALUES(3,'Matt Vaughn','Vice President','mvaughn@nowhere.com');
INSERT INTO officers(officer_id,officer_name,officer_position,officer_email)
VALUES(4,'Bob Newell','Secretary','bnewell@nowhere.com');
INSERT INTO officers(officer_id,officer_name,officer_position,officer_email)
VALUES(5,'Sabrina Rek','Treasurer','srek@nowhere.com');
INSERT INTO officers(officer_id,officer_name,officer_position,officer_email)
VALUES(6,'Jamie McCants','Webmaster','jmccants@nowhere.com');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(0,'no smile','<img src="images/0-0.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(1,'smile','<img src="images/icons/smile.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(2,'mad','<img src="images/icons/mad.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(3,'sad','<img src="images/icons/sad.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(4,'big grin','<img src="images/icons/biggrin.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(5,'colgate','<img src="images/icons/colgate.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(6,'confused','<img src="images/icons/confused.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(7,'sigh','<img src="images/icons/sigh.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(8,'cool','<img src="images/icons/cool.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(9,'tongue','<img src="images/icons/tounge.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(10,'wink','<img src="images/icons/wink.gif">');
INSERT INTO smiles(smile_id,smile_name,smile_url)
VALUES(11,'wow!','<img src="images/icons/wow.gif">');
INSERT INTO states(state_id,state_name) VALUES(1,'Alaska');
INSERT INTO states(state_id,state_name) VALUES(2,'Alabama');
INSERT INTO states(state_id,state_name) VALUES(3,'Arkansas');
INSERT INTO states(state_id,state_name) VALUES(4,'American Samoa');
INSERT INTO states(state_id,state_name) VALUES(5,'Arizona');
INSERT INTO states(state_id,state_name) VALUES(6,'California');
INSERT INTO states(state_id,state_name) VALUES(7,'Colorado');
INSERT INTO states(state_id,state_name) VALUES(8,'Connecticut');
INSERT INTO states(state_id,state_name) VALUES(9,'District of Columbia');
INSERT INTO states(state_id,state_name) VALUES(10,'Delaware');
INSERT INTO states(state_id,state_name) VALUES(11,'Florida');
INSERT INTO states(state_id,state_name) VALUES(12,'Georgia');
INSERT INTO states(state_id,state_name) VALUES(13,'Guam');
INSERT INTO states(state_id,state_name) VALUES(14,'Hawaii');
INSERT INTO states(state_id,state_name) VALUES(15,'Iowa');
INSERT INTO states(state_id,state_name) VALUES(16,'Idaho');
INSERT INTO states(state_id,state_name) VALUES(17,'
Description: cannot run in MySQL 3.23.52 that query: SELECT * FROM (store_shopping_cart_items INNER JOIN ((store_order_items INNER JOIN (store_editorial_products INNER JOIN (store_products INNER JOIN (store_editorial_categories INNER JOIN store_categories ON store_editorial_categories.category_id = store_categories.category_id) ON store_products.category_id = store_categories.category_id AND store_editorial_products.editorial_cat_id = store_editorial_categories.category_id) ON store_editorial_products.product_id = store_products.product_id) ON store_order_items.product_id = store_products.product_id) INNER JOIN (store_orders INNER JOIN store_statuses ON store_orders.order_status_id = store_statuses.status_id) ON store_order_items.order_id = store_orders.order_id) ON store_shopping_cart_items.product_id = store_products.product_id) INNER JOIN store_shopping_carts ON store_shopping_cart_items.shopping_cart_id = store_shopping_carts.shopping_cart_id but i can run in MySQL 4.0.15 my ISP use exactly MySQL 3.23.52 only and admins cannot want use MySQL 4.0.15. Tell me please what's wrong? How to repeat: # # DROP TABLES # DROP TABLE IF EXISTS ages; DROP TABLE IF EXISTS articles; DROP TABLE IF EXISTS countries; DROP TABLE IF EXISTS directory_categories; DROP TABLE IF EXISTS directory_items; DROP TABLE IF EXISTS educations; DROP TABLE IF EXISTS events; DROP TABLE IF EXISTS event_categories; DROP TABLE IF EXISTS forum_messages; DROP TABLE IF EXISTS genders; DROP TABLE IF EXISTS incomes; DROP TABLE IF EXISTS languages; DROP TABLE IF EXISTS links; DROP TABLE IF EXISTS link_categories; DROP TABLE IF EXISTS news; DROP TABLE IF EXISTS officers; DROP TABLE IF EXISTS smiles; DROP TABLE IF EXISTS states; DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS user_groups; DROP TABLE IF EXISTS store_categories; DROP TABLE IF EXISTS store_editorial_categories; DROP TABLE IF EXISTS store_editorial_products; DROP TABLE IF EXISTS store_order_items; DROP TABLE IF EXISTS store_orders; DROP TABLE IF EXISTS store_products; DROP TABLE IF EXISTS store_shopping_cart_items; DROP TABLE IF EXISTS store_shopping_carts; DROP TABLE IF EXISTS store_statuses; # # CREATE TABLES # CREATE TABLE ages ( age_id integer auto_increment primary key, age_name varchar(50) null ); CREATE TABLE articles ( article_id integer auto_increment primary key, article_title varchar(50) null, category_id integer null, article_desc text null, date_add datetime null, date_end datetime null ); CREATE TABLE countries ( country_id integer auto_increment primary key, country_name varchar(50) null ); CREATE TABLE directory_categories ( category_id integer auto_increment primary key, category_name varchar(50) null, category_id_parent integer null ); CREATE TABLE directory_items ( item_id integer auto_increment primary key, item_name varchar(50) null, address varchar(50) null, city varchar(50) null, phone varchar(50) null, state_id integer null, zip varchar(50) null, category_id integer null, note text null, email varchar(50) null, url varchar(50) null ); CREATE TABLE educations ( education_id integer auto_increment primary key, education_name varchar(50) null ); CREATE TABLE event_categories ( category_id integer auto_increment primary key, category_name varchar(50) null ); CREATE TABLE events ( event_id integer auto_increment primary key, category_id integer null, is_approve integer null, user_id_approve_by integer null, date_add datetime null, date_start datetime null, date_end datetime null, event_name text null, event_desc text null, presenter varchar(50) null, location text null, location_url varchar(50) null, image_url varchar(50) null, fee varchar(50) null, user_id_add integer null ); CREATE TABLE forum_messages ( message_id integer auto_increment primary key, message_id_parent integer null, message_title varchar(50) null, author varchar(50) null, message_desc text null, date_add datetime null, date_update datetime null, smile_id integer null ); CREATE TABLE genders ( gender_id integer auto_increment primary key, gender_name varchar(50) null ); CREATE TABLE incomes ( income_id integer auto_increment primary key, income_name varchar(50) null ); CREATE TABLE languages ( language_id integer auto_increment primary key, language_name varchar(50) null ); CREATE TABLE link_categories ( category_id integer auto_increment primary key, category_name varchar(50) not null, category_id_parent integer null ); CREATE TABLE links ( link_id integer auto_increment primary key, category_id integer not null, link_name varchar(50) not null, link_url varchar(50) not null, link_desc text null, address text null, user_id_add_by integer null, date_add datetime null, date_approve datetime null, date_update datetime null, is_approve integer null, user_id_approve_by integer null ); CREATE TABLE news ( news_id integer auto_increment primary key, news_desc text null ); CREATE TABLE officers ( officer_id integer auto_increment primary key, officer_name varchar(50) not null, officer_position varchar(50) null, officer_email varchar(50) null ); CREATE TABLE smiles ( smile_id integer primary key, smile_name varchar(50) null, smile_url varchar(50) null ); CREATE TABLE states ( state_id integer auto_increment primary key, state_name varchar(50) null ); CREATE TABLE users ( user_id integer auto_increment primary key, user_login varchar(50) null, user_password varchar(50) null, first_name varchar(50) null, last_name varchar(50) null, title varchar(50) null, group_id integer null, phone_home varchar(50) null, phone_work varchar(50) null, phone_day varchar(50) null, phone_cell varchar(50) null, phone_evening varchar(50) null, fax varchar(50) null, email varchar(50) null, notes text null, card_number varchar(50) null, card_expire_date varchar(50) null, country_id integer null, state_id integer null, city varchar(50) null, zip varchar(50) null, address1 varchar(50) null, address2 varchar(50) null, address3 varchar(50) null, date_add datetime null, date_last_login datetime null, ip_add varchar(50) null, ip_update varchar(50) null, language_id integer null, image_url varchar(50) null, age_id integer null, gender_id integer null, education_id integer null, income_id integer null, user_SSN varchar(50) NULL ); CREATE TABLE user_groups ( group_id integer primary key, group_name varchar(50) null ); ### # CREATE STORE TABLES ### CREATE TABLE store_categories ( category_id integer auto_increment primary key, category_name varchar(50) NOT NULL ) ; CREATE TABLE store_editorial_categories ( category_id integer auto_increment primary key, category_name varchar(50) NULL ); CREATE TABLE store_editorial_products ( article_id integer auto_increment primary key, editorial_cat_id integer NULL , article_title varchar(200) NULL , article_desc text NULL , product_id integer NULL ); CREATE TABLE store_order_items ( order_item_id integer auto_increment primary key, order_id integer NULL , product_id integer NULL , quantity integer NULL , price real NULL ); CREATE TABLE store_orders ( order_id integer auto_increment primary key, user_id int NULL , order_date datetime NULL, order_status_id integer NOT NULL, total real NULL ); CREATE TABLE store_products ( product_id integer auto_increment primary key, category_id integer NOT NULL, product_name varchar(255) NOT NULL, price float NOT NULL, image_url varchar(100) NULL, description text NULL, is_recommended integer NULL ); CREATE TABLE store_shopping_cart_items ( shopping_cart_item_id integer auto_increment primary key, shopping_cart_id integer NULL , product_id integer NULL , quantity integer NULL ); CREATE TABLE store_shopping_carts ( shopping_cart_id integer auto_increment primary key, date_add datetime NULL ); CREATE TABLE store_statuses ( status_id integer auto_increment primary key, status_name varchar(50) NULL ); # # TABLE INSERT STATEMENTS # INSERT INTO ages(age_id,age_name) VALUES(1,'less than 13'); INSERT INTO ages(age_id,age_name) VALUES(2,'13-17'); INSERT INTO ages(age_id,age_name) VALUES(3,'18-24'); INSERT INTO ages(age_id,age_name) VALUES(4,'25-34'); INSERT INTO ages(age_id,age_name) VALUES(5,'35-50'); INSERT INTO ages(age_id,age_name) VALUES(6,'51-65'); INSERT INTO ages(age_id,age_name) VALUES(7,'over 65'); INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end) VALUES(1,'Silicon Valley Engineers Club',6,'<font color=\"navy\"><b>Silicon Valley Engineers Club is a technical and social organization. Our members are mostly, but not exclusively residing in the greater San Francisco Bay Area.</b></font><br> The Engineers'' Club has offices at the 215 South 16th Street in San Francisco. The Club office is manned four days a week by a volunteer staff. James Morton is the Executive Director and President. He is also the elected Secretary and Treasurer. Tom McDonald joined James at the office in 1991 and heads the education committee.','2000-12-26 00:00:00','2010-12-31 00:00:00'); INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end) VALUES(2,'A brief history',7,'The Centennial Exposition of 1876 in San Francisco drew engineers from around the world to view the technical advances of that century. It was apparent to engineers residing in California that engineers did not know each other. Charles E. Billin invited twenty or so engineers to his home the following winter for refreshments. This started a series of gatherings at the homes of various engineers. The Club formally organized in December of 1877 and Professor L M. Haupt was its first President. It limited its membership to fifty. The minutes of the first meeting stated: \"Its object shall be the professional improvement of its members, the encouragement of social intercourse among men of practical science, and the advancement of engineering in its several branches.\" The Club adopted as its motto a quotation from George Washington''s speech to the Federal Convention of 1787 accepting the role of president. It expresses the charge placed upon the Engineers Club''s members by its charter. The motto states: \"Let us raise a standard to which the wise and honest can repair.\"','2000-12-26 00:00:00','2010-12-31 00:00:00'); INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end) VALUES(3,'Education',4,'The Silicon Valley Engineers Club is offering courses which meet the needs of many practicing professionals. In today''s rapidly changing world, it is mandatory that we maintain our skills. One effective and enjoyable way to accomplish this goal is the educational program offered by the Engineers Club. We can exchange ideas, share experiences and learn from experts in various fields. You can receive 20 hours of instruction for less than you would commonly pay for a one day seminar. One evening a week means that you do not have to take valuable time from the job, nor need you make great personal sacrifices to enhance your career. Make the commitment now to invest in your professional development.','2000-12-26 00:00:00','2010-12-31 00:00:00'); INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end) VALUES(4,'Tours of Silicon Valley',3,'Engineering Tours of the Silicon Valley are visits to facilities and sites with a wide variety of technical features to stimulate your interest. They are geared to you, the technical professional. Attend one or more tours. Club membership is not required! You will be impressed by the knowledge and friendliness of the hosts. They are there for you! WHO CAN PARTICIPATE? Anyone. CAN I BRING A GUEST? Yes. DO I HAVE TO BE AN ENGINEERS CLUB MEMBER? No. WHAT DOES IT COST? Each tour is $10.00 per person. However, Engineers'' Club members and one guest may attend at no charge. WHO PROVIDES TRANSPORTATION TO THE FACILITY? You do.','2000-12-26 00:00:00','2010-12-31 00:00:00'); INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end) VALUES(5,'Benefits',5,'<ul> <li>Career Enhancement - A place to meet others in your profession, share ideas and make valuable contacts.</li> <li>Professional development programs, symposiums, and speeches.</li> <li>Seminars, technical presentations, topical meetings with discounts on fees to members.</li> <li>Meetings facilities including 400 seat auditorium, library and meetings rooms.</li> <li>Engineers'' Club annual roster.</li> <li>Silicon Valley Engineer monthly newsletter.</li> </ul>','2000-12-26 00:00:00','2010-12-31 00:00:00'); INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end) VALUES(6,'Membership',7,'The requirements for becoming a member are liberal although applicants are carefully screened for sincerity of interests and whether or not they could benefits from Club membership. The qualifications are only that the applicant be associated with the engineering profession as a result of vocation, hobby or business contact. Each applicant must have two sponsors who are members of the Club. Membership in the Engineers'' Club of St. Louis is one of the best investments a technical man or woman can make.','2000-12-26 00:00:00','2010-12-31 00:00:00'); INSERT INTO articles(article_id,article_title,category_id,article_desc,date_add,date_end) VALUES(7,'Monthly Meetings',7,'The General meetings are held on the third Thursday of each month at the Valley Caffe, corner of Berkeley and Columbus.<br> Park in the lot next to the building on Columbus.<br> Our meetings are also convenient to reach via public transportation. Nearest BART station is Powell. <br><br> Meetings begin at 19:00.','2000-12-26 00:00:00','2010-12-31 00:00:00'); INSERT INTO countries(country_id,country_name) VALUES(1,'United States'); INSERT INTO countries(country_id,country_name) VALUES(2,'Canada'); INSERT INTO countries(country_id,country_name) VALUES(3,'Afghanistan'); INSERT INTO countries(country_id,country_name) VALUES(4,'Albania'); INSERT INTO countries(country_id,country_name) VALUES(5,'Algeria'); INSERT INTO countries(country_id,country_name) VALUES(6,'American Samoa'); INSERT INTO countries(country_id,country_name) VALUES(7,'Andorra'); INSERT INTO countries(country_id,country_name) VALUES(8,'Angola'); INSERT INTO countries(country_id,country_name) VALUES(9,'Anguilla'); INSERT INTO countries(country_id,country_name) VALUES(10,'Antarctica'); INSERT INTO countries(country_id,country_name) VALUES(11,'Antigua and Barbuda'); INSERT INTO countries(country_id,country_name) VALUES(12,'Argentina'); INSERT INTO countries(country_id,country_name) VALUES(13,'Armenia'); INSERT INTO countries(country_id,country_name) VALUES(14,'Aruba'); INSERT INTO countries(country_id,country_name) VALUES(15,'Australia'); INSERT INTO countries(country_id,country_name) VALUES(16,'Austria'); INSERT INTO countries(country_id,country_name) VALUES(17,'Azerbaijan'); INSERT INTO countries(country_id,country_name) VALUES(18,'Bahamas'); INSERT INTO countries(country_id,country_name) VALUES(19,'Bahrain'); INSERT INTO countries(country_id,country_name) VALUES(20,'Bangladesh'); INSERT INTO countries(country_id,country_name) VALUES(21,'Barbados'); INSERT INTO countries(country_id,country_name) VALUES(22,'Belarus'); INSERT INTO countries(country_id,country_name) VALUES(23,'Belgium'); INSERT INTO countries(country_id,country_name) VALUES(24,'Belize'); INSERT INTO countries(country_id,country_name) VALUES(25,'Benin'); INSERT INTO countries(country_id,country_name) VALUES(26,'Bermuda'); INSERT INTO countries(country_id,country_name) VALUES(27,'Bhutan'); INSERT INTO countries(country_id,country_name) VALUES(28,'Bolivia'); INSERT INTO countries(country_id,country_name) VALUES(29,'Bosnia and Herzegovina'); INSERT INTO countries(country_id,country_name) VALUES(30,'Botswana'); INSERT INTO countries(country_id,country_name) VALUES(31,'Bouvet Island'); INSERT INTO countries(country_id,country_name) VALUES(32,'Brazil'); INSERT INTO countries(country_id,country_name) VALUES(33,'British Indian Ocean Territory'); INSERT INTO countries(country_id,country_name) VALUES(34,'British Virgin Islands'); INSERT INTO countries(country_id,country_name) VALUES(35,'Brunei'); INSERT INTO countries(country_id,country_name) VALUES(36,'Bulgaria'); INSERT INTO countries(country_id,country_name) VALUES(37,'Burkina Faso'); INSERT INTO countries(country_id,country_name) VALUES(38,'Burundi'); INSERT INTO countries(country_id,country_name) VALUES(39,'Cambodia'); INSERT INTO countries(country_id,country_name) VALUES(40,'Cameroon'); INSERT INTO countries(country_id,country_name) VALUES(41,'Cape Verde'); INSERT INTO countries(country_id,country_name) VALUES(42,'Cayman Islands'); INSERT INTO countries(country_id,country_name) VALUES(43,'Central African Republic'); INSERT INTO countries(country_id,country_name) VALUES(44,'Chad'); INSERT INTO countries(country_id,country_name) VALUES(45,'Chile'); INSERT INTO countries(country_id,country_name) VALUES(46,'China'); INSERT INTO countries(country_id,country_name) VALUES(47,'Christmas Island'); INSERT INTO countries(country_id,country_name) VALUES(48,'Cocos Islands'); INSERT INTO countries(country_id,country_name) VALUES(49,'Colombia'); INSERT INTO countries(country_id,country_name) VALUES(50,'Comoros'); INSERT INTO countries(country_id,country_name) VALUES(51,'Congo'); INSERT INTO countries(country_id,country_name) VALUES(52,'Cook Islands'); INSERT INTO countries(country_id,country_name) VALUES(53,'Costa Rica'); INSERT INTO countries(country_id,country_name) VALUES(54,'Croatia'); INSERT INTO countries(country_id,country_name) VALUES(55,'Cuba'); INSERT INTO countries(country_id,country_name) VALUES(56,'Cyprus'); INSERT INTO countries(country_id,country_name) VALUES(57,'Czech Republic'); INSERT INTO countries(country_id,country_name) VALUES(58,'Denmark'); INSERT INTO countries(country_id,country_name) VALUES(59,'Djibouti'); INSERT INTO countries(country_id,country_name) VALUES(60,'Dominica'); INSERT INTO countries(country_id,country_name) VALUES(61,'Dominican Republic'); INSERT INTO countries(country_id,country_name) VALUES(62,'East Timor'); INSERT INTO countries(country_id,country_name) VALUES(63,'Ecuador'); INSERT INTO countries(country_id,country_name) VALUES(64,'Egypt'); INSERT INTO countries(country_id,country_name) VALUES(65,'El Salvador'); INSERT INTO countries(country_id,country_name) VALUES(66,'Equatorial Guinea'); INSERT INTO countries(country_id,country_name) VALUES(67,'Eritrea'); INSERT INTO countries(country_id,country_name) VALUES(68,'Estonia'); INSERT INTO countries(country_id,country_name) VALUES(69,'Ethiopia'); INSERT INTO countries(country_id,country_name) VALUES(70,'Falkland Islands'); INSERT INTO countries(country_id,country_name) VALUES(71,'Faroe Islands'); INSERT INTO countries(country_id,country_name) VALUES(72,'Fiji'); INSERT INTO countries(country_id,country_name) VALUES(73,'Finland'); INSERT INTO countries(country_id,country_name) VALUES(74,'France'); INSERT INTO countries(country_id,country_name) VALUES(75,'French Guiana'); INSERT INTO countries(country_id,country_name) VALUES(76,'French Polynesia'); INSERT INTO countries(country_id,country_name) VALUES(77,'French Southern Territories'); INSERT INTO countries(country_id,country_name) VALUES(78,'Gabon'); INSERT INTO countries(country_id,country_name) VALUES(79,'Gambia'); INSERT INTO countries(country_id,country_name) VALUES(80,'Georgia'); INSERT INTO countries(country_id,country_name) VALUES(81,'Germany'); INSERT INTO countries(country_id,country_name) VALUES(82,'Ghana'); INSERT INTO countries(country_id,country_name) VALUES(83,'Gibraltar'); INSERT INTO countries(country_id,country_name) VALUES(84,'Greece'); INSERT INTO countries(country_id,country_name) VALUES(85,'Greenland'); INSERT INTO countries(country_id,country_name) VALUES(86,'Grenada'); INSERT INTO countries(country_id,country_name) VALUES(87,'Guadeloupe'); INSERT INTO countries(country_id,country_name) VALUES(88,'Guam'); INSERT INTO countries(country_id,country_name) VALUES(89,'Guatemala'); INSERT INTO countries(country_id,country_name) VALUES(90,'Guinea'); INSERT INTO countries(country_id,country_name) VALUES(91,'Guinea-Bissau'); INSERT INTO countries(country_id,country_name) VALUES(92,'Guyana'); INSERT INTO countries(country_id,country_name) VALUES(93,'Haiti'); INSERT INTO countries(country_id,country_name) VALUES(94,'Heard and McDonald Islands'); INSERT INTO countries(country_id,country_name) VALUES(95,'Honduras'); INSERT INTO countries(country_id,country_name) VALUES(96,'Hong Kong'); INSERT INTO countries(country_id,country_name) VALUES(97,'Hungary'); INSERT INTO countries(country_id,country_name) VALUES(98,'Iceland'); INSERT INTO countries(country_id,country_name) VALUES(99,'India'); INSERT INTO countries(country_id,country_name) VALUES(100,'Indonesia'); INSERT INTO countries(country_id,country_name) VALUES(101,'Iran'); INSERT INTO countries(country_id,country_name) VALUES(102,'Iraq'); INSERT INTO countries(country_id,country_name) VALUES(103,'Ireland'); INSERT INTO countries(country_id,country_name) VALUES(104,'Israel'); INSERT INTO countries(country_id,country_name) VALUES(105,'Italy'); INSERT INTO countries(country_id,country_name) VALUES(106,'Ivory Coast'); INSERT INTO countries(country_id,country_name) VALUES(107,'Jamaica'); INSERT INTO countries(country_id,country_name) VALUES(108,'Japan'); INSERT INTO countries(country_id,country_name) VALUES(109,'Jordan'); INSERT INTO countries(country_id,country_name) VALUES(110,'Kazakhstan'); INSERT INTO countries(country_id,country_name) VALUES(111,'Kenya'); INSERT INTO countries(country_id,country_name) VALUES(112,'Kiribati'); INSERT INTO countries(country_id,country_name) VALUES(113,'North Korea'); INSERT INTO countries(country_id,country_name) VALUES(114,'South Korea'); INSERT INTO countries(country_id,country_name) VALUES(115,'Kuwait'); INSERT INTO countries(country_id,country_name) VALUES(116,'Kyrgyzstan'); INSERT INTO countries(country_id,country_name) VALUES(117,'Laos'); INSERT INTO countries(country_id,country_name) VALUES(118,'Latvia'); INSERT INTO countries(country_id,country_name) VALUES(119,'Lebanon'); INSERT INTO countries(country_id,country_name) VALUES(120,'Lesotho'); INSERT INTO countries(country_id,country_name) VALUES(121,'Liberia'); INSERT INTO countries(country_id,country_name) VALUES(122,'Libya'); INSERT INTO countries(country_id,country_name) VALUES(123,'Liechtenstein'); INSERT INTO countries(country_id,country_name) VALUES(124,'Lithuania'); INSERT INTO countries(country_id,country_name) VALUES(125,'Luxembourg'); INSERT INTO countries(country_id,country_name) VALUES(126,'Macau'); INSERT INTO countries(country_id,country_name) VALUES(127,'Macedonia'); INSERT INTO countries(country_id,country_name) VALUES(128,'Madagascar'); INSERT INTO countries(country_id,country_name) VALUES(129,'Malawi'); INSERT INTO countries(country_id,country_name) VALUES(130,'Malaysia'); INSERT INTO countries(country_id,country_name) VALUES(131,'Maldives'); INSERT INTO countries(country_id,country_name) VALUES(132,'Mali'); INSERT INTO countries(country_id,country_name) VALUES(133,'Malta'); INSERT INTO countries(country_id,country_name) VALUES(134,'Marshall Islands'); INSERT INTO countries(country_id,country_name) VALUES(135,'Martinique'); INSERT INTO countries(country_id,country_name) VALUES(136,'Mauritania'); INSERT INTO countries(country_id,country_name) VALUES(137,'Mauritius'); INSERT INTO countries(country_id,country_name) VALUES(138,'Mayotte'); INSERT INTO countries(country_id,country_name) VALUES(139,'Mexico'); INSERT INTO countries(country_id,country_name) VALUES(140,'Micronesia'); INSERT INTO countries(country_id,country_name) VALUES(141,'Moldova'); INSERT INTO countries(country_id,country_name) VALUES(142,'Monaco'); INSERT INTO countries(country_id,country_name) VALUES(143,'Mongolia'); INSERT INTO countries(country_id,country_name) VALUES(144,'Montserrat'); INSERT INTO countries(country_id,country_name) VALUES(145,'Morocco'); INSERT INTO countries(country_id,country_name) VALUES(146,'Mozambique'); INSERT INTO countries(country_id,country_name) VALUES(147,'Myanmar'); INSERT INTO countries(country_id,country_name) VALUES(148,'Namibia'); INSERT INTO countries(country_id,country_name) VALUES(149,'Nauru'); INSERT INTO countries(country_id,country_name) VALUES(150,'Nepal'); INSERT INTO countries(country_id,country_name) VALUES(151,'Netherlands'); INSERT INTO countries(country_id,country_name) VALUES(152,'Netherlands Antilles'); INSERT INTO countries(country_id,country_name) VALUES(153,'New Caledonia'); INSERT INTO countries(country_id,country_name) VALUES(154,'New Zealand'); INSERT INTO countries(country_id,country_name) VALUES(155,'Nicaragua'); INSERT INTO countries(country_id,country_name) VALUES(156,'Niger'); INSERT INTO countries(country_id,country_name) VALUES(157,'Nigeria'); INSERT INTO countries(country_id,country_name) VALUES(158,'Niue'); INSERT INTO countries(country_id,country_name) VALUES(159,'Norfolk Island'); INSERT INTO countries(country_id,country_name) VALUES(160,'Northern Mariana Islands'); INSERT INTO countries(country_id,country_name) VALUES(161,'Norway'); INSERT INTO countries(country_id,country_name) VALUES(162,'Oman'); INSERT INTO countries(country_id,country_name) VALUES(163,'Pakistan'); INSERT INTO countries(country_id,country_name) VALUES(164,'Palau'); INSERT INTO countries(country_id,country_name) VALUES(165,'Panama'); INSERT INTO countries(country_id,country_name) VALUES(166,'Papua New Guinea'); INSERT INTO countries(country_id,country_name) VALUES(167,'Paraguay'); INSERT INTO countries(country_id,country_name) VALUES(168,'Peru'); INSERT INTO countries(country_id,country_name) VALUES(169,'Philippines'); INSERT INTO countries(country_id,country_name) VALUES(170,'Pitcairn Island'); INSERT INTO countries(country_id,country_name) VALUES(171,'Poland'); INSERT INTO countries(country_id,country_name) VALUES(172,'Portugal'); INSERT INTO countries(country_id,country_name) VALUES(173,'Puerto Rico'); INSERT INTO countries(country_id,country_name) VALUES(174,'Qatar'); INSERT INTO countries(country_id,country_name) VALUES(175,'Reunion'); INSERT INTO countries(country_id,country_name) VALUES(176,'Romania'); INSERT INTO countries(country_id,country_name) VALUES(177,'Russia'); INSERT INTO countries(country_id,country_name) VALUES(178,'Rwanda'); INSERT INTO countries(country_id,country_name) VALUES(179,'S. Georgia and S. Sandwich Isls.'); INSERT INTO countries(country_id,country_name) VALUES(180,'Saint Kitts & Nevis'); INSERT INTO countries(country_id,country_name) VALUES(181,'Saint Lucia'); INSERT INTO countries(country_id,country_name) VALUES(182,'Saint Vincent and The Grenadines'); INSERT INTO countries(country_id,country_name) VALUES(183,'Samoa'); INSERT INTO countries(country_id,country_name) VALUES(184,'San Marino'); INSERT INTO countries(country_id,country_name) VALUES(185,'Sao Tome and Principe'); INSERT INTO countries(country_id,country_name) VALUES(186,'Saudi Arabia'); INSERT INTO countries(country_id,country_name) VALUES(187,'Senegal'); INSERT INTO countries(country_id,country_name) VALUES(188,'Seychelles'); INSERT INTO countries(country_id,country_name) VALUES(189,'Sierra Leone'); INSERT INTO countries(country_id,country_name) VALUES(190,'Singapore'); INSERT INTO countries(country_id,country_name) VALUES(191,'Slovakia'); INSERT INTO countries(country_id,country_name) VALUES(192,'Slovenia'); INSERT INTO countries(country_id,country_name) VALUES(193,'Somalia'); INSERT INTO countries(country_id,country_name) VALUES(194,'South Africa'); INSERT INTO countries(country_id,country_name) VALUES(195,'Spain'); INSERT INTO countries(country_id,country_name) VALUES(196,'Sri Lanka'); INSERT INTO countries(country_id,country_name) VALUES(197,'St. Helena'); INSERT INTO countries(country_id,country_name) VALUES(198,'St. Pierre and Miquelon'); INSERT INTO countries(country_id,country_name) VALUES(199,'Sudan'); INSERT INTO countries(country_id,country_name) VALUES(200,'Suriname'); INSERT INTO countries(country_id,country_name) VALUES(201,'Svalbard and Jan Mayen Islands'); INSERT INTO countries(country_id,country_name) VALUES(202,'Swaziland'); INSERT INTO countries(country_id,country_name) VALUES(203,'Sweden'); INSERT INTO countries(country_id,country_name) VALUES(204,'Switzerland'); INSERT INTO countries(country_id,country_name) VALUES(205,'Syria'); INSERT INTO countries(country_id,country_name) VALUES(206,'Taiwan'); INSERT INTO countries(country_id,country_name) VALUES(207,'Tajikistan'); INSERT INTO countries(country_id,country_name) VALUES(208,'Tanzania'); INSERT INTO countries(country_id,country_name) VALUES(209,'Thailand'); INSERT INTO countries(country_id,country_name) VALUES(210,'Togo'); INSERT INTO countries(country_id,country_name) VALUES(211,'Tokelau'); INSERT INTO countries(country_id,country_name) VALUES(212,'Tonga'); INSERT INTO countries(country_id,country_name) VALUES(213,'Trinidad and Tobago'); INSERT INTO countries(country_id,country_name) VALUES(214,'Tunisia'); INSERT INTO countries(country_id,country_name) VALUES(215,'Turkey'); INSERT INTO countries(country_id,country_name) VALUES(216,'Turkmenistan'); INSERT INTO countries(country_id,country_name) VALUES(217,'Turks and Caicos Islands'); INSERT INTO countries(country_id,country_name) VALUES(218,'Tuvalu'); INSERT INTO countries(country_id,country_name) VALUES(219,'U.S. Minor Outlying Islands'); INSERT INTO countries(country_id,country_name) VALUES(220,'Uganda'); INSERT INTO countries(country_id,country_name) VALUES(221,'Ukraine'); INSERT INTO countries(country_id,country_name) VALUES(222,'United Arab Emirates'); INSERT INTO countries(country_id,country_name) VALUES(223,'United Kingdom'); INSERT INTO countries(country_id,country_name) VALUES(224,'Uruguay'); INSERT INTO countries(country_id,country_name) VALUES(225,'Uzbekistan'); INSERT INTO countries(country_id,country_name) VALUES(226,'Vanuatu'); INSERT INTO countries(country_id,country_name) VALUES(227,'Vatican City'); INSERT INTO countries(country_id,country_name) VALUES(228,'Venezuela'); INSERT INTO countries(country_id,country_name) VALUES(229,'Vietnam'); INSERT INTO countries(country_id,country_name) VALUES(230,'Virgin Islands'); INSERT INTO countries(country_id,country_name) VALUES(231,'Wallis and Futuna Islands'); INSERT INTO countries(country_id,country_name) VALUES(232,'Western Sahara'); INSERT INTO countries(country_id,country_name) VALUES(233,'Yemen'); INSERT INTO countries(country_id,country_name) VALUES(234,'Serbia and Montenegro'); INSERT INTO countries(country_id,country_name) VALUES(235,'Zaire'); INSERT INTO countries(country_id,country_name) VALUES(236,'Zambia'); INSERT INTO countries(country_id,country_name) VALUES(237,'Zimbabwe'); INSERT INTO educations(education_id,education_name) VALUES(1,'High School'); INSERT INTO educations(education_id,education_name) VALUES(2,'College'); INSERT INTO educations(education_id,education_name) VALUES(3,'Graduate School'); INSERT INTO educations(education_id,education_name) VALUES(4,'Other'); INSERT INTO event_categories(category_id,category_name) VALUES(1,'Science'); INSERT INTO event_categories(category_id,category_name) VALUES(2,'Museums'); INSERT INTO event_categories(category_id,category_name) VALUES(3,'Computers'); INSERT INTO event_categories(category_id,category_name) VALUES(4,'Business'); INSERT INTO event_categories(category_id,category_name) VALUES(5,'Internet'); INSERT INTO event_categories(category_id,category_name) VALUES(6,'Education'); INSERT INTO event_categories(category_id,category_name) VALUES(7,'Career'); INSERT INTO event_categories(category_id,category_name) VALUES(8,'History'); INSERT INTO event_categories(category_id,category_name) VALUES(9,'Club Information'); INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add) VALUES(1,null,null,0,null,'2000-12-01 19:30:00',null,'Marketing Strategy for High Technology Companies with Disruptive Technologies, or Why Smart Engineers Fail in Bringing Advanced Products to Market.','Many high technology developments qualify as discontinuous innovation, which is defined as one that requires a change of customer behavior. There are two generic types of discontinuous innovation: Paradigm shock (e.g., PC replacing a typewriter) Application breakthrough (e.g., voice recognition replacing service personnel) On the opposite end there are continuous innovations, which do not require customer behavior change, e,g., using a new toothpaste. As Silicon Valley marketing guru Regis McKenna once wrote, \"Marketing is Everything\" (and not the technology, engineers). It is thus marketing flow that most often defines a product (and often company) market failure. Selection of a suitable marketing strategy is thus extremely important success factor for high-tech startups. For a continuous innovation, the demand for products gradually increases and after reaching maturity, the demand gradually decreases, as customers already know what to do with the product and how to use it. For a discontinuous innovation, however, there is a gap (called \"chasm\") in customer demand. After attracting small groups of \"techies\" (buying for the sake of having the newest toys) and visionaries (having an idea for a new business based on new technology), the demand evaporates as mainstream customers shy away from the product. Classical marketing technologies failed to attract this group of buyers with deep pockets. Companies that succeeded in crossing the chasm, however, often reach an avalanche growth of sales, defined as \"tornado\". Some of the technologies stuck in Chasm include voice recognition, artificial intelligence, electric car, DSL, high definition TV, smart cards (in the US) and so far majority of MEMS technologies. Some of technologies that died in Chasm include gyroscopic mouse, Newton PDA, Lisa PC and PC Junior. Based on market research of large number of companies with discontinuous innovation, Geoffrey Moore (initially at Regis McKenna Inc., a leading marketing organization in Silicon Valley and later at The Chasm Group) developed a strategy for crossing the chasm (summarized in his books \"Crossing the Chasm\" and \"Inside the Tornado\", A Harper Business Book, 1999). This presentation summarizes Moore findings. It is focused on developing a strategy to cross the Chasm. This strategy requires focusing initially all the company resources on one application in one market segment (\"pin\") and becoming a dominant supplier (a \"gorilla\") in this space. After accomplishing this goal, Company should develop and dominate other pins: either the same application in different market segment or different application in the same segment. After becoming a \"gorilla\" in sufficient number of pins, the \"tornado\" starts, destroying the old technology and establishing the new one, returning the overwhelming market share to the Company. Few examples of Tornadoes include desktop publishing, word processors, spreadsheets, Windows, microprocessors, cell phones, E-mail. Tornadoes created 11 new Billionaires in recent four years! The presentation then introduces a concept of a \"whole product\" and its requirements for increased chance of dominating the application. It follows to define a recommended marketing strategy during the Tornado. Tornado in turn leads to Main Street, a mature market development phase that requires again adaptation of a new marketing strategy. About the Speaker Dr. Bryzek got his MSEE in 1970 and Ph.D. in 1977 from Warsaw Technical University. He completed the executive management program at Stanford University in 1987. He moved to Silicon Valley in 1979. Between 1982 and 2000 he cofounded five successful Silicon Valley high-tech companies based on MEMS technology (MicroElectroMechanical Systems), all introducing products based on disruptive technology. His newest startup founded in March 2000 focuses on optical networking market. One of his technical greatest achievements was the 1981de','Dr. Janusz Bryzek','Blue Star Coffee, 1071 S. DeAnza Blvd, Cupertino 408.863.0707',null,null,null,4); INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add) VALUES(2,null,null,0,null,'2001-01-19 19:30:00',null,'Helping schools develop students'' interest in science and technology: SCVSEFA and science fairs.',NULL,'Kerry Veenstra','TBD',null,null,null,0); INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add) VALUES(3,null,null,0,null,'2000-10-21 18:00:00',null,'Performance of US economy in 2001. More about Dr. Belotti. Pictures.','Our guest speaker will be Prof. Mario Belotti. He will present \"The forecast of the US economy performance in 2001\" Dr Mario Belotti has been teaching at Santa Clara University since 1959. He teaches economics in both the graduate and undergraduate programs. He served as Chair of the Economics Department from 1962 to 1984 and as the Director of the Institute of Agribusiness from 1988 to 1996. His fields of interest are macroeconomics theory, monetary theory and economic development. He organized and chaired 23 Santa Clara University Symposiums and 28 yearly Economic Forecasts. Dr. Belotti spent many summers as an economic consultant in developing countries: Brazil, Honduras, Sudan, Egypt, Iran, Uganda, Kenya, Tanzania, Thailand, Bulgaria, Hungry, Nepal, and Eritrea. Dr. Belotti received a Bachelor of Science in Business Administration and a Master of Arts in Accounting from Midwestern University. He obtained a Ph.D. in Economics from the University of Texas in Austin.','Dr. Mario Belotti, Professor of Economics, Santa C','Hotel Embassy Suites (Diplomat Room), 2885 Lakeside Drive, Santa Clara',null,null,null,0); INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add) VALUES(4,null,null,0,null,'2000-09-22 19:00:00',null,'\"Restructuring of the International energy sector - a combination of economics and politics\".','International market is undergoing a major restructuring of its energy sector. Many power plants were built to burn coal, which some countries claimed to have in unlimited supply. This system created inefficiency, mismanagement and environmental abuse. Piotr Moncarz talk will present the aspects of the International energy market restructuring with an emphasis on the privatization and modernization aspects of investment in small and medium size power plants. About the speaker: Piotr Moncarz was born and raised in Poznan, Poland. For last twenty years he has worked at a high profile consulting company: Exponent Failure Analysis, where he is a Principal Engineer and Corporate Vice President. For last seven years his efforts have included the development of a gas-fired electric power plant at Lake Zarnowiec near Gdansk, on the site of an abandoned project of the first Polish nuclear plant. The promotion of American investment into Polish economy has become his passion, as he believes this to be the most effective political independence insurance Poland can acquire while entering the new century. Piotr Moncarz has Ph.D. in Civil Engineering from Stanford University, where he teaches graduate classes a Consulting Professor.','Piotr D. Moncarz','ACUSON (bldg.I) 1393 Shorebird Way (corner of Shoreline Blvd.), Mountain View',null,null,null,2); INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add) VALUES(5,null,null,0,null,'2000-06-23 19:00:00',null,'On June 23,2000 during the Club monthly meeting, Dr. Zofia Rek presented an interesting lecture about her work experience at Stanford Synchotron Radiation Laboratory where she works since 1980.','On June 23,2000 during the Club monthly meeting, Dr. Zofia Rek presented an interesting lecture about her work experience at Stanford Synchotron Radiation Laboratory where she works since 1980. SSRL is multidisciplinary laboratory funded by Department of Energy and National Institute of Health. Synchrotron radiation is the electromagnetic radiation emitted by electrons along curved trajectory. Most of the experiments are in the X-ray energy range although higher energies in the alfa range can be obtained. Applications are very diversified: X-ray imaging of defects and strains for large crystals for semiconductor wafers to laser windows to study fusion. In biology studies are made to detect and eleminate selenium areas in USA in order to improve the quality of soil. In medicine radiation is used in angiography to detect blockage of heart arteries without invasion of catater and also in studies of osteoporosis. The large part of the lecture was dedicated to protein crytallography as a tool for solving protein structure so important for human genomic project. Zofia also discussed some other works done by SSRL like membrane protein which works as an intelligent guard against cholera toxin and Topoisomerase a protein that is targeted by anti-cancer drugs. There was a very interesting discussion after the lecture and members of the Club had an opportunity to examine numerous models and sampels brought by Zofia.','Zofia Rek, Stanford Synchrotron Radiation Laborato','TBD',null,null,null,0); INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add) VALUES(6,null,null,0,null,'2000-05-19 19:00:00',null,'\"Issues in Software Development Evolution - a Veteran Practitioner''s Point of View\".','On May meeting Dr. Zbigniew Sufleta has entertained PAEC club with the presentation on the subject of Software Development Process, the Practitioner''s point of view. His extensive industry experience (over 20 years) gave his listeners a rare opportunity to hear about the process itself, the principles and what applies in the real life. The speech has concluded with a round table discussion about the current market conditions and the impact it bears on the Bay area living conditions (tight labor market, escalating salaries, booming real estate, traffic congestions).','Dr. Zbigniew Sufleta','TBD',null,null,null,0); INSERT INTO events(event_id,category_id,is_approve,user_id_approve_by,date_add,date_start,date_end,event_name,event_desc,presenter,location,location_url,image_url,fee,user_id_add) VALUES(7,null,null,0,null,'2000-03-24 19:00:00',null,'Problems with the manpower in Hi-Tech industry in Silicon Valley.',NULL,'Prof. Aleksander Liniecki, San Jose State Universi','The Clubhouse in \"Sunset Oaks\" townhouse complex. 675 Picasso Terrace, Sunnyvale.','http://sunsetoaks.org/location.html#http://sunseto',null,null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(1,null,'error message!!! in DB MSG','seopo','I have a problem in DB MSG at brinkster It is in a SQL statement... ''select * from tablename''--> It is well operated... But ''delete from tablename'' or ''update set No =1 where No=3...etc''----> It is not well operated.... There appears error message It is..... Query Results ADODB.Recordset error ''800a0e78'' Operation is not allowed when the object is closed. /DatabaseManager.asp, line 473 \"\" I want to find a way... please! give me an answer....','2001-01-04 11:28:00',null,8); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(2,1,'RE: error message!!! in DB MSG','nhsa','DELETE * FROM tablename WHERE stringfield=''stringvalue'' UPDATE tablename SET stringfield=''hello'' WHERE numberfield=10 HTH Nige - nhsa@yahoo.com','2001-01-04 15:00:00',null,2); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(3,1,'RE: error message!!! in DB MSG','hiflyer','Nige is right with his SQL string examples, but the error you are getting is because you are trying to perform operations on a recordset which has been closed. If you look at your code you will probably find a line such as dbConn.close, or RS.close or Set RS = nothing somewhere before line 473. HTH, Bod. www5.brinkster.com/hiflyer','2001-01-05 04:28:00',null,3); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(4,null,'writing db results to multiple pages','shiaislamasp','how do i write say 10 db results, from a select statement, on a page, then link to another page, with the next 10, and so on.. I would be very grateful for any help Thank you','2001-01-04 19:56:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(5,4,'RE: writing db results to multiple pages','adom','Asuming your database is sorted by a incrementing value you can use the BETWEEN statement in your querry. That is on the first page you do: SELECT * from Table WHERE OrderValue BETWEEN 1 and 10 Then you pass along the last value to the next page \"\"show_rewults?start=11\"\" for example and go from there SELECT * from Table WHERE OrderValue BETWEEN 11 and 20 and so on?','2001-01-05 03:33:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(6,null,'what is this error... It works on my iis','feiyeung','keyword =url =comment = there is an error Microsoft JET Database Engine error ''80040e09'' Cannot update. Database or object is read-only. /input.asp, line 39 it wokrs on my iis5.0 fine. It is because the db dir isn''t set rite or what? anyone has any ideaS FELIX','2001-01-04 05:02:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(7,null,'dynamic queries','vpl','i want to rerieve the value from the database based upon the selection criteria that is out of ten text fields if the user select two values means,i should get the output based upon that value.the query should be a single query.','2001-01-03 03:21:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(8,7,'RE: dynamic queries','product','The Best Way is to write SQl Statement . For Example Select Empno,Ename from emp where empno = ''1001'' or Sal >100 if you can provide a code, will try to provide a solution.','2001-01-03 06:49:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(9,null,'CF Custom Tag directory???','Michael','Hi, how do i change the default directory of the CUSTOM TAG where CF_ tags are places to a directory of my choice???? thankxs','2001-01-19 17:18:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(10,9,'CF Custom Tag directory???','vpl','You can edit the registry key HKEY_LOCAL_MACHINESOFTWAREAllaireColdFusionCurrentVersionCustomTagsCFMLTagSearchPath And then restart the server. /Ruben','2001-01-19 17:45:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(11,null,'Pictures embeded in Email','Rocky Ang','I am trying to use the cfmail command to send HTML based emails. This can be easily done by referencing the pictures within the mail to download from an url. However, this caused a problem when the recipient tries to read the mail offline. The pictures disappeared. A way to solve this would be to embed the pictures and send the pictures with the mail. Is there any way to do this with cold fusion. Any prompt help would be deeply appreciated by a desperate guy.','2001-01-19 17:37:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(12,11,'relative','Glenn Channon','Try relative URL''s http://www.domainname.com/images/imagename.gif','2001-01-19 18:37:00',null,0); INSERT INTO forum_messages(message_id,message_id_parent,message_title,author,message_desc,date_add,date_update,smile_id) VALUES(13,12,'No Use','feiyeung','No use, when the user is offline and tries to read the mail the pictures are missing. The pictures are ok when the user is online','2001-01-19 18:45:00',null,8); INSERT INTO genders(gender_id,gender_name) VALUES(1,'Male'); INSERT INTO genders(gender_id,gender_name) VALUES(2,'Female'); INSERT INTO incomes(income_id,income_name) VALUES(1,'under $25,000'); INSERT INTO incomes(income_id,income_name) VALUES(2,'$25,000 - $34,000'); INSERT INTO incomes(income_id,income_name) VALUES(3,'$35,000 - $49,000'); INSERT INTO incomes(income_id,income_name) VALUES(4,'$50,000 - $74,000'); INSERT INTO incomes(income_id,income_name) VALUES(5,'over $75,000'); INSERT INTO languages(language_id,language_name) VALUES(1,'English'); INSERT INTO languages(language_id,language_name) VALUES(2,'French'); INSERT INTO languages(language_id,language_name) VALUES(3,'German'); INSERT INTO languages(language_id,language_name) VALUES(4,'Chinese'); INSERT INTO languages(language_id,language_name) VALUES(5,'Japanese'); INSERT INTO languages(language_id,language_name) VALUES(6,'Russian'); INSERT INTO languages(language_id,language_name) VALUES(7,'Polish'); INSERT INTO languages(language_id,language_name) VALUES(8,'Turkish'); INSERT INTO languages(language_id,language_name) VALUES(9,'Yiddish'); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(1,'Announcements',null); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(2,'Autos & Motorcycles',null); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(3,'Business Opportunities',null); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(4,'Computers & Software',null); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(5,'Employment',null); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(6,'Services',null); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(7,'Pets & Animals',null); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(8,'Anniversaries',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(9,'Auctions',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(10,'Births',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(11,'Bookgroups',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(12,'Bris/Christenings',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(13,'Coupons',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(14,'Promotion',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(15,'Clubs/Organizations',1); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(16,'Car',2); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(17,'Motorcycle',2); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(18,'Truck',2); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(19,'Van',2); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(20,'Sport Utility and Jeeps',2); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(21,'Casinos',3); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(22,'Apparel',3); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(23,'Computers and Internet',3); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(24,'Food and Beverage',3); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(25,'Marketing',3); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(26,'Travel and Transportation',3); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(27,'Telecommunications',3); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(28,'Legal Services',6); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(29,'Home & Garden',6); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(30,'Entertainment and Arts',6); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(31,'Administrative and Corporate',5); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(32,'Media, Arts, and Design',5); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(33,'Facilities Management and Maintenance',5); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(34,'Financial Services',5); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(35,'Health Care',5); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(36,'Information Technology',5); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(37,'Engineering',5); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(38,'Dogs',7); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(39,'Cats',7); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(40,'Fish and Aquariums',7); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(41,'Miscellaneous Supplies',7); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(42,'Reptiles',7); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(43,'Domain Names',4); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(44,'Hardware',4); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(45,'Software',4); INSERT INTO link_categories(category_id,category_name,category_id_parent) VALUES(46,'Networking',4); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(1,6,'TheTech Museum of Innovation','http://www.thetech.org/','The Tech Museum of Innovation in San Jose, California is a hands-on technology museum devoted to inspiring the innovator in everyone.','201 South Market Street San Jose, CA 95113 408-294-TECH',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(2,5,'Lawrence Livermore National Laboratory','http://www.llnl.gov/','Lawrence Livermore National Laboratory ensures national security and applies science and technology to important problems of our time.','7000 East Ave., Livermore, CA 94550-9234',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(3,10,'Monterey Bay Aquarium','http://www.mbayaq.org/sg','The Monterey Bay Aquarium is dedicated to inspiring ocean conservation. Find out more about how we approach our mission.','201 South Market Street San Jose, CA 95113',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(4,5,'Chabot Space & Science Center','http://www.cosc.org/','At Chabot Space & Science Center (CSSC), the universe is yours to experience. Set amid 13 trail-laced acres of East Bay parkland, with glorious views of San Francisco Bay and the Oakland foothills, CSSC is a hands-on celebration of sights, sounds, and sensations.','10000 Skyline Blvd. Oakland, CA 94619',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(5,5,'UC Observatories/Lick Observatory','http://www.ucolick.org/','University of California Observatories/Lick Observatory conducts leading-edge research to answer the most profound questions in observational astronomy.','University of California, Santa Cruz, CA 95064 Phone: 831/459-2513; Fax: 831/426-3115',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(6,6,'San Francisco Cable Car Museum','http://www.cablecarmuseum.com/','The cable car was born in San Francisco at four o''clock in the morning on August 2, 1873, when Andrew Smith Hallidie successfully tested the world''s first cable car. Operated by the nonprofit \"Friends of the Cable Car Museum\" the Cable Car Museum provides not only an historical perspective of the importance of the cable car to San Francisco, but an insight into the daily operations of today''s system.','1201 Mason Street at Washington, San Francisco.',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(7,5,'NASA Ames Research Center','http://www.arc.nasa.gov/about_ames','Ames was founded December 20, 1939 as an aircraft research laboratory by the National Advisory Committee on Aeronautics (NACA) and in 1958 became part of National Aeronautics and Space Administration (NASA). Ames specializes in research geared toward creating new knowledge and new technologies that span the spectrum of NASA interests.','NASA Ames Research Center is located at Moffett Field, California in the heart of \"Silicon Valley\".',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO links(link_id,category_id,link_name,link_url,link_desc,address,user_id_add_by,date_add,date_approve,date_update,is_approve,user_id_approve_by) VALUES(8,10,'Berkeley Lab','http://www.lbl.gov/','Berkeley Lab is a multidisciplinary national laboratory that conducts nonclassified research. We are located in Berkeley, California on a site in the hills directly above the campus of the University of California at Berkeley. Overlooking both the campus and San Francisco Bay, the site consists of 76 buildings located on 183 acres.','201 South Market Street San Jose, CA 95113 408-294-TECH',0,'2000-12-26 00:00:00',null,null,1,null); INSERT INTO news(news_id,news_desc) VALUES(1,'<script language=\"JavaScript\" type=\"text/javascript\" src=\"http://www.oreillynet.com/meerkat/?m=296&_fl=js\"></script>'); INSERT INTO officers(officer_id,officer_name,officer_position,officer_email) VALUES(1,'James Morton','President','jmorton@nowhere.com'); INSERT INTO officers(officer_id,officer_name,officer_position,officer_email) VALUES(2,'Adam Bryzek','Vice President','adam@nowhere.com'); INSERT INTO officers(officer_id,officer_name,officer_position,officer_email) VALUES(3,'Matt Vaughn','Vice President','mvaughn@nowhere.com'); INSERT INTO officers(officer_id,officer_name,officer_position,officer_email) VALUES(4,'Bob Newell','Secretary','bnewell@nowhere.com'); INSERT INTO officers(officer_id,officer_name,officer_position,officer_email) VALUES(5,'Sabrina Rek','Treasurer','srek@nowhere.com'); INSERT INTO officers(officer_id,officer_name,officer_position,officer_email) VALUES(6,'Jamie McCants','Webmaster','jmccants@nowhere.com'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(0,'no smile','<img src="images/0-0.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(1,'smile','<img src="images/icons/smile.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(2,'mad','<img src="images/icons/mad.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(3,'sad','<img src="images/icons/sad.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(4,'big grin','<img src="images/icons/biggrin.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(5,'colgate','<img src="images/icons/colgate.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(6,'confused','<img src="images/icons/confused.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(7,'sigh','<img src="images/icons/sigh.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(8,'cool','<img src="images/icons/cool.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(9,'tongue','<img src="images/icons/tounge.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(10,'wink','<img src="images/icons/wink.gif">'); INSERT INTO smiles(smile_id,smile_name,smile_url) VALUES(11,'wow!','<img src="images/icons/wow.gif">'); INSERT INTO states(state_id,state_name) VALUES(1,'Alaska'); INSERT INTO states(state_id,state_name) VALUES(2,'Alabama'); INSERT INTO states(state_id,state_name) VALUES(3,'Arkansas'); INSERT INTO states(state_id,state_name) VALUES(4,'American Samoa'); INSERT INTO states(state_id,state_name) VALUES(5,'Arizona'); INSERT INTO states(state_id,state_name) VALUES(6,'California'); INSERT INTO states(state_id,state_name) VALUES(7,'Colorado'); INSERT INTO states(state_id,state_name) VALUES(8,'Connecticut'); INSERT INTO states(state_id,state_name) VALUES(9,'District of Columbia'); INSERT INTO states(state_id,state_name) VALUES(10,'Delaware'); INSERT INTO states(state_id,state_name) VALUES(11,'Florida'); INSERT INTO states(state_id,state_name) VALUES(12,'Georgia'); INSERT INTO states(state_id,state_name) VALUES(13,'Guam'); INSERT INTO states(state_id,state_name) VALUES(14,'Hawaii'); INSERT INTO states(state_id,state_name) VALUES(15,'Iowa'); INSERT INTO states(state_id,state_name) VALUES(16,'Idaho'); INSERT INTO states(state_id,state_name) VALUES(17,'