text:
SQL Tutorial Basics
Pre-Tutorial Requirements
You have knowledge of basic database theory.
SQL (Structured Query Language) is the ANSI standard language for accessing databases. It is a powerful, yet relatively easy to learn, language that allows queries to executed against a database causing the data contained to be retrieve, updated, deleted, inserted plus lots more.
The basis of SQL was invented by a gentleman named Dr. Edgar Frank Codd, an IBM researcher, in the 1970s. Its premise was to allow querying of relational database tables using English like commands. Earlier in June 1970 the same man had released an article entitled A relational model of data for large shared data banks that laid down the foundations of much of the theory behind modern relational databases. SQL development was further accelerated by a request from NASA for a technology that allowed querying of a database that contained rock information, brought back from the moon by the American government.
Where SQL can be used
Almost all modern database management systems (DBMS) allow SQL to be used to query and manipulate database tables. Some modern examples of databases that allow SQL to be used include Microsoft Access, SQL Server, Oracle and Sybase.
Although there are many version of SQL in order to be in compliance with ANSI SQL standard they are all required to support a set of commonly used SQL commands. To make things just that little more interesting a lot of the SQL database management systems superimpose their own propriety extensions on top of the SQL standard.
Main SQL Sections
SQL can be broken down into two main sections, the SQL Data Manipulation Language (DML) and the SQL Data Definition Language (DDL).
SQL Data Manipulation Language (DML)
SQLs main premise is to allow databases to be queried; however the SQL language also contains commands to allow inserting, updating and deleting of records. The main commands that make up the DML part of the SQL language include: -
- SELECT retrieves data from the database
- WHERE provides conditions for which first keyword should be applied
- INSERT INTO inserts data into the database
- UPDATE updates data in the database
- DELETE removes records from the database
SQL Data Definition Language (DDL)
The DDL part of the SQL language allows the core construction/destruction of database elements to take place. For example it provides commands that allow new database tables to be created and removed, primary keys to be defined, database tables to be linked and much more.
* Please note that the DDL part of SQL will be covered, along with more DML commands in the next tutorial I plan to release entitled, SQL Tutorial Advanced.
SELECT Command
The SELECT command allows data to be retrieved from a database table. The syntax of the SELECT command is as follows: -
SELECT column(s) FROM table;
This tells the database system that you wish to select a certain column of data from a certain table in the database. For example the following would return you the first_names column of people stored within a users table: -
SELECT first_names FROM users;
However what if you wish to retrieve more than one column at a time? Well with the use of a comma (,) you can do just that. The following example retrieves both the first_names column and the passwords column from within a users table: -
SELECT first_names,passwords FROM users;
Another keyword, DISTINCT, can be placed after the SELECT keyword in SQL to return only one entry for each unique value in that column. So for example
SELECT DISTINCT first_names FROM users;
would return one entry in the results table for each person with a different name. This means even if there were one thousand users named John, only one result entry for John would shown.
Results that have been returned from a database system come so in the form of a results-set table. Most modern database systems allow this results-set table to be navigated with programming functions provided by technology such as ADO (ActiveX Data Object). For example if you had passed a database system a simple SELECT request for all the first_names in the users table you would then able to navigate up and down the results-set table using the functions provided. (e.g. move-to-next, move-to-first) This would, for example, allow you to receive into a program all of the users first names.
Syntax Notes
The semicolon used at the end of the example SQL code is not required in all database systems, but as it is the standard it is advisable to use it. Its main purpose is in separating out different SQL commands from each other. This gets important when providing multiple SQL statements to your database system at the same time.
The * symbol is defined in SQL as meaning for all. This means that if you wanted to retrieve every column from the users table the following code could be used: -
SELECT * FROM users;
WHERE Command
The SELECT command allows you to retrieve one or more columns of data from a database table; however what if you were just interested in retrieving records that matched a certain condition? (e.g. all users who lived in New York). Thanks to the WHERE command this becomes possible. The syntax of the WHERE command (when applied to SELECT statements) is as follows: -
SELECT column(s) FROM table WHERE column op value;
This instructs the database system to return the column(s) from a certain table as along as the condition defined by the WHERE command is true. For example if the following was passed ...
SELECT * FROM users WHERE age=25;
then the database system would return all the records (because * was used) for all people located in the users table that matched the condition, age=25. This means everyone aged 25 will have their records returned in the results-set.
Many different op(operators) can be used to provide the condition laid down by the WHERE command. Some of these operators include:
- = Equals (e.g. A is equals to B)
- <> Not Equals (e.g. A is not equal to B, sometimes write as !=)
- < Less Than (e.g. A is less than B)
- > Greater Than (e.g. A is greater than B)
- LIKE Matches a Pattern (e.g. A is LIKE a defined pattern)
The LIKE keyword allows pattern matching to occur. For example if you wished to retrieve all the records for users within their 20s you could use the following code: -
SELECT * FROM users WHERE age LIKE 2%;
The % (sometimes write, *) symbol is used as a wildcard (just like in many command line shells) that define areas of a value that are unknown and can be pattern matched. So the above tells the database system that the condition is that the age column should be equal to 2 and then anything else. As this column contains ages its able to match any users within their 20s. This assumes that there is no one aged over 200 in the database, otherwise they to would also be matched.
The LIKE command does not just have to be restricted to numerical patterns however. It can be used to match character patterns just as well as numerical patterns. For example the following code returns the passwords for all users whose first_names begin with P: -
SELECT passwords FROM users WHERE first_names LIKE P%;
Syntax Notes
When specifying WHERE conditions if a word or characters are used then they should be enclosed within single quotation marks (e.g. WHERE first_names=Jack). On the other hand if numerical values are used they should not be enclosed within quotes (e.g. WHERE age=25).
INSERT INTO Command
Now that you can query your database (conditionally and non-conditionally) using SQL you may be thinking to yourself; but what if I want to add records to a database table, can SQL do that? Well I have news for you buster; it sure can! The INSERT INTO command allows for new records to be entered into a database table.
The syntax of the INSERT INTO command goes as follows: -
INSERT INTO table VALUES (value1, value2, value3, );
The above tells the database system to insert into the table defined the values provided as a new record. This means that if for example the code
INSERT INTO users VALUES (jack, smith, password45, 40, New York);
.. was entered then a new record in the users table would be created and the values entered into the columns of that record.
The INSERT INTO command also allows new records to be entered without a value for all columns in the record being required. For example you could create a new entry in a users table but only supply the first_name, password and location, leaving out the second_name and age data. The syntax of the advanced INSERT INTO is as follows: -
INSERT INTO table (column1, column2, column3 } VALUES {value1, value2, value3 );
The above code specifies the database table in question along with the columns of that table in which data will be inserted, in the new record. It then provides the data to be inserted into each column in the same sequence as the columns were provided.
As an example, if I wish to create a new record in a users table but I only wish to provide the first_name, password and age (leaving out the second_name and location) then I could do so with the following code: -
INSERT INTO users (first_name, password, age} VALUES {Tom, apple, 28)
Syntax Notes
You may be wondering if the SQL keywords (e.g. SELECT, WHERE, INSERT INTO) need to be capitalized. The answer is no. However many people choose to format their SQL commands in this way to help distinguish between keywords and non keywords.
UPDATE Command
The UPDATE command delivers exactly what it promises, in that it allows data already located in a database table to be updated (changed). This is an extremely common and frequently used requirement for most databases. The syntax of the UPDATE command is as follows:-
UPDATE table SET column = new_value WHERE column = value;
The above code tells the database system that in the table identified I wish to set/change a supplied columns current value with the new value supplied. It also identifies the record for which I wish the data to be changed using the WHERE keyword.
If I wished to change the password of Jack in my users table from apple to orange I could do so using the following code: -
UPDATE users SET password = apple WHERE first_names = Jack;
The UPDATE command doesnt just limit you to changing one column of data at a time however. For example, using the syntax presented below its possible to update as many columns of data as you wish, within the same statement.
UPDATE users SET first_names = Kenny, age = 25, location = South Spain WHERE second_name = Brown;
The above code requests that the database system updates the first_names, age and location data with the values provided for a user with a second_name of Brown.
DELETE Command
The DELETE command allows records from a database table to be removed. This could be used if for example you wished to remove a user from a users table. The syntax of the command is as follows: -
DELETE FROM table WHERE column = value;
The above SQL code is telling the database system to remove a record thats column value matches the column value provided from the specified table. For example if you wished to remove a user with the second name of Black from a users table you could use the following code:-
DELETE FROM users WHERE second_name = Black;
If for example you wished to remove all records from a database table but to retain the table itself for reuse the following code would do this: -
DELETE FROM users;
The above tutorial should have hopefully given you an overview of SQL including its main parts and a little of its history along with a grasp of some of the basics of the SQL DML language. You should now be able to execute queries against databases using the SELECT, WHERE and LIKE commands, insert data into a database using the INSERT INTO command, update values using the UPDATE command and finally delete records using the DELETE command.


