text:
People have been vacationing in Naples, Florida for decades, taking advantage of the weather and the area's beautiful natural surroundings. But what if you're visiting Naples for the first time, how will you know what the most popular attractions are in the area? We have put together a list of our Top 5 things to do in Naples to help you see the best the area has to offer.
Top 5 Things To Do In Naples, Florida
#5 Naples Zoo
The Naples Zoo is the perfect place to explore the animal kingdom. Come face to face with towering giraffes, speedy cheetahs, playful lemurs of Madagascar, African lions, fierce alligators and even a tiger. There are plenty of captivating exhibits to stop at while strolling along the mile long paved path. Don't miss one of the zoo's exciting animal shows, interactive activities and educational programs for all ages. For more information, visit www.NaplesZoo.com.
#4 Everglades Excursions
The eastern edge of Naples dissolves into the Everglades. Called the "River of Grass," the Everglades boast many different types of eco-systems; swamps, dry areas called hammocks, the Big Cypress National Preserve and vast mangrove mazes. It's hot, swampy, buggy and full of alligators, but it's also one of the most amazing natural areas on the planet. You can tour Big Cypress National Preserve in a (gator-proof and nicely air conditioned) bus or get a little closer on a high-speed airboat ride or try one of the slower and more intimate jungle cruises through Everglades National Park. Stay at the Port of the Islands Everglades Adventure Resort and take advantage of the many tours they offer.
#3 Dolphin & Sunset Cruise
Naples Bay and the Gulf of Mexico are home to a large population of Bottlenose Dolphins. These friendly animals love to ride boat wakes and show off for clapping on-lookers. Here are a few companies that will take you through Naples Bay to watch the dolphins, view the mansions of Port Royal and then cruise into the Gulf for a famous Naples sunset.
#2 Shopping & Dining Districts
Naples is known for fantastic open-air restaurants and stylish boutique shopping. Areas like Naples' Fifth Avenue South, 3rd Street South, Tin City, the Mercato and Bayfront are all must visit areas for a new Naples visitor.
#1 Naples Beaches
Of all the attractions that Naples offers, it's the miles and miles of white sandy beaches that lure people to Naples from all over the world. Naples' beaches treat guests to some of the most beautiful beaches in the world. With magical sunsets, calm Gulf waters and amazing seashells—the beaches are a Naples must. Beaches like Vanderbilt Beach, Naples Municipal Beach (Naples Pier), and Lowdermilk Park Beach are usually busier with tourists and locals. While other beaches, such as Delnor-Wiggins Pass State Park & Beach and Clams Pass Beach Park are a little less populated, and more secluded.
There are so many great things to do in Naples that we couldn't list them all, but the five listed above will give any first time visitor a well-rounded experience of what Naples is all about.
Come visit Naples, Florida…paradise is waiting.
See you under the sun!
-Team SunStream
For more information about SunStream and their portfolio of hotels and resorts, visit www.SunStream.com.
(Photo by andrewafoley2005 via Flicker)
Please Follow Us If You Love The Florida Lifestyle!
Park Shore Resort on Google+
SunStream YouTube Channel
SunStream On Pinterest
Tags: Naples


text:
A group of students from Price Chapel joined other students this past July for a missions week to Mexico on a construction job. Four adults and 18 students, all junior and senior high, were among over 98 students to help build a large patio extension to a church and conduct children's ministry programs in local parks.
Also attending were several students from East Carbon, as well as Bellingham, Wash., and Draper and St. George.
Coordinated by Shawn Bagley, youth pastor at Price Chapel, the trip instilled the importance of serving others. "When you see a need, you fill it," he says, explaining that this was his seventh mission trip to Mexico. The patio was built in Jaurez, Mexico, just south of El Paso, Texas.
"The purpose of the trip was to help others who don't have as much," says Bagley, adding, "We work with the students to instill the necessity of serving others. When they see a need to help in any way they can. This is a cross cultural ministry experience where they see a different way of living."
He also says that the experience teaches the local students some new skills, working with concrete, re bar and construction.
Besides the construction project the kids also played games and presented bible lessons to people in local parks.
"The kids loved it. They want to go back," summarized Bagley.

subset: commoncrawl


text:
Saturday, Feb. 16 is going to be Coach Stu Foster Day at the Price Desert Wave Pool. The Barracudas swim team and the Carbon High School swimming and diving teams are sponsoring a fund raiser and community swim meet for the coach, whose health has taken a turn for the worse.
The meet will get under way on at 10 a.m. at the Price pool. There will be prizes, a raffle, baked goods and Cold Stone ice cream.


text:
I hate to admit it to myself and to others, but I really did just ruin a small pillow top by machine quilting it. You read correctly: I ruined a perfectly nice piece of patchwork.
© 2015 F+W All rights reserved.Use of this site signifies your agreement to the Terms and Privacy Policy, updated March 2007


text:
Find accommodations in Peabody with the hotel list provided below. Search for the cheapest discounted hotel and motel rates in or near Peabody, MA for your business or personal leisure travel. We show the best Peabody, Massachusetts hotel and motel rooms. Browse the Peabody area hotels to find the perfect lodging! Please use the provided map of the Peabody hotels. Planning a group? Lock in Peabody Group Hotel Deals
The Peabody center is around 1 mile southeast of Lahey Clinic and 9 miles southeast of Boxford State Forest.
How should we direct your call?


text:
High Sierra AT6 30 in. Wheeled Cargo Duffel
The High Sierra AT6 30 in. Wheeled Cargo Duffel will make a great travel mate for you on your many journeys. A large main compartment with a U-shaped zippered opening makes packing easy. There are two side-load end compartments that can hold more clothing, or shoes and other accessories. There is also a front pouch which is perfect for items that you might need to retrieve at short notice, like travel documents, etc. With the recessed, telescoping handle system with a locking mechanism, it is effortless to pull the duffel bag behind you. In-line skate-style wheels in protective, corner-mounted housings ensure that you will never have to carry the duffel bag in your arms. The unique integrated bridge at axis of the wheels makes sure that the bag does not wobble and continues to roll. Shielding the bag from abrasion is a kick-plate between the wheel housings. SURE-GRIP handles give you a great hold on the luggage, and you can tuck them down flat when you are not using them. Thanks to the molded feet, the bottom of the bag is also protected. Reflective piping is an added safety feature on the bag making it identifiable even in the dark. So, be it a weekend getaway, or a business trip or a vacation, the High Sierra AT6 30 in. Wheeled Cargo Duffel can carry for you, all that you need, and then some.


text:
in this issue
premium services
online directory
customer care
World News and Views :: Top of the News
NACD signs MOU with CACD, discusses working with Central America
November 18, 2013 | Lindsay Frost in Marco Island
NACD kicked off its annual meeting in Marco Island, FL today—bringing together over 600 attendees to discuss industry issues and celebrate a successful year. Regulatory issues and Responsible Distribution, which is similar to ACC's Responsible Care, were the hot topics as NACD reached out to similar organizations across the globe, including the Canadian Association of Chemical Distributors (CACD; Ontario). NACD signed a memorandum of understanding (MOU) with CACD this afternoon with the goals of working together to mitigate issues within both their...
This information is only available to Chemical Week subscribers.
Forgot your user ID or password?
Not an IHS Chemical Week member yet?
Here's why you should be:
100% Satisfaction Guarantee
contact us | about us | customer care | privacy policy | sitemap | advertise
Copyright © 2015 IHS, Inc. All rights reserved. Reproduction in whole or in part without permission is prohibited.


text:
Mary Ann Jimenez couldn't stop shaking after her son captured the first gold medal of the 2013 Warrior Games. It was a special gift on a special day. "It was the best Mother's Day present ever," she said after Marine Staff Sgt. Ronnie Jimenez won the 10K men's handcycling event. "We're all so proud of him."
The Warrior Games is a competition for wounded, ill and injured troops and veterans at the U.S. Olympic Training Center and the United States Air Force Academy in Colorado Springs, Colo. Five American teams – one each from the Air Force, Army, Marine Corps, Navy/Coast Guard and Special Operations – and the British Armed Forces team faced off in archery, cycling, shooting, sitting volleyball, swimming, track and fi eld and wheelchair basketball.
Jimenez went on to win silver medals in three swimming events, helping the Marine Corps team to its fourth consecutive overall title.
The USO, a major sponsor at the Games, hosted a two-hour family event that included face painting, a magician and arts-and-crafts stations where children made signs and medals in honor of their competing parent.
Athletes at each venue could also fi nd a Mobile USO, duffle bags, snacks and on-site support made possible by Rocky Mountain USO staff and volunteers
Rarely do so many important men and women in suits line up to pose with a children's icon.
More than 60 members of Congress came out in late May for the Operation USO Care Package Service Project in the foyer of the Rayburn House Office Building on Capitol Hill. And just as the dozens of elected officials and congressional staffers started packing supplies into plastic bags headed for Afghanistan, Cookie Monster's giant blue hand reached in to help out.
The service project – which the USO hosts twice a year in the Rayburn Foyer – produced 2,000 care packages destined for troops serving in Afghanistan.
"The soldiers, the sailors, the airmen, the Marines – all of them really appreciate these packages when they get over there," said Rep. Howard "Buck" McKeon (R-Calif.), a cochair of the USO Congressional Caucus and the chairman of the House Armed Services Committee.
The event also served to highlight the USO's five-year partnership with Sesame Street. The Sesame Street/USO Experience for Military Families – the USO's longest-running tour – will visit 42 military installations in eight countries in the coming months.
Heather Harrington was having trouble finishing a conversation. It was hardly her fault.
The new manager of the USO Nashville – located in the Nashville International Airport – had a stream of wellwishers flowing past the 900-square-foot center's welcome desk at its official grand opening in early May. After months of 90-hour weeks, she still couldn't catch her breath.
"I've got a really good group of volunteers and they've been willing to bend to do anything I've needed them to do," she said, pausing between sentences to shake hands and trade smiles.
Located between the C and D concourses inside security, the center will serve more than 14,000 troops and families – many of them Fort Campbell-based – who travel through the airport each year.
There's a TV room with leather sofas, a game room with six fl at screens hooked to Xbox 360s, a kids play area, four computer terminals with Internet access, free Wi-Fi, a small kitchen and plenty of places to sit and relax.
"Every day inside this center, countless little things will make life better for our troops and their families," USO President Sloan Gibson told a crowd of more than 200 people at the opening.
Of the many lessons that Sabrina Pullido has learned in her time as the USO's Italy Area Director, one stands out.
"You can't be sitting on your chair hoping to serve hundreds of sailors," she said. "You need to go where the sailors need you."
Pullido's area includes USO Rome and USO Naples, which was recently named the best overall USO center, based on a worldwide survey of troops and families. She said it's important to be where the troops are and to enlist the help of the community.
"It never ceases to amaze me how much generosity, goodwill and support the public has for the USO mission," Pullido said.
Pullido – a Navy brat who spent most of her childhood at bases in Naples and Sigonella, Sicily – joined the USO in 2011 at age 23. At fi rst, she was drawn to the dynamic work environment. It soon became a much deeper connection.
"The USO mission is without a doubt my favorite part of the job," she said. "To get up, knowing you can make a difference every day, in a different way, is a great motivator."
The pools are open and the grills are fired up. Summer is in full swing.
This year, supporters of our troops all across the country are adding a new dimension to the typical summertime cookout with help from the USO's Barbecue for the Troops.
The new initiative invites Americans to turn any celebration into an opportunity to support the military by raising funds for the USO programs and services that our troops and families enjoy the most.
If you're interested in hosting a Barbecue for the Troops event, you can get started by visiting BBQfortheTroops.org. There you can register your event and download a toolkit that will walk you through the planning process and provide simple tips to help make your event a smashing success.
You might request that guests make a donation to the USO to attend the cookout. Or you might make their donation an entry fee into a horseshoes, volleyball or badminton tournament, or maybe a pie-eating contest.
Barbecue for the Troops is part of the USO's Honor, Salute, Celebrate campaign to recognize our troops and families and to thank them for their sacrifice.
Will Smith's trademark smile flashed as he moved from his dressing room to the stage for sound check and on to the media room. Behind him, his son Jaden followed in his footsteps, literally and figuratively.
Will's new film, "After Earth," is a launching pad for Jaden's transition into the space that Will has commanded for almost two decades: action film icon. But this event was all about the Smiths showing their appreciation for the troops at Fort Hood in Killeen, Texas.
"I've been aware of the USO for years." Will said. "We've been trying to find something for a while and this was just a perfect opportunity."
The evening included a meet-and-greet where the Smiths chatted with more than 100 wounded troops and their families, followed by a Q&A with about a dozen of the approximately 2,400 troops and family members who gathered for a special screening of the new film. Then the surprise: a rare performance of some of Will's greatest songs, backed by his longtime recording partner DJ Jazzy Jeff.
Tell USO Survey ★ Some results from the 2012 TellUSO survey in which thousands of troops and family members from around the world participated ★ 93 percent say the USO helps ease separation from family and friends ★ 95 percent believe the USO lets them know their country supports them ★ 90 percent say USO personnel have had a positive impact on them personally ★
We would love to hear from you.
USO P.O. Box 96860 Washington, DC 20077-7677 Phone: 1-888-484-3876
© 2015 USO, Inc. All Rights Reserved.