text:
Mega Millions jackpot skyrockets to $640 million
The Mega Millions jackpot that has set off a nationwide case of lotto mania rocketed to $640 million Friday morning, just hours before the historic drawing, lottery officials said.
The enormous prize brings a one-time cash option of an estimated $462 million before taxes, or a winner could choose annual payments of about $24 million before taxes for 26 years.
"This is history, and we're enjoying it," California spokeswoman Donna Cordova said Friday. "This is just a shared moment for the entire country. We're rolling into uncharted territory here."
Lotto fever struck Los Angeles soon after officials announced there was no winner in Tuesday's $363 million drawing. Officials say they have met every night since Tuesday and watched the number grow from $540 million Thursday to the astronomical figured released Friday.
"It's so high — I mean, that's astronomical," said Charlie Blair, 70, a retired mechanical engineer.
Blair had never played the lottery until he heard about the record payout, and he headed to a gas station near his Koreatown apartment Thursday to buy a single ticket.
According to the California Lottery, the chance of winning Mega Millions is 1 in about 176 million.
Or as California statistician Mike Orkin, puts it: If you buy 50 tickets a week, you will win the jackpot every 68,000 years.
Record Mega Millions jackpot draws players, lines
What to do if you win the Mega Millions lottery jackpot
Mega Millions: Odds of winning jackpot don't deter players
-- Matt Stevens, Corina Knoll and Anna Gorman
Photo: A man makes his lottery picks at a convenience store in Manhattan. Credit: Stan Honda / AFP/Getty Images

subset: commoncrawl


text:
Most hybrid buyers — almost two-thirds — don't end up buying another hybrid, according to a recent study R.L. Polk. Yet more evidence that hybrids are more about marketing hype than hyper-miling for the masses.
The study says that the loyalty rate for hybrids since 2008 — people who went on to purchase a new car after purchasing a hybrid who have gone on to buy another hybrid — has ranged between 26.4% in the second quarter of 2010 and 41.8% in the second quarter of 2009. The rate for the fourth quarter of 2011 was 40.1% while the total for 2011 was 35.0%.
And if you pull out owners of the Toyota Prius the repurchase rate plummets even further — to 22%.
While the Polk study does say that hybrids not only attract new buyers to a brand, it also may help to retain those customers, according to Polk personnel interviewed by Automotive News.
While that may be true, it doesn't appear that they want a hybrid. Which may be why the dual-drivetrain vehicles still account for less than 3% of all U.S. auto sales last year — 2.4% last year, down from a peak of 2.9% in 2008.
So, it would seem like hybrids are still more about mass marketing that mass miles per gallon.


text:
If you're lost on a freeway and have to pull over, logic tells us we should easily be able to turn around. But then sometimes we end up lost in a hellish maze that leads us to no man's land.
Most exit ramps are simple but there's always that one that just makes no sense. Or there's one that's simply too dangerous to be an exit ramp. Or there's one that takes you nowhere that you need to be. And there are ones that have the dreaded "no re-entry" sign that you don't see until it's too late to stay on the freeway.
One of my Twitter pals pointed out that the worst exit ramp in Detroit has to be exit 6B to Elmhurst Avenue on the southbound Lodge Freeway. It's arguably the most pointless exit in the entire city. There's no overpass for Elmhurst over the Lodge, so no re-entry northbound. When you exit, there's an immediate right turn with no stop sign, and there's oncoming traffic. And the street leads you to one one-way streets (Rosa Parks Boulevard) and Elmhurst itself becomes a do-not-enter one-way, forcing you to turn onto Rosa Parks and eventually find your way somewhere, anywhere...but far from the freeway.
Second place would have to be the accidental Pleasant Valley Road exit on westbound I-96 near Brighton that takes you through metropark hell and back before getting back onto the freeway, but that's a mistake you only make once.
What's the worst exit ramp you've ever seen?
[Screenshot: Google]


text:
Automotive - The Trenton Sun
View Our Classifieds
About The Sun
2019 Rate Card
Print Services
Contact Us
City of Trenton
Village of New Baden
Wesclin School District
19 W. Broadway • Trenton • (618) 224-9422
FREEFORM Seat Technology: A Car Owner's Dream
The next time you're looking for a new car, don't just kick the tires; kick back and try out the seats.
Floors Fit For Your Vehicle
Good news for caring car, truck and SUV owners.
Six Quick Tips For Winter Driving
Vehicles require extra care to keep running smoothly in the winter
As Temperatures Drop, Check Tire Pressure More Often
Incorrect tire pressure can lower gas mileage.
Ignore These Vehicle Repairs And You May Get Pulled Over
While a vehicle is in operation, traffic laws require that certain equipment is properly installed and functioning.
Hints To Help You Be Engine Smart, Earth Kind
Knowing where to look can help you save money at the fuel pump.
How To Identify Flood-Damaged Vehicles
Getting a flood-damaged vehicle can put a real damper on the whole used car buying experience. But there are ways to tell.
Avoiding Common Driving Dangers
The safest accident is the one that never happens, so automotive technology offers some innovative ways to reduce your risk.
Learn About Auto Window Tint
Automotive window films, or tint, offer a variety of benefits.
Don't Let Tires Flatten Your Travel Plans
Check your tires before your next road trip so they don't leave you flat.
Getting Into The Swing Made Easier
As golf remains a significant piece of business and social culture, it's important that women feel confident on the course.
Revitalize Your Vehicle
Preventative car maintenance is important.
RV Maintenance For Summer Travel
Proper RV maintenance is key to preventing frustrating equipment issues that can lead to expensive repairs
Show Your Vehicle A Little Love
Your car is always there for you. An oil change, tune-up and basic service can be a great way to return the favor.
Decoding Your VIN
Before you buy a used car, do a VIN lookup.
Forget The Halls...Deck The Driveway
The 2019 Lexus ES luxury sedan is the latest from the automaker and has been described as a "product of mastery."
A Dozen Great Gifts For The Gearheads On Your List
You can be known for having a gift for giving.
Six-Point Vehicle Check: A Gift That Keeps On Giving
Regular vehicle maintenance is always more convenient when you're doing it on your own schedule.
Dangerous Airbags Affect Millions Of Drivers
Millions of vehicles have dangerous, recalled airbags that need to be replaced immediately, FREE.
Defensive Driving Tips
Be prepared for the perils of the road.
Keep Your Car On The Road To Safety And Savings
Prepare your car for hazardous conditions.
Time Is Money When It Comes To Car Maintenance
Finding the time to perform simple preventative vehicle maintenance is money in the bank.
Five Tips To Help You On The Road To Your New Home
Whenever you rent a truck to move yourself, five facts can help you and your furniture arrive in good order and good time.
Hints To Help You Protect Your Kids In The Car
Keeping your kids on the road to safety when in and around a car can be easier if you take certain steps.
A Clean Car Is Money In The Bank
Keeping your car clean can be an easy and inexpensive way to protect its resale and trade-in value.
Urgent Airbag Safety Recall: Recalled Airbags Can Kill Or Seriously Injure You And Your Passengers
Vehicle manufacturers are conducting the largest safety recall in U.S. history.
Help Teens Learn Driving
When it's time for your teens to get their learner's permits and driver's licenses, here's a hint on how you can help.
Good News For Older Drivers
Staying on the road to safety and savings can be easier for many mature Californians.
Ask Six Simple Questions To Select The Right Auto Repair Shop
Identify the right auto repair shop.
A Moving Experience Made Easier
America's military men and women can be ready for just about anythingeven moving their families.
Reasons To Clean Your Car
If any of the more than 260 million cars in America is yours, here's important advice: Keep it clean.
Ten Tips For Drivers
There are 5.25 million driving accidents a year in the U.S.but you can keep them from happening to you.
Seeing Is Believing When It Comes To Road Safety
For safe driving, maintain vehicle wipers, lights, mirrors.
Teen Driving Tips: Five Ways To Stay Sane
When your teen is officially licensed to operate a vehicle, you may feel simultaneously proudand terrified. Following these five tips, however, can help.
Spring Car Care Tips
Tips to get your car in tip-top shape.
Your Brakes May Be Trying To Tell You Something
Knowing the key warning signs that your brakes may need maintenance will go a long way toward keeping you and others safe on the road.
Create The Car Of Tomorrow To Win Prizes Today
A unique competition designed to help expose young artists to the various career opportunities in automotive design.
Heed The Recall: Get Your FREE Airbag Repair
Your car dealer may be looking to give you a FREE airbag repair.
America Is Seeing A Flood Of 'Flood Cars'
Don't let a flooded-out used car put a damper on your driving.
Six Ways You Could Be Killing Your Car
Six things motorists do that can harm their cars and their wallets.
U.S.-Made Parts Can Be Key To Positive Car Repair Experience
When someone works on your car, ask why the technician chose a specific brand of replacement parts.
Prepare For Safe Winter Driving—Top Questions Answered By The Tire Specialists
Answers to common winter driving questions.
Car Maintenance Tips For Holiday Road Trips
A basic care routine can maintain the value of your car and avoid road trip headaches.
Avoid Surprise, Winterize
Prevent car trouble when the weather gets rough.
URGENT—Your Vehicle May Have A Dangerous Air Bag!
A few simple steps can help you save your own life and the lives of your friends and family.
14 Cars You Can Practically Drive Forever
American-made SUVs dominate in a study of vehicles proven to last at least 200,000 miles.
Teach Teens Safe Driving Habits
Tips on helping keep teen drivers safe.
It's A Myth That Only New-Car Dealers Can Service Vehicles Under Warranty
By law, independent repair shops as well as auto dealers can provide services to maintain your new-car warranty.
How Innovations Make Work Easier, Adventures More Fun
Scientists and engineers have come up with some exciting technology for now and the near future.
Three Reasons Not To File A Claim For That Fender Bender
Conditions and situations when you may not care to call the insurance company.
Picking A Great Place To Work
Good news out of Washington, D.C. for people wanting a great job.
When, Where, How And Why To Change Your Vehicle's Oil
Basic vehicle maintenance is an easy, inexpensive way to prolong the life of vehicles and avoid costly repairs down the road.
How American Farmers Feed The World
Robotic and automotive advances help American farmers.
Keep Your Kids On The Road To Safety
News about children and safety on the road.
Dos And Don'ts To Help You Keep On Truckin'
Save time and money and treat yourself to an adventure.
Vehicle Checklist For Car Pool Season
Five pointers on carpooling to keep you on the road to safety.
Search only accepts letters and numbers.
willy weather
Trenton Sun
About The Sun
Print Services
Contact Us
Content © 2020 Trenton Sun 19 W. Broadway P.O. Box 118 Trenton, IL 62293
Software © 2020
1up! Software,
All Rights Reserved


text:
DEPARTMENT store giant John Lewis has announced an opening date for its new £15 million store in York.
The 92,000 sq ft shop, which has been under construction since last May, will open on Thursday, April 10.
The new store, which is part of the £90 million Vangarde development at Monks Cross, is John Lewis's first opening of 2014, and will be the chain's 41st shop.
It will be the first day of trading for many of the 300 new staff who have been taken on by John Lewis.
Robert Garnish, branch manager at John Lewis York, said: "Having grown up in Yorkshire, I am excited to announce the completion date of our multi-million pound investment in the area.
"Together with my team of Partners (staff) we are looking forward to welcoming customers through the doors.
"We've been so grateful for the support from the community since we announced this project, and we can't wait to reveal the shop on April 10."
Last month John Lewis revealed it had received an "overwhelming response" to job positions at its new York store after almost 2,000 people applied for the 300 vacancies.
The York store will be the retailer's most sustainable shop to date with features including a planned wildlife wall alongside sustainable building design elements such as low energy lighting and photovoltaic cells on the roof to generate energy.
John Lewis's opening coincides with the opening of the neighbouring new Marks & Spencer store, which is also opening on the Vangarde development, creating 200 jobs.
The 100,000sq ft store will be one of the retailer's biggest in the region covering fashion, beauty, food and homeware.
In light of the new opening, the existing Marks & Spencer at Monks Cross will close on April 9, with the Coppergate Centre shop set to shut on April 26.
Alongside John Lewis and Marks & Spencer, Next is also opening a homeware store at the site.
Only one unit at the development remains available for let after Ed's Easy Diner completed a deal last month. It adds to food brands already lined up for the development, including Costa Coffee, Prezzo, Nando's, Frankie & Benny's and York's first Giraffe restaurant will all be open for business in April this year.