text:
- Musician's Friend Best Selection, Price & Service. Guaranteed.
Call our Gear Heads
at: 800-449-9128
Call our Gear Heads
at: 800-449-9128
Review Snapshot®by PowerReviews
Reviewed by 4 customers
Sort by
Comments about Onori 2" Nylon Hootenanny Guitar Strap:
Bought one of these straps at Christmastime 2011, just looking for a little change of pace from my plain-but-always-reliable Ernie Ball straps. Thought it looked rather cheap for the price, but went ahead & started using it. On the evening of April 20, 2012, about 4 months after purchasing it, the cheap little plastic connector that holds the strap to the seperate strap-end broke in the middle of a gig, sending my favorite Strat crashing to the floor of the stage. Luckily, Strats being as tough as they are, no damage was done beyond a few scratches. In 40-some-odd years of playing, such a thing had never happened to me before. I suppose it could someday happen again, but if it does, it very definitely won't be because I'm using one of THESE straps! Pure garbage, folks!!
Comments about Onori 2" Nylon Hootenanny Guitar Strap:
Like the fit and size. Do not like the scratch edges
Dear Sirs - I the fit of the strap and the width so it should be comfortable. Your service was very good and the strap arrived as described. My only complaint is that the edges of the strap are scratchy on bare skin. I believe there's some kind of coating along the edge to keep it from fraying and it makes the strap uncomfortable against your skin. I live in Florida and often wear clothing without a high neck so I'm noticing it more and more as I use it.
Thanks....Nancy Richardson
Comments about Onori 2" Nylon Hootenanny Guitar Strap:
I got the blue/purple one. Looks good. Does it's job fine. The design is nicely detailed up close.
Comments about Onori 2" Nylon Hootenanny Guitar Strap:
Very nice looking nylon strap, good leather ends. CHEAP BRITTLE PLASTIC slider parts that break very easily with no warning. I've had 2 of these straps (on 2 different guitars) break in the same place (where the leather end is attached to the adjustment slider) in the last 3 months. One strap broke at a gig (made it through the night thanks to duct tape), the other strap broke while practicing at home. Both straps live in the accessory pocket of hard cases when not in use. I have NEVER had any strap by any other maker fail in over 30 years of playing. I'll never buy another Onori strap no matter how cool the nylon webbing looks. IME they just can't be trusted. Buy something that doesn?t use fragile plastic in critical places.
Our product catalog varies by country due to manufacturer restrictions. If you change the Ship-To country, some or all of the items in your cart may not ship to the new destination.


text:
Artists Artist: Franz Zumstein
Artist Franz Zumstein
Available series in store category "Comic books"
Franz Zumstein in the
"Franz Zumstein has been drawing comics since an early age, but started his professional career as a teacher. His first comic, 'L'Escorte', was published in 1985 in magazine BDCH. He contributed his comics to several french, german and swiss publishers. His most popular series, 'Die..." [ Read more ]


text:
Whether you're manning a concession stand at the big game, managing the local gas station, or run a fun little eatery with a bit of everything, having one or two hot dog cookers working for you is a great way to make easy money. These convenient little machines keep those dogs thoroughly cooked and plump throughout the day, and with minimal effort on your part, they can act as a one-stop station for hungry travelers. Great for everything from your classic hot dogs to smoked sausages, jumbo dogs, cheese filled dogs, and even taquitos, hot dog cookers can't be beat when it comes to hot, grab-and-go food.
Log in with an existing account - If you have purchased from eTundra.com and have previously created a password protected account, please sign in below.
Track your orders online, view your order history and more!


text:
A security guard at an Apopka apartment complex was arrested on suspicion of pointing a laser at a deputies inside an Orange County sheriff's helicopter.
William Leverance was arrested early Wednesday at the Marden Meadows apartments off State Road 429 near State Road 414.
Investigators said the pilot reported the incident, and when deputies confronted Leverance, who was on duty, a laser was found in his pocket.
No one was hurt in the incident, but lasers can cause temporary blindness for pilots.
Leverance posted bond and was released from jail.
Watch Local 6 News and stay with ClickOrlando.com for more on this story.


text: We're breaking a pattern here on the blog and writing—directly and unabashedly (ok, maybe more directly and unabashedly than usual)—about one of our own projects. We recently finished designing, fabricating and installing a miniature park, in the parking lane of 22nd Street at Bartlett in the Mission District. The site for this "parklet" ... More


text:
(NEWS CENTER) -- Everyone has that favorite present they find under the tree that brings you to tears of joy.
One of our Facebook friends, Melissa Reinhard, was encouraged by her friend to post a video on our page of her boys opening a very important Christmas present. Melissa tells us that she and her family lived here in Maine all their lives, but moved to Florida last July. Since then, her two youngest sons have been missing their friends and family here in Maine. So, Santa thought a trip to Maine was in order.
Watch the video to see their reaction when they found out on Christmas morning.


text:
Welcome to LaserMyGun.com, California's premier source for paintball anodizing and laser engraving. Have a look around, and be sure to check out our gallery with over 100 examples of anodizing and engraving samples. If there's an answer that can't be answered from the website, head over to the contact page and send us an email. Or, give us a call anytime 12-8PM PST Monday-Saturday at 714-452-7812 and we'll be happy to answer any questions you may have about the anodizing/engraving process.
For any price related questions, please use the quote form to the right. Include your name and email so we can get back to you. Include a detailed description of exactly what anodizing/engraving work you're looking to have done. If you have any photo references or samples, be sure to include links to those as well. We do our best to respond to all quote requests in 3-5 days. If you do not receive a response from us within a week, give us a call at 714-452-7812, and we'll answer any questions you may have.