text:
Williams Sonoma Blackberry-Lemon Pancake & Waffle Mix
- Only at Williams Sonoma
Easy, hassle-free returns online and in-store for eligible items.Learn More
Earn 5% Back in rewards4 plus free standard shipping3every day when you shop with your Williams Sonoma credit card at Williams Sonoma.Apply Now Learn More
- Summary
Brighten your morning with the fresh, sweet and tangy flavors of homemade blackberry-lemon pancakes and waffles. For light, fluffy flapjacks, our mix is blended from the best natural ingredients, including tender bits of dried ripe blackberries. To highlight their natural sweetness, we add tangy lemon and pure buttermilk. Prep is easy—just add milk, butter and eggs. Serve your breakfast treats piping hot, topped with butter and pure maple syrup or fresh berries.
- 1 lb., 4 oz. (makes approx. fourteen 6" diam. pancakes or ten 7" sq. waffles).
- Made in USA.
- A Williams Sonoma exclusive.
- Ingredients
- Enriched bleached flours (wheat flour, malted barley flour, niacin, iron, thiamin mononitrate, riboflavin, folic acid), sugar, yellow corn flour, blackberry pieces (sugar, vegetable oil [palm, palm kernel], wheat flour, fruit and vegetable juice [for color], natural flavor, soy lecithin, malic acid), lemon pieces (vegetable oil [palm, palm kernel], sugar, enriched wheat flour [niacin, mononitrate, riboflavin, folic acid], lemon juice powder [corn syrup, lemon juice, lemon oil], natural extractives of lemon, citric acid, soy lecithin, malic acid), canola oil (with ascorbic acid, rosemary added to preserve freshness), sodium bicarbonate/baking soda (leavening), sodium acid pyrophosphate (leavening), pure vanilla powder, sea salt, egg yolk powder, buttermilk powder, natural lemon flavors, defatted soy flour, sweet corn powder, monocalcium phosphate (leavening), dextrose, egg white powder, natural blackberry flavor, natural flavor.
- Shipping
Shipping Information
UPS can deliver most in-stock items within 3–5 business days. UPS is unable to deliver to P.O. boxes.
Shipping Rates
The shipping rate varies depending on your order total and shipping destination. View Shipping Options and Charges.
Next Day Delivery
For an additional charge of $26 per address, we can expedite delivery to most destinations. This service is not available for some oversize items, items shipped directly from the supplier (including perishable and custom-manufactured items), out-of-stock items and items to be shipped outside the contiguous 48 states.
Orders received by 9:00 p.m. ET Monday through Thursday will arrive the next business day; orders placed Friday through Sunday will arrive on the following Tuesday.
Return Policy
At Williams Sonoma, we take great pride in the quality and craftsmanship of our products. Attention to design, materials, safety and construction are our priority. Upon receipt, please inspect your purchase and notify us of any damage; we will arrange for a prompt replacement.
If within 30 days, you are dissatisfied for any reason, you may return your purchase for a refund of the merchandise value. An original receipt or gift receipt is required for all returns and exchanges. Returns with a gift receipt will be refunded in the form of a Merchandise Credit for the amount indicated on the gift receipt. Returns with original receipt will be refunded in the original form of payment, cash and check refunds over $100 will be issued as a company check (may take 14 business days from time of request).
For all cutlery returns (knife sets, single knives, cutting boards, knife sharpeners and knife storage), please contact us at 888.922.4108 to initiate the return.
We cannot accept returns on monogrammed, personalized, special-order items, custom upholstery, food, items shipped direct from the vendor or on items damaged through normal wear and tear. Final sale items ending in .97 or .99 cannot be returned.
Made to Order and Final Sale Furniture items are non-returnable and cannot be cancelled once the order is placed.
For returns of items purchased from your Williams Sonoma Gift Registry, we will gladly provide a refund or exchange for the merchandise within 90 days of your event or within 90 days of purchase, whichever date is later. View Full Returns Policy.
Rated 5 out of 5 by emilyr172 from So delicious We bought a few different pancake mixes and they are ALL yummy -- this blackberry lemon is SO TASTY! We actually made it with almond milk and it's delicious.Date published: 2018-09-25Rated 5 out of 5 by Anonymous23441 from INCREDIBLE!!!! This is my favorite pancake mix I have ever bought. It's sweet, tart and refreshing, and DELICIOUS!! They are my favorite thing to eat in the morning, the only bad thing, is that there isn't enough in the tin!!!!Date published: 2017-01-06Rated 5 out of 5 by RichardoftheLake from My favorite pancake mix The best pancake mix I have ever used! Easy to prepare.Date published: 2015-02-21Rated 4 out of 5 by Binta from Description should read: "Lemon-Blackberry" The product art is more accurate than its description. I've only made waffles with this batter. When I made the batter and simply let sit for 5 minutes, the waffles tasted significantly more lemony than when it set overnight. The batter thickened up significantly so I added about 1/3- 1/2 c water to thin it out. I used coconut oil as a butter substitution. The flavor of the overnight batter was more balanced, but it tasted more "berry" than blackberry specifically, though distinctively not blueberry or mulberry. I would buy this again and like the interesting flavor combination, but the lemon flavor taste more like extract than a subtle fresh lemon flavor. I liked the batter, but not sure if I like it as much as the blueberry. As a general rule, I find that the batter is significantly more flavorful when I use diluted cream instead of milk and allow to sit overnight.Date published: 2014-05-31Rated 1 out of 5 by Dawnfedora from What a disappointment Don't waste your money. I followed the directions to a tee and 1)preparing one serving leaves about 1/3 of the mix in the container so not even enough to prepare another serving. And 2) the batter was so thick & sticky I couldn't even pour it or scrap it off the spoon. I kept trying to thin it out but the pancakes turned out dry & flavorless. It was an expensive mess that my kids wouldn't eat. My dog seemed to like it.Date published: 2013-10-19Rated 1 out of 5 by Zuckererbse from Disappointed I bought this mix after reading the previous reviews, but didn't love it at all. The fruit contents is insignificant, whilst the lemon taste is almost artificial. I will stick with the Bellegem mix, which can't be beaten.Date published: 2013-08-18Rated 5 out of 5 by Wills30 from Very Unique I purchased this mix simply because there's nothing else with this flavor combination on the market. It is a fresh, very unique flavor. The lemon tastes like actual lemon and the blackberries take it to a whole new level. I served this topped with lemon curd mixed with whipped cream and some fresh blackberries. No syrup needed.Date published: 2013-08-02Rated 5 out of 5 by DALEX from Our new favorite We've tried all the mixes, but this ones our new fave. Try waffles with lemon curd and whipped cream with fresh blackberries. Whole new level.Date published: 2013-07-29


text:
Black smoke belches out of a grinding old engine as it hauls Russia's latest Soyuz space capsule across a Kazakh wasteland, while armed guards keep watch. This mixture of high and low technology is probably the future of space exploration, as resources get scarcer and more small governments and independent operators get into the space game. More images of Soyuz in the wasteland, and its launch to the International Space Station, below.
Images by AP/Dmitry Lovetsky


text:
(CBS News) A museum director at the Smithsonian Institution in Washington, D.C., said she would be interested in acquiring a symbolic and recent piece of American history.
Trayvon Martin's hoodie - the sweatshirt he was wearing the night he was fatally shot by George Zimmerman in Sanford, Fla. - "became the symbolic way to talk [about] the Trayvon Martin case," Lonnie Bunch, the director of the Smithsonian's National Museum of African American History and Culture, told The Washington Post.
As legal proceedings have come to an end, the hoodie is likely back in the hands of the Sanford Police Department and Trayvon Martin's family will be given a chance to claim it.
Wall Street Journal art reporter Kelly Crow told CBS News that, despite the intrigue, it is unlikely that museums will be clamoring over the hoodie, due to the sensitivities surrounding the case.
"I think the art world probably wouldn't be lining up to display this tomorrow because it could be seen as a little exploitative," Crow said.
If put on display at the African American History Museum - which is currently under construction - the hoodie would join a collection that includes the handcuffs used on Harvard professor Henry Louis Gates as well as artifacts belonging to Harriet Tubman and date back to the days of slavery and the underground railroad, CBS News' Chip Reid reports.
"I think museums have always seen it as their mission to chronicle the human experience. Some museums define that in terms of famous paintings and sculptures; other museums define that in terms of artifacts that, you know, sum up the zeitgeist of a certain historical moment," Crow said.
The collection of these kinds of artifacts is on the rise. The Law Enforcement Memorial Fund is building a museum in Washington that will eventually house the car, sniper rifle and other items used by Lee Boyd Malvo and John Allen Muhammed, the snipers who terrorized the D.C. area in a three-week, 2002 killing spree.
And while an artifact from another famous criminal case - the infamous ill-fitting gloves worn in court during the trial of O.J. Simpson - have yet to be displayed by a museum, they were put on display at the Palms Resort in Las Vegas four years ago.
"I think museums should chronicle the whole sweep of history," said Crow. "The bad stuff happened, and it's part of the story, and it should be included."


text:
The Health Centre, Landsdowne Road, Yaxley, Peterborough, PE7 3JL
Telephone: 01733 240478
CQC Rating
A new type of General Practice
Lakeside Healthcare is a new type of NHS general practice which builds upon and celebrates all that is great about traditional primary care services. We are local surgeries run by doctors, nurses and associated staff who know their patients and care deeply about the quality of health provided in their communities. We build upon this by investing in people, facilities and equipment to provide services that are more accessible, more convenient and more diverse within the local community. We work for our patients.
Find A GP Service in your area
Madalaina Hailstone
Julia Pritchett
Lakeside Healthcare At Yaxley
The Health Centre,
Landsdowne Road,
Telephone: 01733 240478
Fax: 01733 244645
All you need to know about SystmOnline and the services it provides you and your family 24/7/365
The NHS want you to have the best possible experience of care. Please give your feedback.


text:
The Crimson looks to end its home schedule with a pair of victories over EIVA opponents this weekend (photo courtesy Gil Talbot).
The Storyline
The Harvard men's volleyball team will play its final two home matches of the 2013 season this weekend when NJIT and Rutgers-Newark come to Cambridge. The Crimson clinched a spot in the EIVA Tournament last week, but is still fighting for playoff positioning as the regular-season comes to a close. Harvard faces NJIT on Friday at April 12, at 7 p.m. and meets Rutgers-Newark on Saturday at 2 p.m.
Follow the Action
A live video stream will be available through GoCrimson.com by clicking video. Live stats will also be available.
Last Time Out
The Harvard men's volleyball team saw its 12-match home win streak come to an end Saturday, as George Mason rallied past the Crimson, 25-22, 23-25, 16-25, 22-25, at the Malkin Athletic Center. Nick Madden paced the Crimson (14-8, 7-4) with a match-high 15 kills, while Branden Clemens recorded a double-double with 12 kills and 10 digs. Caleb Zimmick hit .429 to finish with eight kills, and he also was in on seven of the team's eight blocks with one solo and six assisted. Rob Lothman chipped in with 39 assists and seven digs on his Senior Day.
Related Link: George Mason Outlasts Men's Volleyball, 3-1
Around the League
Harvard is currently in fourth place of the EIVA standings with a 7-4 conference mark and a 14-8 overall record. Entering the weekend, the Crimson is third in the conference in hitting percentage (.257), second in aces (1.14), fourth in assists (11.14), kills (11.91) and blocks (2.34), and ranks sixth in digs (8.66).
DJ White, Caleb Zimmick rank second and fourth in the league with hitting percentages of .345 and .313, respectively, while Branden Clemens is ninth with a .273 attack. White also ranks sixth in the EIVA for kills per set at 3.21 and is joined by Nick Madden with 2.90 kps for 10th in the same stat column. Chris Gibbons comes in fifth among liberos with 2.40 dps, while Rob Lothman is third among EIVA setters with 9.99 aps. Zimmick also boasts the fourth best blocking average at 1.18 bps with Kyle Rehkemper chipping in 0.86 bps, ninth in the conference. At the service line, Rehkemper rates seventh in the EIVA for aces per set (0.29), while Michael Owen is eighth at 0.26.
National Scene
Men's volleyball national ranking summary through games played March 31.
Scouting NJIT
The Highlanders swept two matches against Rutgers-Newark in their two matches dating back to March 26. At 3-7 in EIVA contests, NJIT is in sixth place. The Highlanders are 6-18 on the year and have gone 2-4 in their last six matches.
NJIT is hitting .204 on the year, sixth in the EIVA. The Highlanders rate seventh in the league with averages 11.28 kills per set and 10.60 assists per set, while their 1.97 blocks per set is sixth and 9.66 digs per set is second.
Individually, Doug Battersby is ranked sixth in the conference for hitting percentage (.286) and Kevin Van Oss is 10th with a .257 attack. Brady Smith carries the EIVA's second best digs per set average (2.56), while Matthew Lui rates seventh in the league with 7.78 assists per set.
Harvard shut down NJIT in straight sets earlier this season, but the all-time series still favors NJIT, 15-14.
Previous Meeting: No. 15 Men's Volleyball Cruises to Victory at NJIT, 3-0
Scouting Rutgers-Newark
The Scarlett Raiders are 4-17 and 0-10 in EIVA play this season. Rutgers-Newark is 2-4 in its last six matches and will meet Sacred Heart on Friday, April 12, before taking on Harvard Saturday.
Rutgers-Newark ranks seventh in the EIVA for hitting percentage (.181), digs per set (8.39) and blocks per set (1.46), and last in the league in kills per set (10.80), assists per set (10.00),
Opposite side hitter Manuel Felipez carries the conference's third best kills per set average (3.55), while outside hitter Travis Mintzer has the league's third most efficient attack (.314). K. McCandless (7.02) and A. Lopez (5.19) rank eighth and ninth in the EIVA for assists per set. Felipez' team-leading 1.65 digs per set are ninth best in the conference.
After sweeping Rutgers-Newark in the earlier meeting this season, Harvard has won three straight matches against the Scarlett Raiders, but still trails in the all-time series, 15-8.
Previous Meeting: No. 15 Men's Volleyball Continues Win Streak at Rutgers-Newark, 3-0
Dishing 'Em Out
Senior setter Rob Lothman's 53 assists against Princeton on April 5 were the fourth most in a single match for the Crimson. Lothman, the school's all-time leading setter, also holds the third highest single-match assist mark of 54, which he set as a sophomore against the Tigers. The captain has recorded eight matches with 50 or more helpers in his career.
Approaching the Postseason
With three matches remaining in the regular season, Harvard is in EIVA Tournament with the fourth and final spot. The Crimson clinched its second consecutive postseason berth with a 3-2 defeat of Princeton on Friday, April 5, and will likely face top-seed Penn State in the league tournament.
Records are Meant to be Broken
Two Harvard men's volleyball records were broken within four days of each other. Junior Chris Gibbons produced 30 digs against UC Santa Barbara on March 15 to surpass Matt Jones '12 452 career digs. With 539 scoops, Gibbons is the only player in program history to surpass the 500 dig plateau.
At Concordia on March 19, senior Rob Lothman dished out 27 assists to overtake Mike Bookman '03 in career assists. Bookman amassed 2,765 assists while playing for the Crimson. Lothman, whose freshman and junior single-season totals rate among the best in program history, has tallied 2,895 assists at Harvard.
Keep on Blockin'
Middle blocker Caleb Zimmick registered a career-high nine blocks against Sacred Heart on March 13. Zimmick has recorded seven or more blocks four times this season and logged 13 matches with at least five blocks in the sophomore's young career.
Winning Ways
Harvard won six straight matches from Feb. 2 to Feb. 23, it longest streak since winning 13 in a row in 2005. During that span, the Crimson won four matches in straight sets, also matching the 2005 team's streak of four consecutive sweeps.
National News
Harvard has fallen from the AVCA Division I-II Poll after being ranked in consecutive weeks from Feb. 25 to March 4. The Crimson reached as high as No. 14, the highest ranking in program history.
Taking Home the Hardware
Sophomore DJ White recently earned a pair of honors, being named both the AVCA Division I-II National Player of the Week and EIVA Offensive Player of the Week. The praise comes after White averaged 4.17 kills per set and hit .477 as the Crimson knocked off No. 9 Penn State and St. Francis (Pa.) in straight sets.
White is the first member of the Crimson to earn the national recognition. He has been named the conference's offensive player of the week twice this season and has earned the distinction three times in his career.
Slump Busters
The Crimson ended a 51-match drought for conference opponents versus Penn State when it upset the ninth-ranked Nittany Lions Feb. 15, 3-0. Penn State's last loss to an EIVA conference foe came on March 7, 2008 to George Mason, 3-1.
Ranked Wins
Harvard's 3-0 victory over then ninth-ranked Penn State marked the team's second win over a ranked opponent in as many years. Last season, the Crimson knocked off No. 12 Call State Northridge, 3-1, to record the program's first victory against a ranked team under head coach Brian Baise.
MAC Attack
Harvard is 23-7 in the friendly confines of the Malkin Athletic Center since the start of 2011 including a 7-1 mark this year. The Crimson won 12 straight matches at home dating back to last season, before having that streak snapped against George Mason on April 6. Harvard has also captured each of its last three home openers.
Block Party
The Crimson recorded 17.5 blocks at No. 6 Penn State, the team's highest total over the last three seasons. Caleb Zimmick led the way with eight total blocks as Michael Owen and Kyle Rehkemper each turned in seven. Nick Madden and Rob Lothman also got in on the action, registering six blocks and four blocks, respectively.
Harvard's season high for blocks in 2012 was 17 at Rutgers-Newark.
Quick Start
Harvard swept Stevens, NYU and St. Francis (Pa.) to open the year, marking the third straight season that the Crimson has started the year with at least two victories. Harvard's three straight-set victories, meanwhile, had not been accomplished since 1993 when the squad posted four sweeps in its first four matches.
Catch the Crimson in 2012
Harvard will host 11 home matches at the Malkin Athletic Center this season and each will be streamed live online through GoCrimson.com. Fans can also watch each match On Demand approximately two hours after completion. One-year subscriptions are available for $49.95 and allow access to every home event streamed by the Crimson, including football, men's and women's basketball, men's and women's hockey and men's soccer. For more information or to sign up today, click here.
Captaining the Ship
Rob Lothman and Nick Madden will serve as the team's captains for the 2013 season. Lothman was named to the All-EIVA second team in 2012 after setting a career-high with 888 assists, the fifth-best single-season total in program history. Lothman directed the Crimson attack to a .298 hitting percentage, which ranked seventh in the NCAA, while his 10.1 assists per set were good for 18th in the nation. Madden, meanwhile, started all 24 matches last year for the Crimson and ranked second on the squad in kills (3.01) and points (3.6). His 268 kills in 2012 were good for eighth in program history while his 147 career blocks rank his sixth all-time.
Banner Year
Harvard is coming off one of the most successful seasons in program history, as the Crimson earned its first-ever national ranking in 2012 and finished the year at No. 15 in the AVCA Coaches Poll. Harvard posted an 18-6 overall record and took second in the EIVA with a 10-4 conference mark, with the team's 18 wins representing the third-highest total ever.
Head coach Brian Baise was tabbed as the EIVA Coach of the Year as a result of the squad's success while Matt Jones, DJ White and Rob Lothman all earned all-conference accolades.