text:
- Get Involved
- News
- Education & Events
- Publications & Research
- Marketplace
- Jobs
- Membership
- Accreditation
- About ACA
Risk Management: Child Maltreatment Risks and Strategies
Risk Assessment
Child maltreatment is a plague in our society. This is a fact. Historically, there was a lack of awareness about the scope of the problem. This has changed over time. In the mid-1980s Americans were shocked to hear the allegations of child sexual abuse and molestation involving a California childcare center. This event brought the issue of child sexual abuse and molestation to center stage.
The impact of this event has been wide and continuous. At the time, it created some panic and overreaction among the public, insurance underwriters, and state regulators. The allegations of child sexual abuse and molestation ruined the lives of some teachers, who were wrongfully accused. Our society was changed by this event. It would never be the same again. Ultimately, the McMartin case served a vital purpose. It increased awareness about the risk of child sexual abuse and molestation, which has lead to a commitment to protect the children. This commitment manifested itself in individuals and businesses serving children and included significant efforts from federal (National Child Protection Act of 1993; The Volunteers for Children Act in 1998; Child Abuse Prevention and Treatment Act - CAPTA) and state government to reduce the risks and protect our children.
Over fifteen years have passed since the reports of sexual abuse at that childcare center made national news. In my opinion, our society has made real progress toward fighting this plague. Unfortunately, events of the past year may cause some to dispute this statement. Others disagree more fundamentally and believe we have not done enough to deal with the problem of child maltreatment. They believe perceptions of progress are illusory. Regardless of opinion, the fact remains, children continue to be neglected by their parents, sexually abused by family members and others, exploited, beaten, bullied, and emotionally abused in shocking numbers.
There is a lag in the data on child maltreatment and some dispute over the sources. The federal government keeps the statistics. The U. S. Department of Health and Human Service, Children's Bureau, published a report on child maltreatment in 1998, which cited 2.8 million reports of child maltreatment per year. That means that child abuse is reported, on average, every ten seconds! Some experts think the incidence of child maltreatment is actually understated. The data in the report is available for you to review. You can find the report on the Internet at www.childhelpusa.org.
Risk Identification
Increased awareness often leads to identification of new risks and new thoughts about old risks. You probably noticed the use of the words child maltreatment. In the past, much of our focus on risk management at camp has been directed toward sexual abuse and molestation and more recently toward sexual harassment. This focused effort runs the risk of developing compartmentalized thinking and of losing sight of the bigger picture. Successful management of the risks of child maltreatment, including sexual abuse and molestation, requires a balanced approach. The focus on sexual abuse and molestation is understandable - it is one manifestation of our society's frustration over this issue. On the other hand, insurance underwriters have raised the issue and forced attention to it as a precondition to transferring the risk. While this has been valuable and probably necessary, we can't lose sight of the bigger picture of child maltreatment.
Experts have defined child maltreatment to include sexual abuse, exploitation, or molestation (sexual activity between a child and an adult, or a child with an older child), physical abuse (non-accidental injury to a child including hazing and bullying behaviors), emotional abuse (attacking a child's self-worth including belittling, insulting, or manipulating behavior), sexual harassment, and neglect (failure to protect a child from harm, or provide for basic needs). As we consider the implications of this expanded risk definition and broader perspective, a renewed commitment is needed to address these issues in an increasingly complex environment.
Build New Strategies
Prevention of child maltreatment is not a separate strategy. It should be integrated with your camp's overall plans for risk management. It is just as important as your plans for prevention and reduction of the risks of accidental injury.
The risk of child maltreatment threatens camps from outside, as well as inside, the camp organization. Perpetrators can be parents who abuse and mistreat their children at home before they come to camp. Other perpetrators can be volunteers, counselors, pedophiles, strangers/intruders, as well as other campers.
How does your camp's risk management plan address the risks in the expanded definition of child maltreatment? Have you identified all possible sources of attack? Are you satisfied, or can you do more? If you think you can do more, take some time now to consider the bigger picture.
Successful risk management plans require support and commitment from management. This includes moral support, as well as, financial and administrative backing. As the director, you must "live" the risk management philosophy you espouse and require it from others if it is to succeed.
Screening staff
A 1995 report by the American Bar Association's Center on Children and the Law studied effective screening techniques for employing youth service workers. They discovered the most effective technique was a personal interview. Take some time to think about the qualities and characteristics of the counselor with the "right stuff" for your camp, so you'll know them when you see them. Take some time to review your interview questions in light of some of the additional child maltreatment issues mentioned above.
Besides a comprehensive application, personal interviews, and reference checks, many camps are using background checks. Most insurance companies providing camp liability insurance require a background check of some type. This is a valuable additional screening tool, but is not a panacea to concerns about child maltreatment. Background checks may or may not be available on international staff, which presents another risk factor. Check out the latest information on the type of background checks available in your state.
Staff Training
Effective risk management is teamwork. Take some time to review your current plan in light of the child maltreatment issues raised here and the other risk management issues, that confront you at camp each summer. Evaluate your plan. Enlist your key staff. Get their advice. Then make the necessary changes, so you can be ready for next year.
Originally published in the 2002 September/October issue of Camping Magazine.


text:
Technical information
|Starting point:
|Alp Sellamatt, St. Johann
|Oberdorf, Wildhaus
|Getting to the starting point:
|Train and PostBus up to Alt St. Johann, Chair and Gondola Lift to Sellamatt
|Getting to the destination:
|Aerial cable car to Wildhaus
|Physical fitness:
|Hiking time:
|2.5 - 5h
|June - October
The path leads in three stages from Alp Sellamatt in Alt St. Johann to Oberdorf in Wildhaus. It includes 25 sound installations by the wayside that can be tried and played. Attractive text panels on every instrument contain interesting background information.
One can begin the musical trip at one of the three mountain stations of Selamatt, Iltios or Oberdorf. The hiking time for all stages is about 2.5 hours; with sound-experience and rest period one should allow for 5 hours of time. The stage "Sellamatt" can also be used with children's strollers and wheel chairs
Tour Overview
3D hiking map Download GPX coordinates Download KMZ (GoogleEarth)
The careful planning of a tour will ensure that you also derive the maximum pleasure and enjoyment from it. Please take the time to contact the local information centre and enquire about route and weather conditions before setting off. Your intended trail may be fully or partially closed, depending on the time of year and weather conditions.
SBB RailAway leisure shop
Combined offer: journey using public transport and leisure offer (also for existing tickets) to The Toggenburg Sound Trail


text:
Butter Gloss
All the Butter Gloss shades are named after desserts.
The Curve Felt Tip Eye Liner
The Curve Felt Tip Eye Liner is an excellent long-wearing liquid eyeliner pen.
Add to Faves?
NYX Cosmetics At-A-Glance
Strengths: NYX provides complete ingredient lists on its website; inexpensive for such quality makeup that rivals department store brands (yes, even M.A.C.); superior blush, gloss, and eyeshadow; several excellent mascaras.
Weaknesses: Many products are available only from the company's website, which means you can't see or test the colors in person (and the company doesn't offer samples); disappointing foundation primers.
This small Los Angeles–based makeup line was founded in 1999 by a woman named Toni Ko. The company's Web site is vague about Ko's background, merely stating that she developed an interest in cosmetics as a teenager (you know, just like about 99.9% of teenage women) and wanted to create her own line of cosmetics. Ko's goal was to produce high-quality products at affordable prices, and that's the draw of NYX (pronounced "nicks") Cosmetics. We are pleased to report that, for the most part, Ko succeeded in her childhood dream.
It is important to note that this line offers a full selection of makeup products, from foundations to lip gloss. However, the only place to access everything NYX Cosmetics has to offer is their Web site. The Ulta chain is the largest distributor of NYX Cosmetics products in the United States, but they carry a smaller selection of NYX products. The good news is that most of the few NYX products Ulta stocks are impressive, especially the powder eyeshadows, which compete evenly with eyeshadows that cost a lot more.
NYX Cosmetics customer service number is (866) 699-1004 or you can visit www.nyxcosmetics.com.
Call us Mon–Fri 6am-6pm PT, Sat–Sun 8am-4:30pm PT
Connect with us:
Our Privacy Policy: We will not sell or share any of the information you provide.
Paula's Choice Auto Delivery is a quick and convenient way to make sure you never run out of your favorite products again. Just select the products you can't live without, choose how often you'd like them delivered and we'll take care of the rest.
*Enter code FREEBHA at checkout. Promotion expires 8:59pm PT November 3, 2015. Cannot be applied to previous purchases or combined with other offers. Limit one free trial size 2% BHA Liquid Exfoliant per order, while supplies last. Promotion applies to in-stock products only; no rain checks.
**Promotion expires 8:59pm PT, November 3, 2015. No cash value. Applies to US and Canada only.
***Promotion expires 8:59pm PT, November 3, 2015. Choose any 3 from 28 available FREE individual sample packettes on orders of $5+.
Please sign in and access your saved member information.
Are you new to our site?Create an account and enjoy benefits that offer faster checkout, easy order tracking and quick reorders.
Are you new to our site? Checkout as a guest. You will have the option to create an account later in checkout.


text: Sixth graders at Pinnacle Canyon Academy get a lesson on what makes an effective newspaper ad from Sun Advocate production manager Kelly Wilkinson. Four schools in the county are participating in this year's Design an Ad contest. Wilkinson guided the students through the basics of advertising design, the purpose of advertising, and the crucial importance of meeting "get it done or else" production deadlines. The deadline for student productions is Oct. 25.


text:
tekenaars Artist: Glenn Fabry Various Artists
Artist Glenn Fabry Various Artists
Beschikbare series in de webshop categorie "Stripboeken"
Glenn Fabry in the
"Glenn Fabry began his career working with Pat Mills on 'Slaine' (2000 AD, 1984) and 'Scatha' (newspaper strip, 1987). He contributed painted artwork to magazines like Crisis, Revolver and Deadline. In the 1990s, he became the cover artist of the Garth Ennis series 'Hellblazer' and..." [ Lees meer ]


text:
Tabletop Servers
Find an assortment of tabletop servers for your restaurant at Mission Restaurant Supply. From Mexican molcajetes to lodge cast iron griddles, to wood underliners, gravy boats, and cast aluminum dishes, there is a great variety of tabletop servers right here online to fill your every serving need. Shop at Mission Restaurant Supply and save on tabletop servers along with all your restaurant equipment and supplies.
Buy Tabletop Servers
Libbey Glassware 5160 Oyster Cocktail Dish, 2-1/2 oz., Glass, 12 DozenList Price: $230.40$129.31 / CaseOyster Cocktail Dish, 2-1/2 oz., Glass, 12 Dozen Learn More


text:
October 1, 2014SU Honors Student Participates in National Undergraduate Research Program
April 3, 2014SU Honors Student Selected for The Harrisburg Internship SemesterFebruary 17, 2014SU Honors Students Continue International Service-Learning Project
News Archives
The Honors Program1871 Old Main DriveShippensburg, PA 17257(717) firstname.lastname@example.com
The schedule of Honors courses offered each semester is posted approximately one year in advance. Students are encouraged to plan ahead to avoid enrolling in courses that will be offered as Honors courses in a later semester.
The Honors secretary, Cindy Poe, schedules students into courses before the regular scheduling period begins. To schedule Honors courses, students should contact Ms. Poe at firstname.lastname@example.com on the specific dates posted on the Calendar of Events and let her know which Honors courses they would like to schedule. If any courses are oversubscribed, students will be given priority based on the number of credit hours they have earned.
This page is an official publication of Shippensburg University: A member of the Pennsylvania State System of Higher Education.
Shippensburg University - 1871 Old Main Drive - Shippensburg, PA 17257 - (717) 477-7447
Ask a Question/Provide Feedback | Right-to-Know Policy | Privacy Statement | View on Mobile


text:
|Avery Woman Hurt in Boone Motorcycle Crash
|Written by Steve Frank
|Thursday, 15 August 2013 17:13
An Avery woman was hurt in a Watauga crash yesterday mid afternoon on the NC 105 Bypass. The crash occurred near the Greer Lane intersection at about 1:50 when 22-year old Katy Shontae Davis slammed her 2012 Kawasaki motorcycle into the back of a sedan that was turning
into the new Appalcart facility there. Trooper Hodges said that Davis, of Rodgers Ridge Road in Newland, suffered a leg injury, cuts and scrapes, and was transported to Watauga Medical Center by Medics, his investigation of the crash yielding counts of Failure to Reduce Speed and Driving While License Suspended for Katy Davis.
|Share This Article:


text:
Water resistant and padded puffer jacket with removable hood featuring eye print detail.
Contrast binding and bold zip fastening with Stella McCartney logo disc.
Front pockets, Deer logo printed on the back and elasticated pockets inside.
100% Nylon
Padding: 100% Polyester
Machine wash 30 °, do not tumble dry
The Stella McCartney fit can be quite small so we advise you to choose a size up if you want room to grow.
Baby styles in age 24 months are designed to comfortably fit the rounder body of a baby while those for 2 year olds are created for the leaner body of a toddler .


text:
As the holidays are are about to begin, my thoughts turn to the decorated windows at Bergdorf Goodman in NYC (always a winner for creativity), Christmas caroling with my family and neighbors (yes, we actually did that for several years) and reminiscing about the time my mom and I were "ladies of the court" in the Thanksgiving Day Parade in NYC dancing along a float carrying Olympic skaters, Brian Botano and Katarina Witt. And, of course, filling my belly with plenty of pie!
Holidays On Ice by David Sedaris, $8 Amazon
David is one of my favorites and every year around the holidays I'm pulled back into re-reading this book of short stories. You could read it in an hour. If you haven't read this book or any of Sedaris' book, guaranteed you'll become a fan. If you're not a fan, then we obviously don't share the same sense of humor. David Sedaris's beloved holiday collection is new again with six more pieces, including a never before published story. Along with such favorites as the diaries of a Macy's elf and the annals of two very competitive families, are Sedaris's tales of tardy trick-or-treaters ("Us and Them"); the difficulties of explaining the Easter Bunny to the French ("Jesus Shaves"); what to do when you've been locked out in a snowstorm ("Let It Snow"); the puzzling Christmas traditions of other nations ("Six to Eight Black Men"); what Halloween at the medical examiner's looks like ("The Monster Mash"); and a barnyard secret Santa scheme gone awry ("Cow and Turkey").
Lauren Scharf's Pick
Day Trip Darling Dress, $252 ModCloth
An adorable dress with a storybook ending! This dress, designed by Poppy London, is lined with the illustrated adventures of little girl Poppy and her playful pup Fred. The dress can be worn with the neckline shown for a vintage look, or flipped around for a v-neckline. Even cooler, each dress is shipped with a paperback book which tells the tale that's played out on the dress. What could be better than a dress that literally comes with it's own story!
Christina Moffiitno's Pick
OPI 3 Piece Nail Polish set, $18 Amazon
I have a slight addiction with collecting nail polish and doing my own manicures. As soon as I saw these new OPI colors, I had to have them. The oxblood red is definitely what sold me. It comes as a set so you get to mix and match these great colors. The colors are so rich and perfect to wear at your next holiday party. I love that it comes as a box set so you can gift it for your Secret Santa or use them as a great stocking stuffer.
Christina Wright's Pick
Rockstar Pop-Color Cords, $35 Old Navy
These red corduroy skinnies from Old Navy are just what I need to make our family holiday photos "pop" this year. Plus you can't beat the price!! Typically, I am not a fan of corduroy (bad 80s flashbacks), but with the low rise and slim cut of these make corduroy cute again!


text:
The OpenACC Toolkit from NVIDIA offers scientists and researchers a simple way to accelerated scientific computing without significant programming effort. Simply insert hints (or "directives") in C or Fortran code and the OpenACC compiler runs the code on the GPU.
- Simple: Insert compiler hints to instantly tap into thousands of computational cores in the GPU
- Powerful: Delivers up to 10x faster application performance
- Free: The OpenACC Toolkit with compiler included is available at no charge for academia*
Application Acceleration with OpenACC on GPUs
LS-DALTON: Benchmark on Oak Ridge Titan Supercomputer, AMD CPU vs Tesla K20X GPU. Test input: Alanine-3 on CCSD(T) module.
Additional information: COSMO .
NICAM: Benchmark on TiTech TSUBAME 2.5, Westmere CPU vs. K20X, additional information here
"OpenACC makes GPU computing approachable for domain scientists. Initial OpenACC implementation required only minor effort, and more importantly,no modifications of our existing CPU implementation"Janus Juul Eriksen, PhD Fellow, qLEAP Center for Theoretical Chemistry, Aarhus University
OpenACC Toolkit Features
The toolkit includes a complete set of developer tools designed to provide significant application acceleration with a minimum amount of coding. It features the popular PGI Accelerator Fortran/C Workstation Compiler Suite for Linux, which supports OpenACC 2.0. The compiler is available at no cost for academia. Non-academic developers will receive a free 90-day trial.
Other tools include:
- GPU Wizard to identify if GPU-accelerated libraries can accelerate portions of code without any additional programming
- NVProf Profiler to easily find where to add OpenACC directives to further increase performance
- OpenACC Code Samples to get started with simple and real-world examples
- Documentation including OpenACC Best Practices Guide for maximizing application performance
Every registered toolkit user also receives two free 90-minute, on-demand training sessions to quickly learn and master OpenACC techniques.
* A Free University Developer license is a special single-user node-locked license to the 64-bit Linux version of PGI Accelerator Fortran/C/C++ Workstation™
How OpenACC Works
With OpenACC, programmer keeps the existing code intact and delivers faster performance when an accelerator is available in the system. The example below shows how OpenACC extends existing serial CPU code or parallel code using approaches like OpenMP.
Performance Portability
OpenACC is designed to deliver powerful performance that is portable across many types of platforms such as GPUs and multi-core CPUs. Performance portability allows researchers to optimize their code just once and expect accelerated results on different processors and platforms.
An upcoming version of the PGI OpenACC compiler can now accelerate code on x86 multi-core CPUs as well as on GPUs. When a GPU is not present the compiler parallelizes for CPU cores resulting in many times faster performance over single CPU core.
This CPU portability feature is in private beta today and is planned for wider availability in the fourth quarter of 2015.
Learn OpenACC
- Webinar: Introduction to OpenACC Programming (56:21)
- DevZone Blog: Your First OpenACC Program
- GTC 2015 Presentation: Advanced OpenACC Programming (1:05:53)
- OpenACC.org: Educational Portal
- NVIDIA CUDA ZONE: Free Live Online OpenACC Course Series - Starts October 1, 2015


text:
in this issue
premium services
online directory
customer care
Regions :: Western Europe
Galp Energia opens Portugal's first food waste biorefinery
July 16, 2013 | Francinia Protti-Alvarez
Galp Energia (Lisbon) has inaugurated Enerfuel, Portugal's first biorefinery operating on food waste and used cooking oil. The plant is located at the Sines Industrial and Logistics Zone (Sines, Portugal). It has a capacity of 27,000 m.t./year of biodiesel and is also able to produce glycerine. The total investment amounts to €8.5 million ($11.1 million). All the raw materials will be sourced domestically, and Galp expects to start commercial sales in Europe next year. The European biofuel landscape is changing. A draft EU proposal aims to cap...
This information is only available to Chemical Week subscribers.
Forgot your user ID or password?
Not an IHS Chemical Week member yet?
Here's why you should be:
100% Satisfaction Guarantee
contact us | about us | customer care | privacy policy | sitemap | advertise
Copyright © 2015 IHS, Inc. All rights reserved. Reproduction in whole or in part without permission is prohibited.


text:
#403 of 617
greeting cards, golden retriever greeting cards, dog greeting cards, portrait greeting cards, pet greeting cards, pets greeting cards, original painting greeting cards, realism greeting cards, l.a.shepard greeting cards, puppy greeting cards
"Golden Retriever winter walk" greeting card by Lee Ann Shepard. Ships within 2 - 3 business days and includes a plain white envelop for mailing and/or gift giving. Available in vertical and horizontal orientations.
I have always found pleasure in drawing and painting since I was a very young child. I trained at art school in Cleveland, and thought I would someday work as a commercial artist. But as often happens, my life evolved quite differently than expected and my art became more of a hobby over the years. I married, moved up North to snow country and spent my time working along side of my wonderful husband in our small furniture design business in a little Ontario cottage town north of Toronto, raising our 3 kids and enjoying a simple, happy lifestyle. Life was idyllic. In the summer of 2006 our world was turned upside down when my husband went to the Emergency room with a blinding headache. He was diagnosed with a deadly brain tumour .I could...
Our return policy is very simple:
If you're not happy with a purchase that you made on FineArtAmerica.com, for any reason, you can return it to us within 30 days of the order date. As soon as it arrives, we'll issue a full refund for the entire purchase price. Please note - Fine Art America does not reimburse the outgoing or return shipping charges unless the return is due to a defect in quality.
Fine Art America sells thousands of pieces of artwork each month - all with a 100% money-back guarantee.
If you've hesitated to purchase artwork online in the past, why not give us a try? You have nothing to lose!
We take great pride in the fact that hundreds of thousands of artists have chosen Fine Art America to fulfill their orders, and we look forward to helping you select your next piece!
Customer Service: 877-807-5901
(Call Any Time - 24 Hours Per Day)
All greeting cards ship from our production facility within two business days of your order.
Please Wait...
Beverly Hills, CA (United States)
Sign up for our newsletter for exclusive deals, discount codes, and more:
Unsubscribe at any time.
Server Status OK
Copyright © 2015 FineArtAmerica.com - All Rights Reserved


text:
These earring jackets sparkle with hand-matched, princess-cut sapphires that are designed especially to be worn with any size of solitaire earrings. Two princess cut sapphires, at approximately .36 carat total weight, are set in quality 14 karat white gold. The diamond solitaire earrings pictured are not included.Item Number: 41051757
Order now for delivery on or before
Friday, October 09, 2015
using FedEx 2nd Day.


text:
Please enter the email address associated with your account and we will send you a link to reset your password.
Your password reset link is on its way. If you have problems accessing your account, please contact us at 888-757-4774 and we'll help you out.
I'm sorry, your email address was not found in our system.
If you think this is a mistake, please contact Customer Service at 888-757-4774 or email us.
WarmWire floor heat cable is an economical way to utilize a radiant heat flooring system as a means of warming floors and providing years of lasting comfort. This floor warming system offers underfloor heat that helps keep bathrooms, kitchens, and entry ways dry and safe. Make your home cozy with SunTouch heated floor system.
Sort By:
View By:
Location: 185 Price Parkway, Farmingdale, NY 11735
Hours: 8:00AM - 7:00PM, Mon - Fri.
Do not use this item for any installation or repair of potable water applications.
This product does not comply with the "Safe Drinking Water Act,"
which requires that products meet low-lead standards in order to be used in systems providing water for human consumption (drinking or cooking).
This item is for non-potable (non-human consumption) water applications only.
This product does not comply with the "Safe Drinking Water Act,"
which requires that products used in any system providing water for human
consumption (drinking or cooking) to meet low-lead standards.
Please check the box below to confirm you are aware of that this item is for non-potable water applications only.
This product will NOT be used in the installation or repair of a potable water (human consumption) application.
You must agree to this statement in order to purchase this product.
There is a Minimum Advertised Price (MAP) allowed by the manufacturer on this product. Add item to cart for lowest price.
$175.00 / each
$245.00 / each
$16.00 / each
$21.00 / each
$140.00 / each
$105.00 / each
$139.00 / each
$171.00 / each
$198.00 / each
$215.00 / each
$248.00 / each
$270.00 / each
$286.00 / each
$308.00 / each
$347.00 / each
$379.00 / each
$401.00 / each
$440.00 / each
At SupplyHouse.com, our goal is to bring you the highest quality plumbing, heating and HVAC supplies at competitive prices. Our product catalog includes PEX Plumbing Supplies, Radiant Heat Supplies, VisionPro Honeywell Thermostats, Taco pumps and mini-split air conditioners. If there are items you are looking for but can't find on our website, please contact our Customer Service Representatives & we will do our best to find what you need.
© 2015 SupplyHouse.com


text:
- Northern New York Newspapers
- Watertown
- Ogdensburg
- Massena-Potsdam
- Lowville
- Carthage
- Malone
- NNY Business
- NNY Living
- NNY Ads
Dairy farmers in the north country power up equipment every day to finish chores, but they rely on the brainpower of researchers to tell them the latest strategies for making their operations profitable.
Thats why about a dozen farmers took time Tuesday at the Ramada Inn, 21000 Route 3, to listen to researchers from Cornell University, Ithaca, report findings from multiyear research projects funded by the Northern New York Agricultural Development Program.
Highlighted were studies on how predatory worms called nematodes are being used to combat the invasion of the alfalfa snout beetle, the latest strategies for planting winter cover crops and a free online tool that helps farmers cut spring fertilizer costs.
Many farmers are applying the microscopic roundworms called nematodes to their alfalfa crops to battle the alfalfa snout beetle, said Cornell entomology professor Elson J. Shields, who has conducted research on the beetle since the late 1980s. Results have been especially promising in an ongoing study since 2007 on the effectiveness of the method. Research has been conducted in 161 fields on 51 farms in six counties, mainly Jefferson, Lewis and St. Lawrence.
Equipment for treating fields with nematodes is simple and inexpensive. Once the nematodes are mixed with water in a large bucket or garbage can, they are applied to fields in rows with a golf cart or ATV equipped with a spray rig, such as a PVC pipe with holes, that allows gravity to distribute the water. Farmers can breed their own nematodes by purchasing cups of wax worms to inoculate. A $150 purchase of wax worms to breed nematodes will allow treatment of an estimated 5 acres.
Mr. Shields said nematodes usually need to be applied only once. Once the microorganisms are in the soil, they may be spread farther throughout fields by plows and harvesting equipment.
The study suggested that if the presence of the snout beetle is left untreated, alfalfa losses can climb up to $381 per acre after four years. In contrast, the cost to apply nematodes is roughly $30 an acre.
Once you treat an infected area, you can restore the alfalfa when the beetles die out, Mr. Shields said. And two years worth of plowing can spread (nematodes) to an entire field.
Farmers have a good reason to be Internet-savvy an online tool that helps them save money on nitrogen fertilizer was highlighted by Cornell researcher Bianca Moebius-Clune, who has worked on the project for the past decade.
The free service, Adapt-N, helps farmers accurately predict how much fertilizer they need by using a computer model that factors in current farm and weather patterns. The tool is available at http://adapt-n.cals.cornell.edu.
Farmers normally use the same amount of nitrogen fertilizer every year. Doing so is problematic, however, because rainy weather during the spring calls for more fertilizer than usual, while dry conditions call for less. Thats where the online tool becomes useful: Based on 60 trials on farms in Iowa and New York since 2011, farmers saved anywhere from 25 to 60 pounds of fertilizer by using the tool, Ms. Moebius-Clune said. Eighty percent of farmers who participated in the study saved on fertilizer costs an average of $24 an acre.
For example, dairy farmer Robert Donald of Moravia in Cayuga County saved about $70,000 in fertilizer costs by using the online tool. He used 210 pounds of fertilizer to treat 1,000 acres of corn in 2010, which he dropped to 80 pounds in 2011 based on calculations from the program.
This is a very precise tool that farmers have never had before, Ms. Moebius-Clune said.
Thousands of readers like you have made Northern New York Newspapers the number one ranked website* for local news and sports coverage in the north country.
You can continue on to this article in a few seconds, or you can visit one of our websites:


text:
Whirlwind Dress
Style: 25241548
A sophisticated silhouette for an unconventional bride. Silk-cotton twinkles with intricate floral beading while an open back and a knee-length hemline add just the right amount of daring and dash. A Hitherto original, available exclusively from BHLDN. Side zip closure; removable grosgrain belt fastens with a hook-and-eye. Dry clean. Imported.
- This silhouette is fitted through the bodice. For best fit, size to the curvier of your bust and waist measurements.
- Can be shortened; using an experienced bridal tailor is recommended
- Interior bust cups
- Cotton and silk shell; beaded embellishments
- Polyester stretch lining
- Shown with the Whirlwind Jacket
- All gowns require an additional shipping charge of $15
- Gowns cannot be shipped to PO boxes
- See fit guide for detailed sizing information
Contact a BHLDN Stylist for style advice, reassurance, second opinions


text:
- Northern New York Newspapers
- Watertown
- Ogdensburg
- Massena-Potsdam
- Lowville
- Carthage
- Malone
- NNY Business
- NNY Living
- NNY Ads
The final tally of votes for St. Lawrence County district attorney shows Republican Mary E. Rain defeating Democrat M. Nicole Duve 10,379 to 9,669.
Not every St. Lawrence County voter chose between those two district attorney candidates, however.
For example, 521 voters left the line blank. That represents 2.5 percent of those who went to the polls.
And a number of people chose to write in their own favorite for the office. Of those write-ins, Peter Dumas took top honors with three votes. Tied with two were Scatter (sorry thats all we know) and Tessa Fields.
Also receiving single write-ins were Patrick J. Green, Clarence Darrow, Lloyd Grandy, Mike Golliver, Gary Miles, Alison Appleby and Charlie Gardner.
There were no votes for Hamilton Burger, Dan Fielding or Paul Garrett.
Thousands of readers like you have made Northern New York Newspapers the number one ranked website* for local news and sports coverage in the north country.
You can continue on to this article in a few seconds, or you can visit one of our websites:


text:
- Red Bull USA - Sports & Entertainment News | Teams & Athletes
- Sports
- Participant Events
- Red Bull Flugtag
- Photos
- Red Bull Flugtag: Philadelphia Gallery
- The podium at Red Bull Flugtag Philadelphia
Image Details
- Views
- Date
- Sep 4, 2010
- Photographer
- Christian Pondella
- Participants
- Events
- Red Bull Flugtag 2010 - Philadelphia
- Copyright
- Christian Pondella/Red Bull Photofiles
- About this Image
- Nearly 85,000 Red Bull Flugtag fans packed the Camden Waterfront in Philly on Labor Day weekend to watch human powered flying machines plunge into the Delaware River. Flying clocks, crash test dummies and a dodo bird were among the 32 crafts that took flight off the 26-foot flight deck. The winner, team Giant Flying Llama, took first place with their baseball-inspired hat and uniforms that ignited the Philly crowd and recorded a flight of 42 feet. Second was a Philly favorite, the Liberty Bell-inspired team Let Freedom Wing. Team BUMBLE, whose Christmas theme was slightly out of season, finished third. Bringing the People's Choice Award back to the Garden State, the crowd went cuckoo for Five Guys One Clock.
Related Content
Nov 10, 2012
Red Bull Flugtag San Francisco
Every single rule in the aviation handbook will be broken when Red Bull Flugtag lands in San...Go To Event
Sep 15, 2012
Red Bull Flugtag Philadelphia 2012
Red Bull Flugtag challenges teams of everyday people to build homemade, human-powered flying...Go To Event
Sep 6, 2012
Red Bull Flugtag Philly: Team Breakdown Sep 6, 2012
The Philadelphia area will soon be deluged with creative flying crafts, silly skits and good times as Red Bull Flugtag makes its return to the city on September 15. Take a look at some of the mayhem...
Sep 20, 2010
Red Bull Flugtag Philadelphia
Sep 8, 2010
Flying in Philadelphia: Red Bull Flugtag Sep 8, 2010
Red Bull Flugtag landed in Philadelphia for the first time in 2010; check out how high the people of Philly can fly...
Sep 6, 2010
Red Bull Flugtag Flies Through Philadelphia Sep 6, 2010
Nearly 85,000 Red Bull Flugtag fans packed the Camden Waterfront in Philly to watch human powered flying machines plunge down the Delaware River.


text:
Archives For: March 2012
Prof. Marc Pilisuk to participate in OccuPsy dialogue03/28/2012
On March 28th, Saybrook's Dr. Pilisuk will participate in the invitation-only event OccuPsy: Mobilizing Critical Psychoanalysis for the Movement. This gathering brings together people who think psychologically, psychoanalytically, and critically to brainstorm and dialogue about what might be helpful in strengthening the movement, especially with regard to helping it grow and become more effective.
Saybrook student Geoffrey Thompson publishes chapter in "Mental Illnesses - Evaluation, Treatments and Implications"03/21/2012
The Vitality of Fragmentation: Desublimation and the Symbolic Order
By Geoffrey Thompson
This chapter will focus on theoretical, clinical and personal challenges surrounding my work as an art therapist in an adult outpatient service of a psychiatric hospital. The evolution of my thinking pervades my clinical work with the client discussed in the vignette, as I sought to integrate desublimation from art theory and philosophy with psychoanalytic theory. (Thompson, 2007).
Stanley Krippner to receive the APA's award for distinguished lifetime contributions to humanistic psychology03/13/2012
Saybrook University is thrilled to announced that PHS faculty member Stanley Krippner has been selected to receive the American Psychological Association's Award for Distinguished Lifetime Contributions to Humanistic Psychology.
By BETTY REARDON, Founder Emeritus, International Institute on Peace Education
For those who have been striving for the realization of the human rights of women, the first week of March - the 8th day of which is International Women's Day - is a time of in-gathering of the international women's movements with the convening of the annual session of the United Nations Commission on the Status of Women (CSW). This year, the 56th CSW session brings women (and a few but increasing number of men) from all over the world, some of them representing the member states that sit on the Commission, charged with advancing UN policy statements adopted over the past half century to "reaffirm…the equal rights of men and women…." in such documents as the Convention on the Elimination of all forms of Discrimination against Women, the Beijing Platform for Action, and Security Council Resolution 1325 on Women Peace and Security.
From Dictatorship to Democracy 2.003/05/2012
Well before the Arab Spring and the current direct democracy movement, Clay Shirky not only argued that social media represented the "greatest increase in human expressive capability in history," but that it would radically empower individuals at the expense of their own governments. In response, a more skeptical Evgeny Morozov cautioned that there was a flip side to this 'good news' story – i.e., both the internet and social media can just as readily enhance the legitimacy of authoritarian regimes (and stifle political change) than not. Well, given the dual nature that social media has, and given our incorrigible optimism here at the International Relations and Security Network, today we would like to burnish further the pro-empowerment case. In particular, we would like to look at Gene Sharp's legendary handbook of non-violent resistance,From Dictatorship to Democracy: A Conceptual Framework for Liberation, but from a social media perspective.
US Institute of Peace engages teachers and students with new resources03/01/2012
As part of its mission to educate key audiences about peacebuilding and conflict management, the United States Institute of Peace (USIP) in February activated a virtual Global Peacebuilding Center, providing younger audiences and educators with substantial peacebuilding resources and activities.
The website––www.buildingpeace.org––is the digital arm of USIP's onsite Global Peacebuilding Center, a public education space which extends USIP's educational work to new audiences through multimedia exhibits and educational programs.
The new website features educational materials, a Virtual Passport experience, and many ways for young people to learn about the work of USIP and the importance of peacebuilding.


text:
This section describes differences in the InnoDB storage engine's handling of foreign keys as compared with that of the MySQL Server.
Foreign key definitions for
InnoDB tables are
subject to the following conditions:
InnoDB permits a foreign key to reference
any index column or group of columns. However, in the
referenced table, there must be an index where the referenced
columns are listed as the first columns
in the same order.
InnoDB does not currently support
foreign keys for tables with user-defined partitioning. This
means that no user-partitioned
InnoDB table
may contain foreign key references or columns referenced by
foreign keys.
InnoDB allows a foreign key constraint to
reference a non-unique key. This is an
InnoDB extension to standard
Referential actions for foreign keys of
tables are subject to the following conditions:
SET DEFAULT is allowed by the MySQL
Server, it is rejected as invalid by
TABLE and
statements using this clause are not allowed for InnoDB
If there are several rows in the parent table that have the
same referenced key value,
InnoDB acts in
foreign key checks as if the other parent rows with the same
key value do not exist. For example, if you have defined a
RESTRICT type constraint, and there is a
child row with several parent rows,
does not permit the deletion of any of those parent rows.
InnoDB performs cascading operations
through a depth-first algorithm, based on records in the
indexes corresponding to the foreign key constraints.
ON UPDATE CASCADE or
SET NULL recurses to update the same
table it has previously updated during the cascade,
it acts like
RESTRICT. This means that you
cannot use self-referential
CASCADE or
operations. This is to prevent infinite loops resulting from
cascaded updates. A self-referential
NULL, on the other hand, is possible, as is a
Cascading operations may not be nested more than 15 levels
Like MySQL in general, in an SQL statement that inserts,
deletes, or updates many rows,
UNIQUE and
KEY constraints row-by-row. When performing foreign
key checks,
InnoDB sets shared row-level
locks on child or parent records it has to look at.
InnoDB checks foreign key constraints
immediately; the check is not deferred to transaction commit.
According to the SQL standard, the default behavior should be
deferred checking. That is, constraints are only checked after
the entire SQL statement has been
processed. Until
InnoDB implements deferred
constraint checking, some things will be impossible, such as
deleting a record that refers to itself using a foreign key.
You can obtain general information about foreign keys and their
usage from querying the
table. See also Section 22.214.171.124, "Using FOREIGN KEY Constraints".
In addition to
SHOW ERRORS, in the
event of a foreign key error involving
tables (usually Error 150 in the MySQL Server), you can obtain a
detailed explanation of the most recent
foreign key error by checking the output of
|Posted by Dennis Haney on July 15 2003 10:26am
|[Delete] [Edit]
For those encountering the problem " ERROR 1216: Cannot add or update a child row: a foreign key constraint fails", it actually means what it says! Some row in the child does not comply with the constraint, correct the problem.
You find the rows like this:
select child.id from child left join parent on (child.parent_id=parent.id) where child.id is not null and parent.id is null;
|Posted by Kai Baku on October 10 2003 11:09pm
|[Delete] [Edit]
There may be rare cases where circular dependencies would make sense. In the case of employees and store, you may have a circular dependency; in which all employees must be stationed at a store, so the employees table will have storeID and EmployeeID attached as a concatonated primary key (Presuming that an Employee can only have one store stationed) or even just a simple non-dependent foriegn key. Then each store must have a top general manager in charge which is stationed there, so the store will have an EmployeeID Foreign Key to the store table to represent that the store has that employee as the manager.
In this case, you have StoreID as an attribute of Employee, and EmployeeID (the Manager) as an attribute of Store.
While this works, it may not be the best method. There are likely better ways to handle such cases, but if your business rules requires such circular dependencies, then it happens.
Also, it is interesting to note that while this query works (Note the PRIMARY KEY line):
CREATE TABLE `ffxi_characterJob` (
`serverID` int(11) NOT NULL,
`userid` int(10)unsigned NOT NULL,
`characterName` varchar(255) NOT NULL,
`jobAbbr` char(4) NOT NULL,
`jobLevel` int(11) default '0',
PRIMARY KEY (`serverID`,`userid`,`characterName`,`jobAbbr`),
INDEX (`jobAbbr`),
CONSTRAINT FOREIGN KEY (`serverID`,`userid`,`characterName`) REFERENCES `ffxi_characters` (`serverID`,`userid`,`characterName`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT FOREIGN KEY (`jobAbbr`) REFERENCES `ffxi_jobType` (`jobAbbr`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;
This query will give you an error 1005 and errno 150:
CREATE TABLE `ffxi_characterJob` (
`serverID` int(11) NOT NULL,
`userid` int(10)unsigned NOT NULL,
`characterName` varchar(255) NOT NULL,
`jobAbbr` char(4) NOT NULL,
`jobLevel` int(11) default '0',
PRIMARY KEY (`jobAbbr`,`serverID`,`userid`,`characterName`),
INDEX (`jobAbbr`),
CONSTRAINT FOREIGN KEY (`serverID`,`userid`,`characterName`) REFERENCES `ffxi_characters` (`serverID`,`userid`,`characterName`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT FOREIGN KEY (`jobAbbr`) REFERENCES `ffxi_jobType` (`jobAbbr`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;
In order to make the second one work, you have to add:
INDEX (`serverID`,`userid`,`characterName`)
before the the foreign key is made.
|Posted by Turadg Aleahmad on January 7 2004 12:55pm
|[Delete] [Edit]
In a previous comment Dennis Haney provided an SQL snippet for finding rows that violate intended foreign key constraints. I had a lot of data to check so I write a little shell script to save me time:
# find-fk-conflicts.sh
# (c) 2004 Turadg Aleahmad, licensed under GPL
# USAGE: find-fk-conflict.sh child_table child_key parent_table parent_key
# NOTE: set this
db="TARGET DATABASE"
query="SELECT $child_table.$child_key FROM $child_table LEFT JOIN $parent_table
ON ( $child_table.$child_key = $parent_table.$parent_key)
WHERE $child_table.$child_key IS NOT NULL AND $parent_table.$parent_key IS NULL;
mysql --verbose -u root -e "$query" $db
|Posted by Andrew Penry on July 7 2004 2:35pm
|[Delete] [Edit]
If you have a join on part of a primary key, foriegn key constraints may behave in an unexpected way.
CREATE TABLE doc (
docID INTEGER NOT NULL AUTO_INCREMENT,
langCode CHAR(2) NOT NULL,
title VARCHAR(32),
PRIMARY KEY (docID, langCode)
) Type=InnoDB;
CREATE TABLE author (
authorID INTEGER NOT NULL AUTO_INCREMENT,
docID CHAR(2) NOT NULL,
name VARCHAR(32),
PRIMARY KEY (authorID),
FOREIGN KEY (docID) REFERENCES doc(docID) ON DELETE CASCADE ON UPDATE CASCADE
) Type=InnoDB;
In this case you have documents in several languages. The primary key of the document is the docID and the langCode for that translation. The author of the document is only dependant on the docID, not the language of a particular translation. Therefore the FOREIGN KEY is only on docID.
Although this makes sense, the restraint acts a little funny. Say you have the following data:
doc table
docID langCode title
1 hu A Szamitogep
1 en The Computer
author table
authorID docID name
7 1 Kaposzta Csaba
Deleteing any version of the document will delete the entry in the author table. For example:
DELETE FROM doc WHERE docid=1 AND langCode=en;
now the tables look like:
doc table
docID langCode title
1 hu A Szamitogep
author table
authorID docID name
As you can see, deleting just the translation has deleted the author.
I am unsure about whether this is correct behavior. I've tried this using MS Access to compare, and it won't let me buid relationships on partial primary keys. My feeling is that InnoDB should probably not allow me either, because docID is clearly not a unique index.
|Posted by Frank Vanderhallen on August 4 2004 8:10am
|[Delete] [Edit]
I've too much tables to execute the foreign key dependency checking script by hand. This little script does it all:
# check_constraints.sh
# --------------------
# Check foreign key contraints on MySQL database.
# Written by Frank Vanderhallen, licensed under GPL.
if [ -z "$1" ]
echo "\nUsage:\n\t./`uname $0` <database> [-h <host>] [-u user] [-p <passwd>]\n"
CONSTRAINTS=`mysqldump $* | grep "CREATE\|CONSTRAINT" | sed 's/ /+/g'`
for c in $CONSTRAINTS
if [ "`echo $c | cut -d '+' -f 3`" = "CONSTRAINT" ]
CONSTRAINT=`echo $c | cut -d '+' -f 4 | tr -d '\`'`
CHILD_KEY=`echo $c | cut -d '+' -f 7 | tr -d '()\`,'`
PARENT_TABLE=`echo $c | cut -d '+' -f 9 | tr -d '\`'`
PARENT_KEY=`echo $c | cut -d '+' -f 10 | tr -d '()\`,'`
QUERY="select c.$CHILD_KEY from $CHILD_TABLE as c left join $PARENT_TABLE as p on p.$PARENT_KEY=c.$CHILD_KEY where c.$CHILD_KEY is not null and p.$PARENT_KEY is null;"
echo "Checking table '$CHILD_TABLE' constraint '$CONSTRAINT'"
mysql -verbose $* -e "$QUERY"
CHILD_TABLE=`echo $c | cut -d '+' -f 3`
|Posted by Fabio Venuti on September 20 2004 1:32pm
|[Delete] [Edit]
The fact that "NO ACTION" and "RESTRICT" should be treated equally means that there is no way to delete a parent row without deleting the child row unless you disable the foreign key check. This is normally what we want, but there might be exceptions where it makes sense to keep an orphan row, e.g., when you have a "history" table that maintains some information about records that can be safely deleted.
|Posted by matt emmons on September 4 2006 7:56pm
|[Delete] [Edit]
In 4.1.18 this;
CREATE TABLE foo (
a int(11) NOT NULL default '0',
b int(11) NOT NULL default '0',
PRIMARY KEY (a,b),
KEY b (b),
CONSTRAINT FOREIGN KEY (a) REFERENCES other_table1.a,
CONSTRAINT FOREIGN KEY (b) REFERENCES other_table2.b
) ENGINE=InnoDB;
provokes errno 150 / 1005. Show InnoDB status' latest foreign key error reports, "cannot resolve table name close to...."
All tables (foo, other_table1 & other_table2) are InnoDB. other_table1.a and other_table2.b are single attribute primary keys (thus satisfying the "first column" index requirement).
This, on the other hand, works fine:
CREATE TABLE foo (
a int(11) NOT NULL default '0',
b int(11) NOT NULL default '0',
PRIMARY KEY (a,b),
KEY b (b),
CONSTRAINT FOREIGN KEY (a) REFERENCES other_table1(a),
CONSTRAINT FOREIGN KEY (b) REFERENCES other_table2(b)
) ENGINE=InnoDB;
The only difference is how the referenced field is specified - table.field v. table(field).
I wonder if the indexes, in either the referring or referenced tables, being named the same as their respective fields isn't a problem.
|Posted by jim kraai on January 4 2007 8:16pm
|[Delete] [Edit]
Dynamic Stored Procedure to identify conflicts prior to adding a FOREIGN KEY constraint
Here's a stored proc inspired by by Turadg Aleahmad's shell script named find-fk-conflicts.sh seen in the refman/5.0 page comments:
DROP PROCEDURE IF EXISTS sp_find_fk_conflict |
CREATE PROCEDURE sp_find_fk_conflict(
IN dbname CHAR(64), -- database name
IN ctn CHAR(64), -- child table name
IN ckn CHAR(64), -- child key name
IN ptn CHAR(64), -- parent table name
IN pkn CHAR(64) -- parent table name
Created: 20060913
By jim kraai (jim NO at SPAM kraai.org)
Inspired by Turadg Aleahmad's find-fk-conflicts shell script
child table name
child key name
parent table name
parent key name
rows that would conflict if adding a foreign key constrant
USAGE: call sp_find_fk_conflict('some_db','some_childTable','some_childTable_key','some_parentTable','some_parentTable_key');
DECLARE s TEXT;
SET @s = CONCAT(
'SELECT ', dbname,'.',ctn,'.',ckn,' ',
'FROM ', dbname,'.',ctn,' ',
'LEFT JOIN ', dbname,'.',ptn,
'( ', dbname,'.',ctn,'.',ckn,
' = ',
') ',
dbname,'.',ctn,'.',ckn,' IS NOT NULL ',
dbname,'.',ptn,'.',pkn,' IS NULL;'
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
(Ignore the PHP <? ?> around the SP, it's there to preserve formatting)
|Posted by Dennis Nikolaenko on June 5 2007 12:29pm
|[Delete] [Edit]
Note that as of version 5.0.38, InnoDB allows two or more foreign keys on the column, they may reference diffrent tables/columns. It even allows foreign keys with the same definition, but different constraint name.
|Posted by Lupus Arctos on July 19 2007 8:34pm
|[Delete] [Edit]
Modified foreign key dependency checker script posted by Frank Vanderhallen.
This script supports composite keys.
# check_constraints.sh
# --------------------
# Check foreign key contraints on MySQL database.
# Written by Frank Vanderhallen and modified by Lupus Arctos, licensed under GPL.
if [ -z "$1" ]
echo "\nUsage:\n\t./`uname $0` <database> [-h <host>] [-u user] [-p <passwd>]\n"
CONSTRAINTS=`mysqldump $* | grep "CREATE\|CONSTRAINT" | sed 's/, /,/g' | sed 's/ /+/g'`
for c in $CONSTRAINTS
if [ "`echo $c | cut -d '+' -f 3`" = "CONSTRAINT" ]
CONSTRAINT=`echo $c | cut -d '+' -f 4 | tr -d '\`'`
CHILD_KEY=`echo $c | cut -d '+' -f 7 | tr -d '()\`'`
PARENT_TABLE=`echo $c | cut -d '+' -f 9 | tr -d '\`'`
PARENT_KEY=`echo $c | cut -d '+' -f 10 | tr -d '()\`'`
declare -a PARENT_KEYS=($(echo $PARENT_KEY|sed 's/,/ /g'))
declare -a CHILD_KEYS=($(echo $CHILD_KEY|sed 's/,/ /g'))
let PARENT_KEYS_LASTIDX=${#PARENT_KEYS[@]}-1
let CHILD_KEYS_LASTIDX=${#CHILD_KEYS[@]}-1
for k in `seq 0 $PARENT_KEYS_LASTIDX`; do
JOINON=`echo $JOINON p.${PARENT_KEYS[k]}=c.${CHILD_KEYS[k]}`
CHILD_TABLE_KEY=`echo $CHILD_TABLE_KEY c.${CHILD_KEYS[k]}`
if [ $k != $PARENT_KEYS_LASTIDX ]; then
JOINON=`echo $JOINON and`
CHILD_TABLE_KEY=`echo $CHILD_TABLE_KEY,`
if [ $k == 0 ]; then
CHILD_WHEN=`echo p.${PARENT_KEYS[k]} is not null`
PARENT_WHEN=`echo c.${CHILD_KEYS[k]} is null`
QUERY="select $CHILD_TABLE_KEY from $CHILD_TABLE as c left join $PARENT_TABLE as p on $JOINON where $CHILD_WHEN and $PARENT_WHEN;"
echo "Checking table '$CHILD_TABLE' constraint '$CONSTRAINT'"
#mysql -v $* -e "$QUERY"
mysql $* -e "$QUERY"
CHILD_TABLE=`echo $c | cut -d '+' -f 3`
|Posted by Alex Baeza on March 24 2008 7:15pm
|[Delete] [Edit]
It is often difficult to determine which tables have children.
One nice new feature of MySQL 5.02 and above is the information_schema. You can use the information_schema to determine dependencies using a query such as:
ke.referenced_table_name parent,
ke.table_name child,
information_schema.KEY_COLUMN_USAGE ke
ke.referenced_table_name IS NOT NULL
This will show all the parent tables that have children in your current database. This example can also be modified to show all parent child relationships across multiple databases.
|Posted by Altemir Soares on November 28 2008 1:06am
|[Delete] [Edit]
This way you can do foreign key checks just from any sql client tool.
SET @child_table='EMPLOYEES';
SET @child_key='DEPARTMENT_ID';
SET @parent_table='DEPARTMENTS';
SET @parent_key='DEPARTMENT_ID';
select CONCAT('SELECT ',@child_table ,'.',@child_key,' FROM ',@child_table,' LEFT JOIN ', @parent_table,
CONCAT('\n ON (',@child_table,'.',@child_key,' = ',@parent_table,'.',@parent_key,')'),
CONCAT('\n ','WHERE ',@child_table,'.',@child_key,' IS NOT NULL AND ',@parent_table,'.',@parent_key,' IS NULL'));
|Posted by Ran Wei on March 10 2009 7:55pm
|[Delete] [Edit]
RE: Kai Baku
I believe the reason why your second example does not work is the following line from the Manual:
"In the referencing table, there must be an index where the foreign key columns are listed as the first columns in the same order"
In your first example, your primary keys are specified in the order, (`serverID`,`userid`,`characterName`,`jobAbbr`) which is the same as your foreign key specification.
In the second example, your keys are specified in the order, (`jobAbbr`,`serverID`,`userid`,`characterName`), but your foreign key specification places 'jobAbbr' last.
AFAIK, specifying INDEX (`jobAbbr`) will create a new index for jobAbbr but this one will be at the end, rather than the beginning, which again makes your index creation and foreign key creation match up.
|Posted by Claude Schlesser on April 3 2009 2:40pm
|[Delete] [Edit]
I have recently written a (german) article on how to import InnoDB tables and prevent the error "Cannot delete or update a parent row: a foreign key constraint fails".
You can find it here:
|Posted by Toby Thain on May 22 2009 5:21am
|[Delete] [Edit]
In our projects, we:
1) maintain separate SQL file per table (nicer version control histories)
2) need automated builds
3) use FK constraints extensively
Instead of disabling checks, which disables meaningful validity checks on the constraints, we use make to find a valid creation order. This also detects circular references. Code here: http://www.telegraphics.com.au/svn/fk/trunk/
|Posted by Lee Mallabone on June 1 2010 8:44am
|[Delete] [Edit]
If you're seeing errno 150 when trying to alter a table to add a foreign key, you have to check the properties of the *table* as well as the types of the columns being referenced.
For example, if you're trying to create a foreign key constraint between two varchar(30) columns, but one table is using latin1 encoding and the other table is using utf8 encoding, the ALTER will fail with errno 150 and no clear indication of the above.
|Posted by Seun Motunmori on June 17 2010 6:08am
|[Delete] [Edit]
If you, like myself, also ran into troubles with your FKs on InnoDB engine using version 5.1 of MySQL, then the trouble can be fixed by ensure that your referenced table columns are all indexed (original tables of reference).
Referenced Table 1
CREATE TABLE `study_mode` (
`id_study_mode` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NOT NULL,
`code` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id_study_mode`))
ENGINE = InnoDB;
Referenced Table 2
CREATE TABLE `gender` (
`id_gender` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NOT NULL,
`code` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id_gender`))
ENGINE = InnoDB;
Referencing Table with FKs
CREATE TABLE `prospect` (
`id_prospect` INT NOT NULL AUTO_INCREMENT,
`f_name` VARCHAR(45) NOT NULL,
`l_name` VARCHAR(45) NOT NULL,
`gender` VARCHAR(45) NOT NULL,
`e_mail` VARCHAR(45) NOT NULL,
`birth_year` YEAR NOT NULL,
`study_mode` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id_prospect`),
UNIQUE INDEX (`id_prospect`, `e_mail`),
INDEX (`gender`),
FOREIGN KEY (`gender`)
REFERENCES `gender`(`code`)
INDEX (`study_mode`),
FOREIGN KEY (`study_mode`)
REFERENCES `mydb`.`study_mode`(`code`)
ENGINE = InnoDB;
Ensure that you indexed both Table 1 and Table 2's referenced columns on Table 1 and Table 2 respectively.
If you don't, the error "#1005 - Can't create table 'prospect' (errno:105)" will be flagged. (Indexing is good practice as it avoids full table-scans!)
Once this is taken care of and the referenced columns are of same data-type, you would have successfully created your desired table with as many FKs as you want on it.
|Posted by blaise che on July 14 2010 4:17pm
|[Delete] [Edit]
To avoid 'errno: 150' when dealing with integer data types, verify that the primary and foreign key columns of interest have the same integer types (size and sign, as indicated above). e.g. if primary key is 'unsigned int' and foreign key is simply 'int', then 'errno: 150' is likely. Took me a while to debug this!
|Posted by Yann-Gael GAUTHERON on November 9 2010 9:07am
|[Delete] [Edit]
Here's a way to list all foreign keys from a database, using mysqldump and PHP :
public function fetch_foreign_keys() {
$cmd = "mysqldump --no-data --lock-tables=0 -u ".$this->login." -p\"".$this->password."\" -h ".$this->host." -P ".$this->port." \"".$this->database."\" 2>&1";
$result = shell_exec($cmd);
preg_match_all("/CREATE TABLE `(.[^`]*)`(.[^\;]*)\;/",$result,$matches);
foreach ($matches[2] as $k => $match) {
preg_match_all("/CONSTRAINT `(.[^`]*)` FOREIGN KEY \(`(.[^`]*)`\) REFERENCES `(.[^`]*)` \(`(.[^`]*)`\)/",$match,$matchesConstraints);
// On enlève les cases inutiles
array_shift($matchesConstraints); // 1ère
array_shift($matchesConstraints); // 2nde
array_pop($matchesConstraints); // Dernière
foreach ($matchesConstraints[1] as $j => $fk) {
$return[$fk][$matches[1][$k]] = $matchesConstraints[0][$j];
return $return;
|Posted by Christopher Beland on April 11 2011 2:45pm
|[Delete] [Edit]
Note that it will fail if you try to insert data into a table that has a foreign key constraint where the foreign table is a view.
|Posted by David Filmer on June 5 2011 12:31am
|[Delete] [Edit]
If you get an error:
<b>ERROR 1216: Cannot add or update a child row: a foreign key constraint fails</b>
it means you have two tables, at least one of which contains data, and you are trying to establish a relationship between keys (such as table1.id = table2.id), but there is data in one or both tables which does not currently meet this condition (often because table1 might contain keys that table2 does not contain and/or vice-versa).
You can't force a relationship onto tables which are not already compliant with the constraint (nor would you want to - if you are trying to do this, you haven't thought it out).
|Posted by manish patel on July 12 2011 6:54am
|[Delete] [Edit]
========To Remove Foreign Key from child table==========
CREATE TABLE parent (id INT NOT NULL, name varchar(25) not null default '',
PRIMARY KEY `id_name` (id,name)
CREATE TABLE child (id INT, parent_id INT, parent_name varchar(25) not null default '',
INDEX par_ind (parent_id),
FOREIGN KEY `id_name` (parent_id, parent_name) REFERENCES parent(id,name)
ON Delete CASCADE
on update CASCADE
#show create table schema of child table
show create table child;
CREATE TABLE `child` (
`id` int(11) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`parent_name` varchar(25) NOT NULL DEFAULT '',
KEY `par_ind` (`parent_id`),
KEY `id_name` (`parent_id`,`parent_name`),
CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`, `parent_name`) REFERENCES `parent` (`id`, `name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
then use CONSTRAINT `child_ibfk_1` to drop as Foreign key from child table by using below query.
alter table child drop FOREIGN KEY child_ibfk_1;
|Posted by Markus Zeller on January 5 2012 8:41am
|[Delete] [Edit]
I had the same issue and it could be solved by checking the keys to be *exactly* the same.
In my case I had the parent table with int unsigned not null, and the child had int signed not null.
So the signing was causing the error. I changed the child to be unsigned (just a unwanted mistake on creating the table) and all went fine.
|Posted by Philip Flammer on June 18 2012 8:22pm
|[Delete] [Edit]
When you get errors like the errno 150, and errno 121, and you don't have SUPER privileges to run SHOW ENGINE INNODB STATUS, it can take a long time to debug as a number of people above have discussed. Here is a list of known causes and solutions to various foreign key errors including these:
|Posted by Aurelien Marchand on February 27 2013 5:39pm
|[Delete] [Edit]
INSERT IGNORE will *still* trip the foreign key constraint. It's a known bug that is to be fixed in a later version.
CREATE TABLE T1 (id1 int, index key(id1));
CREATE TABLE T2(id2 int, foreign key (id2) references T1(id1));
INSERT IGNORE INTO T2(2); /* MySQL error, foreign key constraint violated, even though it was marked as IGNORE */
end result:
T1 contains (1)
T2 is empty!


text:
San Juan
Everything about your San Juan Spa is designed with you in mind. Completely user friendly and easy to maintain, your San Juan spa is sure to bring years of pleasure. As with anything else proper maintenance can ensure the long healthy life of your spa. A water logged spa cover can wreak havoc on your spa causing it to harbor dangerous bacteria, and can cost you hundreds of dollars in additional power consumption. The easiest solution to this problem, a custom fitted spa cover from Beyond Nice. Everything about our spa covers is designed to make them the best on the market


text:
antique French jars, Beach House, Coastal living, found objects, large glass jars, living etc, one kings lane, shopping, storage jars, Virginia Beach VA, Wilmington NC
I have truly been searching for these original French storage jars for months. I am so happy to say I have 5! Some of the lids have be reproduced, but the jars are authentic and stunning! I have 2 of them at the Wilmington shoppe and 3 in VB!
I've been on the road for weeks now with only a few days home in between. I've found some unique and beautiful pieces I can't wait to share. So keep in touch and check out our facebook page for more photos…. I add them throughout the week.


text:
- Northern New York Newspapers
- Watertown
- Ogdensburg
- Massena-Potsdam
- Lowville
- Carthage
- Malone
- NNY Business
- NNY Living
- NNY Ads
In the midst of a nationwide debate over voter identification laws, Jefferson County Board of Elections officials say they expect very little to change in the way the county verifies voter identity at the polls.
I dont really see anything coming down the lines in terms of changes to voter ID, Republican Election Commissioner Jerry O. Eaton said. In the five years since Ive been here, weve never had any allegations of voter fraud.
Although the county has been issuing voter identification cards since 1998, they are not required to be shown at a polling site to vote, according to Democratic Election Commissioner Babette M. Hall.
Unless voters register by mail, they do not have to present any form of documentary evidence of residency at the polling site. A voter simply states his or her name, validates the address listed and signs the election book to gain access to the ballot box.
New residents who want to vote in the primary must register in person or by mail no later than Aug. 16. Mailed applications must be postmarked by Aug. 16 and received no later than Aug. 21.
To vote in the general election, new residents must register in person or by mail no later than Oct. 11. By mail, applications must be postmarked no later than Oct. 11 and received no later than Oct. 16.
If a resident registered by mail and identification is required at the polling place, a passport, drivers license, non-drivers ID card, student ID card, pilots license, military ID or government ID will be accepted as a valid form of identification. Current utility bills, bank statements, government checks, paychecks or other government documents bearing the name and address of the voter will suffice if photo identification is not available.
Newly registered residents receive identification cards in the mail.
Voters who registered before 1998 may receive new ID cards in the mail if they have made a change to their addresses.
Address changes and changes to birth dates, which were not always tabulated, may be made at the polling site.
If an election inspector or another voter has reason to believe that someone is attempting voter fraud, he or she can initiate a challenge process on the spot, although it is rarely done.
I dont ever remember anyone on election day being challenged, Ms. Hall said.
But, absent a stricter set of voter identification laws which will be debated anew in the wake of a recent U.S. Supreme Court decision the challenge process is the primary recourse for officials to prevent voter fraud.
On Monday, in Arizona et al. v. Inter Tribal Council of Arizona Inc., et al., the Supreme Court ruled that the uniform federal form used to register voters for federal elections, which requires only that an applicant swear, under penalty of perjury, that he or she is a citizen, pre-empts an Arizona law that would require voter registration officials to reject any application not accompanied by documentary evidence of citizenship.
According to Lyle Denniston, a reporter for SCOTUSblog, a Bloomberg Law service, the ruling appears to grant ultimate authority in determining voter eligibility to the federal government but simultaneously leaves open the option for state officials to request that the federal government allow them to impose stricter identification laws and to appeal denials of those requests.
Thousands of readers like you have made Northern New York Newspapers the number one ranked website* for local news and sports coverage in the north country.
You can continue on to this article in a few seconds, or you can visit one of our websites:


text: Susan Polster, the journalism professor at the College of Eastern Utah, has received the Utah Chapter of the American Federation of Teachers' College Education of the Year Award. She joins a select group from CEU to ever receive the award. The others at the college who have garnered the honor include Don Burge, Neil Warren and Russell Wilson.


text:
Thanks for choosing mmm-online.com Sign up for your FREE account now and join the thousands of other healthcare marketing professionals who rely on us for all the latest industry news and innovative ideas for direct and digital strategy. Simply fill out the fields below.
Keep me logged in
Forgot your password?
R&D spend: $6.7B (6th),
up 11.7%; 15.3% of rev.
Top brands: Lantus ($2.3B); Eloxatin ($806M); Lovenox ($633M); Taxotere ($243M); Plavix ($196M)
Planned launches:
Teriflunomide (MS), visamerin (VTE), Lemtrada (MS), lixisenatide (diab.)
Promotional spend:
$477M (12th); 4.0% of rev.
Patent expirations:
Plavix (2012), Multaq (2014), Actonel (2014)
The diabetes medication merchant said in February that it expects business to fall off between 12% and 15% this year, as it weathers the aftershocks of patent losses on Lovenox, Ambien CR, Taxotere and Plavix. But it hopes to add diabetes treatment lixisenatide, a GLP-1 agonist scheduled to be filed this year. The GLP-1 field is a crowded one; Sanofi could bump up against Amylin's newcomer, Bydureon. Despite the uncertainty, Sanford Bernstein analyst Tim Anderson praised the company, in part because its patent cliff levels off next year.
Back to first page
« Previous 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Next »
Specialty medicines continue to be a hot category, one in which spending has surged behind products that treat medicine's most complex diseases. This eBook lays out the needs and hurdles along the specialty drug pathway, explaining how stakeholders are working to get meds into patients' hands and ease their experience. Click here to download.


text:
Swedish Interview With Prospect Johan Sundstrom
The Islanders signed Sundstrom to an ELC in June, meaning he'll probably end up in Bridgeport this fall. Sundstrom was a second round pick in 2011 and has spent the last couple seasons in the Swedish Elite League with Frolunda HC. You can check out a Swedish interview with Sundstrom here.
h/t to Keith


text:
Black Diamond Momentum SA Climbing Harness
The Black Diamond Momentum SA Climbing Harness is a promising all-around harness for different types of climbers. From the first-time climber to the seasoned hardman, this harress made for efficiency and safety. The patent-pending TrakFIT leg adjustments feature simple slide adjusters along the leg-loop webbing making adjustments quick, worry-free and easy. Experience excellent comfort with its abrasion-resistant nylon, breathable mesh, EVA foam padding, and soft lining materials. Providing you with an expert balance of comfort, ventilation and durability, Dual Core Construction uses two slim bands of high-tensile webbing on the outer edges of the waistbelt and a venting Bullhorn-shaped OpenAir foam insert in the center. This combination provides you with both comfort and breathability without pressure points. It also features an adjustable releasable rear elastic riser, 4-pressure-molded gear loops, and 12kN-rated haul loop. The Black Diamond Momentum SA Harness allows you to tighten or loosen the fit quickly and easily with the new pre-threaded Speed Adjust buckle on the waistbelt and contoured leg loops.
This product can only be shipped to U.S. addresses.


text:
Buoyed By iPhones Sales Verizon Reports Stong Earnings
Palabras clave
A Verizon store is seen April 21, 2011 in Santa Monica, California.... Fotografía de noticias2011,California,EE.UU.,Finanzas,Horizontal,Santa Monica,Tienda,Verizon CommunicationsPhotographer Eric ThayerCollection: Getty Images News 2011 Getty ImagesSANTA MONICA, CA - APRIL 21: A Verizon store is seen April 21, 2011 in Santa Monica, California. Verizon announced today that it activated 2.2 million iPhones during the first quarter, helping the company more than triple its profit from a year ago. The company reported earnings of $1.4 billion on revenue of $27 billion for the quarter. Profit grew more than three-fold from the $443 million the telecom company earned during the same period last year. (Photo by Eric Thayer/Getty Images)


text:
The domain unhealthyearth.com may be for sale. Click here to make an offer or call 877-588-1085 to speak with one of our domain experts.
Related Searches
Diet Pills
Unhealthy Foods
Raw Dog Food
Unhealthy Eating
Find Zip Code
Unhealthy S
Unhealthy Hair
Unhealthy Heart
Soy Unhealthy
Unhealthy Food List
This domain may be for sale.
Buy this Domain
Privacy Policy


text:
postage is for UK mainland only. Next day delivery is excluded from
offshore destinations, Highlands and Islands, these areas will be a 2-3
day delivery service.
We can ship to most EU countries, this excludes the Canary Islands.
PayPal payment is preferred, so that orders can be dispatched quickly.
Postal orders are accepted but sorry NO cheques.
Orders received before 3pm are usually dispatched the same day.
If you have a special requirement, please send us an ebay message and
NOT a PayPal message.
If for whatever reason you wish to
return an unused item,please return it to us within 14 days for a full
refund less a 10-20% handling charge to cover postage and packing costs.
Please ensure the item is unused and in it's
original packaging, in a
saleable condition. Make sure you include your ebay
user ID and the
reason for returnAll new items are sold subject to the
manufacturers 12 month
warranty. This warranty only covers the item or part, it does not cover
consequential losses.In the unlikely event that you need to
return a faulty item,
please contact us before returning the item. The
buyer is responsible for
any return costs, if the item is found to be faulty, these return costs
will be


text:
Lauren Ralph Lauren Men's Big & Tall Tan Suit Separates
Sleek, contemporary and eminently masculine, this sharp suit jacket completes your dapper, professional look. Pair with the matching pants (sold separately) for coordinated style. Choose pleated or flat-front styles.
Tell a Friend
- Classic-fit, 2-button suit separate with center vent
- Ultraflex allows total freedom of movement
- Total stretch jacket with shape retention
- Coordinating pants sold separately
- Wool
- Imported
- Flat-front, classic-fit suit separate with plain hem
- Ultraflex allows total freedom of movement
- Pants retain shape around comfort waist
- Coordinating jacket sold separately
- Wool
- Imported
This item cannot be gift boxed.
This item should only be returned to the warehouse from which it was originally shipped.
Use the pre-addressed return shipping label attached to the packing slip included with your shipment. In the event that you have misplaced your packing slip, this product should be sent to the address below:
The Bon-Ton Stores, Inc.
ATTN: Returns
1340 Dayton-Yellow Springs Road
Fairborn, OH 45324
Additional information
Shipping & Delivery Details
Returning a purchase
Customer Service