text:
Harry Krieger made 10 saves in net for Harvard against No. 15 Penn (Gil Talbot).
CAMBRIDGE, Mass. – Kevin Vaughan and Dean Gibbons scored goals for Harvard in the final two minutes of regulation to force overtime, but the Crimson fell to No. 15 Penn, 7-6, in the second extra session Saturday afternoon. Before 1,121 fans at Harvard Stadium, Crimson goalie Harry Krieger recorded 10 saves, while Gibbons paces the Harvard offense with three points.
The double-overtime loss drops Harvard's overall record to 7-5 and the Crimson falls to 1-3 in the Ivy League. Penn moves to 6-4 and 3-2 in the Ancient Eight.
Penn, which outshot the Crimson, 9-3, in the opening frame, scored the only goal of the first quarter, coming with 1:05 remaining on a shot by Al Kohart. In the second, the Quakers doubled its lead to 2-0 when Corey Winkoff tallied a man-up goal at 8:53. The Crimson got back in the game with its only goal of the half at the 3:32 mark, as Gibbons sent a pass to Alex White for a man-up tally, getting Harvard within on, 2-1.
The Quakers held a 17-10 advantage in shots in the first half, including a 7-4 margin in shots on target.
In the third quarter, Vaughan knotted the game, as he took a pass from Gibbons and fired a shot past Penn goalie Brian Feeney at 13:09. The Quakers pulled back ahead with scored by Will Koshansky and Drew Belinsky to take a 4-2 advantage at the 5:57 mark. With 2:31 remaining in the third, Terry White knotted a goal on a wraparound chance and Peter Schwartz followed with an unassisted tally of his own to send the teams to a 4-4 tie entering the final period of regulation.
Penn opened the fourth with a goal by Morgan Griff at 12:16 to regain an advantage, 5-4. Neither team could muster another goal until Griff netted a score with 2:46 to play, putting the Quakers up by two, 6-4. Harvard's Gabriel Mendola won the ensuing faceoff and Vaughan found the back of the net to pull Harvard back within one, 6-5. Mendola won the next faceoff as well, and following a Crimson timeout, Ryan Stevens passed the ball to Gibbons, who fired a shot to tie the game with just 52 ticks left on the clock.
With four seconds left, Krieger stopped a shot by Penn's John Conneely, forcing overtime. In the first extra session, Krieger recorded the only save of the quarter, turning side a chance by Corey Wiinkoff at 1:08. Krieger also made a stop early in the second overtime, helping Harvard regain possession. With 1:31 left, Feeney recorded a save on Stevens, allowing Penn to clear the ball. With 30 seconds to go in the second overtime, Penn's Drew Belinsky scored an unassisted goal, giving the Quakers the victory.
Mendola won 8-of-12 faceoffs for the Crimson, which finished 10-of-17 as a team. Mendola also grabbed seven ground balls to pace the team. Harvard converted 1-of-2 man-up opportunities and was successful on 19-of-23 clear attempts. Feeney finished the game with nine saves for Penn, which outshot Harvard, 32-20.
Up next, the Crimson takes to the road to visit Princeton Saturday, April 23 at 1 p.m.


text:
johnfyn needed a new logo design and created a contest on 99designs.
A winner was selected from 25 designs submitted by 10 freelance designers.
Ballyneety Tyres are looking for a logo which will be used on their company van and rally cars which they will be sponsoring.
Ballyneety Tyres
Alloy Wheel Repair Specialists
Desired Color Scheme:
Open to the designers but consider its gonna be on various background colors
Desired Style:
We will leave this open to the designer. What we ask for is that the logo is clear and readable on the van and cars. At the moment the Vans are white, Mercedes Sprinters, and the cars are Red Honda Civics. The logo can be in 2d or 3d, this is up to the de
Accepted File Formats:
vector format to allow for high resolution for printing
The logo is open to the designers but something fresh, new and creative which will go well with various background colors. The name of the Company, "Ballyneety Tyres" and their slogan "Alloy wheel repair specialists" will also need to be on the logo.
Find out how a design contest works or learn more about our logo design services.


text:
In General:
Appearance Required
Sending Someone to Request the Adjournment
Writing a Letter to Request an Adjournment
In General: Appearance Required
An adjournment may only be granted by the judge presiding at the time of the hearing. You can not call the court clerk for this purpose because the clerk is not permitted to grant adjournments. To get an adjournment, you should appear at the hearing at the appointed time. You will be given an opportunity to explain to the judge your reason for requesting an adjournment. If you know the name of the Judge assigned to your case, you should check the Judge's Part Rules to see if he or she has any requirements that may not be covered in this section. Click on Judge's Rules to check.
Important: Please be aware that upon a second request by a respondent for an adjournment, or if more than 30 days have passed since the case first appeared before the judge, not counting any days due to adjournment requests by the petitioner, the petitioner may ask the judge to order that all the money due from the date of service of the petition be deposited in the court. If this is done, the judge will determine the amount and the respondent will have to make the deposit within five days. If the money is not deposited, the petitioner may get a default judgement against the respondent.
Sending Someone to Request the Adjournment
If it is an emergency and you cannot appear yourself to request the adjournment, but wish to send someone on your behalf, you must give that person written authorization to make the request for you. That person must bring the written authorization to the court.
The written authorizing statement which allows someone to
request an adjournment on your behalf must
contain the following items:
1. The index number of your case.
2. Your name and your address.
3. A signed statement that you are allowing the person to request an adjournment for you.
4. The name of the person you are sending.
5. The reason you are not appearing yourself to make the request.
The person who comes to court for you must bring this statement and all other papers that you received, and should be able to tell the clerk the reason for the request.
The Judge may deny the request for adjournment. If the request is denied, you will be marked in default, which may be serious. You can learn more about this and other housing court procedures by reading our Legal and Procedural Information sections.
Writing a Letter to Request an Adjournment
In an extreme emergency, where neither you nor anyone else can appear on your behalf, you may write a letter to the court. You must explain your reason for making the request and be sure to include the case number and year of your case, and the scheduled date of the hearing you will not be able to attend.
Address the letter to the appropriate civil court clerk's office. Send a copy of this letter to the other party to the action. If the judge decides to grant your adjournment, you will be notified.
If the request is denied, you will be marked in default, which may be very serious. You can learn more about this and other housing court procedures by reading our Legal and Procedural Information sections.


text:
Web API
Use Google Tag Manager to manage tags (such as measurement and marketing optimization JavaScript tags) on your site. Without editing your site code, you use GTM user interface to add and update Google Ads, Google Analytics, Floodlight, and non-Google tags. This reduces errors and allows you to to deploy tags on your site quickly.
Mobile APIs
Use Google Tag Manager to manage analytics and advertising tools in your apps without having to rebuild and resubmit the applications' binaries to the app marketplaces.
Custom templates
Build your own tag and variable templates in Google Tag Manager.
The Google Tag Manager API provides access to Google Tag Manager configuration data for an authorized user. Use the API to manage accounts, containers and container versions, tags, rules, triggers, variables, and user permissions.
For more information about the features and benefits of Google Tag Manager:
- Visit the Google Tag Manager product site.
- View the Google Tag Manager technical factsheet.
- Visit the Google Tag Manager help center
Vendor Tag Template Program
The Google Tag Manager Tag Vendor Program allows tag providers to natively integrate with Google Tag Manager's tag templating system.


text:
Professor Shiu-Ying Hu, Emeritus Senior Research Fellow of the Arnold Arboretum of Harvard University, passed away in Hong Kong on May 22 at age 102. An eminent scholar and plant taxonomist, Professor Hu was also a beloved teacher who served as Honorary Professor of Chinese Medicine at the Chinese University of Hong Kong and Senior College Tutor of Chung Chi College. Over her long career, she collected and identified as many as 185,000 plant specimens, published more than 160 papers, and was an internationally-recognized authority on Ilex (hollies), Hemerocaulis (daylilies), Paulownia, Compositae (daisies), and Orchidaceae (orchids).
Born in China, Professor Hu graduated from Ginling College in Nanking in 1933 and received her master's degree from Lingnan University in 1937. In 1949, she became the first Chinese female to obtain a doctoral degree in botany at Harvard, and worked as an herbarium assistant at the Arboretum. Named a research assistant by Arboretum Director Richard Howard in 1953, Professor Hu devoted herself full time for the next four years to the Flora of China Project. In 1968, Professor Hu took up the position as Senior Lecturer in the Department of Biology of Chung Chi College and continued her work investigating the botanical diversity of Hong Kong. She was appointed Advisor to the Sunyatsen Botanical Garden in Nanjing, Honorary Professor of South China Agriculture University in Guangzhou, Advisor to the Fairy Lake Botanical Garden in Shenzhen, and Honorary Professor of Chinese Medicine at the Chinese University of Hong Kong in 1999.
Though she officially retired from her appointment at the Arboretum in 1976, Professor Hu continued to be very active in plant research and the study of taxonomy well into her tenth decade. She made tremendous contributions to the promotion of botany at the Chinese University of Hong Kong, including organizing an herbarium that supports scientific study at a number of China's universities and research institutes. Professor Hu was also instrumental in the development of the School of Chinese Medicine at the Chinese University of Hong Kong, and her book An Enumeration of Chinese Meteria Medica has greatly influenced the global practitioners of Chinese medicine since its first appearance in 1980. Astonishingly, a span of nearly 50 years separates the publication of two of her major works, The Flora of China, Family 153, Malvaceae (1955) and Food Plants of China (2003).
In 1992, the Holly Society of America established The Shiu-Ying Hu Award to honor Professor Hu for her lifetime study of the genus Ilex, and named her the award's first recipient. Professor Hu was also the first recipient of the American Botanical Council Lifetime Achievement Award in 2008. Funeral services will be held on June 15 in Hong Kong, and a memorial service is planned for October 2012 at the Chapel of Chung Chi College at the Chinese University of Hong Kong.
Find out more about Shiu-Ying Hu and her work with the Flora of China Project in the Archive Collection of the Arnold Arboretum Horticultural Library. [pdf].


text:
August is National Peach Month
August is National Peach Month. All hail the peach!
It's National Peach Month and celebrating is an absolute pleasure. Just choose your favorite recipe and savor nature's sweet and juicy miracle fruit. Peach pie. Peach cobbler. Peaches right off the tree. It all goes great with a shot of Forever Aloe Peaches®!
Why August?
Nothing says summer like a peach in the hand. The colors of its fuzzy flesh are reminiscent of the sun itself, with vibrant shades of red, yellow and orange. It's also the perfect time to eat peaches, which are harvested throughout the summer.
August, however, is when peaches reach the pinnacle of perfection. Not too hard. Not too mushy. The sweetness has hit its stride along with the nutritional content. A fresh peach is loaded with vitamins and antioxidants that help fuel your body and provide nutrition without a lot of calories. In fact, the average medium-sized peach is only 37 calories!
This delicious fruit is revered all over the world with more than 700 known varieties in existence. The peach originated in China and is a very important cultural symbol. The Chinese people consider peach to be a tree of life and a symbol of unity and long life. Peach blossoms are often carried by Chinese brides on their wedding day.
In the United States, Georgia is famous for its peaches, but California is the largest producer and grows more than half of all the peaches harvested in America.
Enjoy peaches year-round with Forever Aloe Peaches®
In a few months when there's a chill on the air and the carefree summer days feel like a distant memory, you can bring back that summer feeling with Forever Aloe Peaches®. It's made with pureed peaches and natural peach flavor to bring you the sweet taste of these sun-ripened beauties any time of year.
Of course, you'll get all the benefits of aloe vera gel. Forever Aloe Peaches® supports your proper digestion and promotes a healthy immune system thanks to its 84.5% pure aloe vera gel content. There's never a bad time drink in the benefits of aloe vera combined with the wonderful natural flavors of peach.
*Source for peach facts: Arizona Farm Bureau's Fill Your Plate blog: http://fillyourplate.org/blog/celebrate-national-peach-month-interesting-peach-fac/


text:
[This is a page of links for a 30 minute session on Data that I'm doing tomorrow.]
Data Trends: Structured, Visual, Interactive
- Wolfram Alpha — Precise, high-quality answers for structured data. "Wolfram|Alpha's long-term goal is to make all systematic knowledge immediately computable and accessible to everyone."
- Baby Name Voyager — Visual, interactive exploration of a huge data set
- How Different Groups Spend Their Day — New York Times interactive, visual presentation of a more complex data set.
- Inaugural Words — New York Times mixes word clouds with a simple database of the Presidents
- Who Went Where [screenshot] — An example of Linked Data that lets you search for a college or university, and find recent New York Times articles about alumni [Who Went Where][Build Your Own NYT Linked Data Application]
Data and Tools
- Open : All the Code that's Fit to Print — The New York Times provides open APIs to lots of data and shares code and other tools for working with data
- Guardian Open Platform — UK newspaper provides a large collection of curated data and tools to work with them
- Free book usage data from the University of Huddersfield — Dave Pattern's announcement about making the library's circulation data available under an Open Data Commons license. If more libraries did this, it could be an amazing resource for recommender systems and other analysis
Your Own Statistics
- Flickr Stats — If you have a Flickr Pro account and turn on statistics recording, you can explore your Flickr Stats in many ways.
- Boatwright Library at a Glance — Visual presentation of statistics
- Indianapolis Museum of Art — Visual data widgets provide access to a wide variety of counts and statistics, with the ability to drill down and get more detail, select by department, follow by feed and much more. This site is built on Drupal and has been released as the open source museum-dashboard
- Google Spreadsheet Gadgets — Google makes it easy to create data gadgets in different formats, and offers more powerful tools through Google Code


text:
Thomas Kolasa went 10-4 in the men's sabre (Gil Talbot).
QUEENS, N.Y. – The No. 6 Harvard men's fencing team opened 2013 at the St. John's Invitational Saturday, as the Crimson earned a victory over No. 7 Columbia.
Harvard topped the Lions, 18-9, winning the sabre, 8-1, and the foil and epee by 5-4 margins. The Crimson faced several other top teams, but fell to No. 1 Ohio State, 16-11, No. 2 Penn State, 18-9 and No. 3 Notre Dame, 17-10. Harvard also suffered a narrow defeat to No. 5 St. John's 14-13, finishing the day with a 1-4 record. The Crimson is now 5-5 on the year.
Thomas Kolasa and Alexander Ryjik led Harvard with 10 victories in the sabre, while Brian Kaneshige went 9-6 in the foil.
In the match with the top-ranked Buckeyes, the Crimson won the sabre, 6-3, but dropped the foil, 7-2, and the epee, 6-3. Harvard also won the sabre against Penn State, 6-3, while falling in the other two weapons by 7-2 margins.
Notre Dame swept the Crimson, taking the sabre and foil, 5-4, and the epee, 7-2. Harvard defeated the Red Storm in the epee, 5-4, but fell by 5-4 scores in the other two weapons.
In the men's epee, Michael Raynis paced the Crimson with seven victories, while Ben White earned five wins on the day. Eric Arzoian picked up seven wins in the sabre, and Lucas Lin won six matches in the foil.
The Crimson will host the Ivy League Championships at Gordon Indoor Track Feb. 9-10.


text:
Mike Mather is an Emmy-winning and Murrow-winning investigative reporter.
In his 25-year career, he has reported nationally and internationally for NewsChannel 3, The Daily Press, The Virginian-Pilot, CBS News, and The New York Times. His stories have earned dozens of journalism awards, including a Pulitzer nomination.
Career highlights:
-Proved Norfolk city leaders were not telling the full truth about the death of a police recruit. The city's police chief later lost his job.
-Tracked down a murderous fugitive in Russia and secured the man's return to the United States. He was convicted.
-Exposed a broken system that allowed a Norfolk auctioneer to repeatedly pocket clients' money, without consequences. Mike's story led to a state investigation and felony charges.
-Gained a pardon for a man wrongfully convicted of rape.
-Revealed how the FBI lost control of secret evidence in the Colonial Parkway serial murders, leading the agency to re-open the cases.
-Uncovered fatal mistakes in Virginia Beach's foster-care system that led to the death of a child. The state launched an investigation because of Mike's stories, and the director resigned.
Mike is one of the only journalists in the nation to graduate from a police academy and SWAT academy, where he got an inside look at how officers are selected and trained. He and his wife Elizabeth have four boys, including triplets. One of Mike's triplets, Owen, has Cerebral Palsy. Mike helped found a charity running team in Virginia Beach dedicated to including disabled children in athletic events. Mike is also a volunteer instructor for Wintergreen Adaptive Sports, where he helps teach people with disabilities, including his son, to ski or snowboard.
Mike was born and raised in Virginia Beach but now lives in the Ghent section of Norfolk. He enjoys running, photography, snowboarding and volleyball, and he is a private pilot. He and several NewsChannel 3 colleagues sometimes pool their musical talents to play in a band. Mike plays guitar.
Follow him on Twitter, @mikemather


text:
Nitronic Rush Forum
The official forum of the survival driving game developed by Team Nitronic
Delacroix wrote:Yes, we know Mister, yours is always the biggest.
Mr. Mister wrote:Do you have English set as your keyboard language, though? (it should say EN at the left of the taskbar).
Return to Share with the Community
Users browsing this forum: No registered users and 1 guest


text:
Pageantry with a Brazilian flair opened the 2016 Olympic Games — samba, supermodel Gisele Bündchen, the rain forest and rap. Here are some top moments from the ceremony.
Michael Phelps Glows
The 22-time Olympic medalist glowed with more than pride as the United States flag bearer in the opening ceremony. You had to look carefully to see it on television, but Phelps was wearing a light-up jacket from team designer Ralph Lauren.
Phelps, swimming in his fourth Olympics, wore a blazer that had USA illuminated on the back.
U.S. & World
The 31-year-old is the most decorated Olympian of all time. He came out of retirement to swim in five events in Rio.
Best shirtless moment? Tonga flag bearer Pita Taufatofua. No shirt but shining with oil. He will compete in taekwondo.
Brazilian Icons in the News
Two of Brazil's best known stars, soccer great Pele and supermodel Gisele Bündchen, were set to be part of the opening ceremony in Maracana Stadium Friday night - but then things changed.
Pele's poor health kept him from lighting the cauldron from the Olympic flame, and in announcing his withdrawal, he apologized to his fellow Brazilians for disappointing them. "And as a Brazilian, I ask God to bless all who participate in this event," he said.
The soccer legend did hold the Olympic flame at the Pele Museum on Santos, Brazil, in July, but he has had hip surgery and often uses a cane.
Lighting the cauldron Friday night was Brazilian marathoner Vanderlei Cordeiro de Lima.
In Bündchen's case what was missing was a controversial skit in which she starred, pulled from the ceremony after charges of racism.
The skit showed her being robbed by a poor black boy, a child from one of Brazil's favelas, in a city with high rates of crime and poverty.
The ceremony's creative director told The Washington Post the skit had been misinterpreted: that it actually depicted Bündchen protecting a food vendor after he tried to take a selfie with Bündchen and was chased by security guards. It was dropped because it was not funny, he said.
Instead Bündchen herself strode across the stadium to the classic hit song, "Girl from Ipanema," and was cheered.
Boos for Brazil's Interim President
The 2016 Games were formally opened by Brazil's leader, in this case the interim president, Michel Temer, who was jeered. That's because President Dilma Rousseff has been impeached and removed from office while she is tried, and Temer, her vice president, has been unpopular since taking over in May.
History Through Brazilian Eyes
Brazil did not shy away from its hundreds of years of slavery in its opening ceremony. Performers wearing weights and turning large wooden wheels depicted the African slaves who toiled in the sugar cane fields and on plantations.
The New Olympic Color: Green
These Olympic Games took the environment as a theme, beginning with the opening ceremony's depiction of the creation of Brazil's rain forests. The ceremony's creative team said it would deliver a message for planet Earth. Each athlete will be given a seedling to plant, to create an Olympic forest in Brazil as their legacy to Rio de Janeiro.
"They will leave a tree in Brazil," said Marco Balich, the show's lead producer. "Hopefully in two years' time we will have a wonderful Olympic forest. We will celebrate humanity and we will celebrate Rio."
Who Was First in Flight?
The Wright Brothers got grounded in Rio.
The Olympic Games' opening ceremony honored a Brazilian man as the airplane's inventor: Alberto Santos-Dumont.
The son of a coffee grower, he flew a boxy aircraft called the 14-bis in October 1906 above a field in France. It was the first public flight and in Europe, he was credited as the inventor of the airplane.
But the Wright brothers, Orville and Wilbur, disputed that claim, disclosing they had flown first at Kitty Hawk, North Carolina.
Brazilians argue that because their airplane used a ramp to take off and did not have wheels they did not truly fly.
For Refugees, a Team of Their Own
The 10 members of Team Refugee entered the stadium carrying the Olympic flag. The team, the first of its kind, was formed to draw attention to the magnitude of the refugee crisis.
The members: Rami Anis and Yusra Mardini, two Syrian swimmers; marathoner Yonas Kinde from Ethiopia; Yolande Bukasa Mabika and Popole Misenga, judo contestants from the Democratic Republic of the Congo and five runners from South Sudan, Yiech Pur Biel, James Nyang Chiengjiek, Anjelina Nada Lohalith, Rose Nathike Lokonyen and Paulo Amotun Lokoro.


text:
As previously noted, I'm not a big fan of feet. The only exception being babies and little kids' whose feet have yet to become marred by age, ill-fitting shoes, ingrown toenails, hairy toes, and general ugliness and stinkiness.
But the real screw-over when it comes to kids and their feet are … shoes. The reality of this great rip off is you are damned if you do and damned if you don't.
Your options:
- Spend an extraordinary amount of money on well-made, nicely-fitted shoes like Stride Rites. Only to have your child grew out of them in roughly 8-10 weeks.
- Spend as little as possible at Payless or Target on questionably-made but OK-fitting shoes. Only to have them fall apart due to wear and tear in roughly 8-10 weeks.
Given that I naturally err on the side of being cheap, I usually go for option 2 but always regret it as the day inevitably and all-too-quickly arrives when there's a huge rip in the toe or the insides fall out or the fasteners no longer fasten.
I was mighty impressed when the new – cheap – sneakers I bought my kids back in June survived the 8-9 weeks of summer camp. Yes, they were filthy and worn but they still worked. But a week at Disney pushed them over the edge. Perhaps it was the 4-5 miles walked each day in 95 degree heat and humidity that finished them off. Or maybe it was the soaking they received on our final day, followed by an hour spent in the drier so they'd be dry enough to wear on the journey home.
Either way, one pair came home with rips and holes. The other pair more or less survived – except for the fact that I managed to leave them behind in our hotel.
So today both my kids are proudly sporting nice new sneakers. Bought on the cheap. Should last us till – oh, Halloween if we're lucky.