text:
Property listing website wordpress themeJobs
I have several website links which contains details about the property valuation and taxing details, I like to build a software to have bots performing auto search on the links based upon the unique property Id provided and perform two things (1) It has to search and convert the search results into PDF (2) it has to scrap the details available in the
Looking for someone with an ****LLB from the UK**** who has experience researching and writing. The topic would be regarding UK Property law situation. MUST know OSCOLA referencing formatting. Must state where you completed your LL.B and if possible an academic writing sample (with OSCOLA formatting). Must be available in the month of December 2018
Looking for a 3D graphic designer, one who is capable of bringing my IP to life.
Approx 5-6 page website for apartment complex. Will have photos of property to add to site. Site must look upscale. Property owner wants to be able to setup each resident to sign in and have access to documents. 3 levels of permissions needed. Users must be able to create their account and change their password but Admin must have the option to approve
I have several website links which contains details about the property valuation and taxing details, I like to build a software to have bots performing auto search on the links based upon the unique property Id provided and perform two things (1) It has to search and convert the search results into PDF (2) it has to scrap the details available in the
Hey i"m looking for copywriter to write a property description. 200 - 300 words I will supply pictures and description .
4 Townhouse Development 4-6 internal renders want very realistic renders something very similar to this interiors in the website below [log ind for at se URL]
4 Townhouse development Gold Coast design - modern New York loft look
Emerald Coast Rental Management. Property Management Company in Destin Florida.
I would like a stellar condominium property management proposal designed
Dear Freelancers, The job is to create a 3d visualisation of a house on a plot. The visualisation is intended for use as a prospect material for sale purpose. For the work you will be handed: * photos from drone * 2d drawings of the house * 3d rendered images of the house
We need a logo and banner for one of our demo websites. The company's name is Rockville Property Management. I have attached our current logo and banner we are looking to update. We require two things 1) Logo: 160 x 50 proportion 2) Banner image: 1034 x 156 proportion *Logo must be transparent and vector format (SVG/Adobe illustrator)
hi i need a property portal website in one day who already made prefer send me demo please
A property (real estate) letting and management company website. The page that shows available properties is currently using an iframe provided by the software company that the Letting agents use to manage the properties. This means the page is not fluid and causes problems when viewing on smaller devices. The property company say that all the data
Hello, my website is almost complete, i need to develop Property Gallery, I need professional help for that. In all i need professional finishing to my website.... please guide me for that. [log ind for at se URL]
need someone to assist with setting up wordpress property management website that will allow tenants to login to a portal, advertise rental property
I am looking for a international register idea patten of a phone case concept.
I need a new website. I need you to design and build a website for my small business like [log ind for at se URL], [log ind for at se URL]
I have ongoing work related to our previous project 'Gif animated advertisement ban...related to our previous project 'Gif animated advertisement banner google, fb, IG all sizes & approved format / sizes. Advertisement Content: Legal Contracts from R99.00 Property Lease Wills Sales Agreements Business Contracts & Much more [log ind for at se URL]'
We are looking for a programmer to create an interactive form module for Collection of data for property valuation. The collected data must be integrated into our CRM program. A very good example is this: [log ind for at se URL] What is optimal about it: - Very clear, visible and prominent at a glance - fast handling, no repeated clicks necessary
Hi, I am looking Property management or Apartment Rental Management ERP with all features in PHP or Asp.Net including source code. Please send me demo to check. I am looking urgent so I need readymade already developed one. Thanks, Jose
I need a logo for a Mountain property that is called Strawberry Mine. It is a family vacation home but it was an old mineral mine and we now use it for family trips and horse back packing trips. Its called Strawberry Mine so I want to incorporate the cuteness of the word "Strawberry" but also the rustic aspect of it. I was thinking of having a strawberry
We have site build in PHP laravel we want you to fix some high level bugs. Need PHP and designer expert
Need a new website to replace [log ind for at se URL] - hoping to have someone that can update it periodically if we have requests and charge an hourly fee when we need someone to come in an update? should be rare, no more than once or twice a month.
We need a website mockup for selling a property: - 1 homepage design mockup - 1 subpage design mockup Website structure: - Home - Property details (one whole building) - Location & Transport (Map with key points – we want to create a map which shows where the property together with some key landmarks labelled on the map) - City and Country
I need some images of a house to be photoshopped to increase quality, I like a bright style photo. please quote monkies so i know you read this.
Please find project's details in the following link, [log ind for at se URL]
Texas PM Brokerage is hiring a VA for their tenant relations. Work tasks include tenant screenings, repair coordination, lease documentation, ongoing tenant communications and various computer and phone tasks. Our VA will be proficient in speaking and communicating in English, possess excellent customer service skills and have a pleasant demeanor. We expect that once a "training" period...
we need to make a fully responsive real estate website where all property can add by agent and dealors or owners also agent can register their account and check all property stats etc how many clicks views etc. theirs are many examples when we talk we wil discus before bid you have 100% knowledge what i need
Scrape Public Property Records
Need to analyse an Australian company. should have finance background and good English writing skills
I am opening 2 new businesses in NC. I want to trademark my company name. I also want to know whether or now I can trademark phrases connected to my company's name. Company name: REDDRAISER LLC. Can I trade mark REDDRAISER so that I can use it like (REDDRAISER BUYER or REDDRAISER SELLER. Especially REDDRAISER REFERRAL(S). I'm interested in a couple of things, first to Trademark the...
I need a new website. I need you to design and build a website for my small business. Attached requirement are in mobile app format but I want to work on web app for this current phase
I need a new website. I need you to design a website for my small business.
Looking for a logo for our property management company. Want something with clean lines, professional, the font photography to look very professional, well organized and easy to read.
Hello, I need a desktop app which would extract data from zameen.com. The list of properties can be in excel or txt format...cover all locations of three major cities: Lahore, Islamabad, Karachi. Im only interested in residential properties, i.e. plots and houses. The list should include prices, property information, contact information etc. Thanks.
Hi I've drafted a posting to update on my law blog. This is about editing 'Property in law from my experience'. The length is about 1,000 words. It'd be nice to get some help from either property lawyer, academia or advanced law degree students (PhD or Masters) to go over it. Please let me know if interested. Thanks!
looking for word press developer to finish off the property website with few things left time period with in 24 hours and budget is $30. Thanks
...USA and gather the property record data from the county's office. For this purpose, I want help in gathering the following details of USA counties official public Real estate property recorder or office details: > County Name - Name of the County (I will provide you the list) > Department - Name of the department who keeps property records (Ownership
I need to re-design my website: [log ind for at se URL] Please tell me the cost to re-design the website. In addition, please tell me how long it will take you to redesign my website: [log ind for at se URL]
Your duties would be visiting the uk property website rightmove and using a set criteria I will provide, input the properties that match these descriptions into excel and call uk estate agents when you require information which may not be online such as the door number of a property
...journalist style articles for property related topics. Specifically infrastructure & urban renewal projects, market trends & conditions across different asset classes etc. Will need to do the background research & investigations to inform the articles/ topics. Thus, will need to have a decent understanding of property and preferably planning & development
Looking for a website designer to create a website for luxurious property which will be rented for short terms. Thus, there is a need for a booking portal with payment systeme as well.
This brief is to design a logo for a property development company called Maxton Property Group. ABOUT THE BUSINESS - What do we do: we manage the development process including land purchase, design, construction and selling or renting of the newly developed houses - We want to be known for: being thorough, seamless/easy to deal with, our attention
We are property consultant All Projects are in Mumbai Prices of each property 15cr and above i am looking for cost per sale lead for the property in mumbai you will get paid after every lead closed
Hi, we are looking for some one to work along side our company In helping us produce CGI property imagery, this wouldn't be a one off project bit consistent on going work.
Need Press Release written about our Property bond, which is asset backed by property on the French Riviera. Specifics will be given over a call. Offering $200 for 2 the press releases (400 words each) Please apply with your portfolio and we can then schedule a call to discuss your method in creating press releases.
Hi, I have a property app made with ionic 1 and i want to improve it functionality, design and Modify navigation between pages so i want to do this: 1) I want to improve the layout design 2) when open the app you will see a list of categories when click on one of them it display list of areas i want to change this when click on one of categories it
I'm looking for somebody to develop a Wordpress Plugin for a property management system that works for all types of accommodations: hotels, motels, hostels, B&Bs, lodges & guest houses. A booking engine that makes it easy for guests to book online, using any type of device. Along with this I would like to be able to set up OTA Connections to All Major


text:
(Credit: Harry How: Getty Images)
Let's get the bad news out of the way at the jump. Last week we went 0-4 with the picks, not good. After a 4-0 week to start the playoffs, I expected some adjustment but 0-4 is just brutal. Saturday was especially a mess, we were laying 9 points with Denver, they really never pulled away when they had the chance, and in the late game the Packers started strong but eventually got blown out in San Francisco. On Sunday I was chalking up a win with Atlanta laying 2 1/2 with a 20-point lead, but the Falcons choked away that lead in epic fashion, they won the game but didn't cover the spread. And New England tacked on some late points to knock off the Texans +9, and capped off our 0-4 weekend. Again, not good. One gambling note from last week: every game last week went Over the total (significantly), and this week I am expecting the same. Even the 51 1/2 point total in the Patriots/Ravens game looks like it is a little low.
We do have some good storylines this week: the Patriots train keeps rolling to yet another AFC title game; Ray Lewis lives to fight for one more week; Colin Kaepernick continues his magical run; and Matt Ryan and the Falcons look to finally get the monkey off their backs and get to the Super Bowl. My analysis is below, but I'm looking at a San Francisco / New England Super Bowl. My original Super Bowl picks of Denver v. Green Bay went up in flames last week. Let's hope this week is better for us.
Stay in the loop. I usually tweet out some picks during the week and on gameday, so follow me on Twitter (@Fantasource) to get the latest.
Let's get some winners and rebound back from a bad week…
Last Week: 0-4 (boooo!)
Season Record: 126-104-3
Sunday, Jan. 20th
San Francisco 49ers at Atlanta Falcons (+4, O/U 49)
Colin Kaepernick sure showed something last week. I picked the Packers to win in San Francisco mainly because I expected the rookie to wilt under the playoff pressure. But Kaepernick not only played well, he brought his game to another level. Rushing 181 yards against a pretty good Packers defense? Wow. Jim Harbaugh looked like he went all-in with the Kaepernick playbook, more designed QB rushes, more liberty to run out of the pocket when he was pressured, and it paid off big time. And I'm expecting Kaepernick to do something similar this week. I like the 49ers to win this one.
And truthfully, I'm not going with the Falcons because when you blow a 20 point lead at home in the playoffs, then I can't put my money on you. I just can't. Especially from what I saw in the 2nd half against Seattle, the Falcons just looked like a completely different team. Now if they can put together a game that looked more like the first half of the Seattle game then they can win, but I don't see that happening. Russell Wilson was able to put up 385 yards last week on the Falcons defense, sure he threw more than usual because Seattle fell behind early and they were throwing to try to catch up, but still it was 385 yards.
This week the Falcons will have one of their best defensive lineman – John Abraham – banged up for the game. Abraham should play, but he won't be 100% and that is huge. The Falcons need to pressure Kaepernick when he is in the pocket because they aren't going to stop the 49ers run game (including their scrambling QB). Atlanta comes in ranked 20th against the run, while San Francisco is the 3rd ranked rushing team in the league. And if Kaepernick can get loose like he did last week then San Francisco should be able to get out of Atlanta with a win and a trip to the Super Bowl.
Can Atlanta protect Matt Ryan against the 49ers pass rush? That will be another key matchup this week. If Matt Ryan has time to set up and throw to Julio Jones, Roddy White and Tony Gonzalez then I would lean to Atlanta, but I don't think it happens. San Francisco is ranked 6th in pass defense and 2nd in rush defense so I would expect the Falcons to have a tough time moving the ball. They won't jump out to an early 20-point lead, that is for sure.
So, in this game I'll take the team with the better defense and the better coach playing with the hotter QB. 49ers win on the road, 31-24.
Pick: 49ers -4
Baltimore Ravens at New England Patriots (-9, O/U 51 1/2)
Ok, here we go again. Ravens fans you can thank me later. Last week I picked you to lose, and you all know what happened. And this week I'm going against the Ravens again.
I'm picking the Patriots pretty much for one reason, I don't think the Ravens can get up for another huge road game, not after that double overtime street brawl last week in Denver. They should have lost last week and they know it. But Flacco, to his credit, got it done with a 70 yard touchdown at the end of regulation to force overtime and allow the Ravens to pull off the most improbable upset in recent memory as a 9 point underdog.
But can they do it again? I'm saying no. But don't get me wrong. I would love to see the Ravens to win this game. One more game for Ray Lewis? In the Super Bowl? Sign me up. And I think we all have Patriots fatigue by now. Another year, another Super Bowl run for Brady. C'mon man, give someone else a chance. But I just think the Pats will be ready for this one.
These teams met back in Week 3, the Ravens came away with a 31-30 win, but the real revenge comes from last year's AFC Championship game. The Ravens came oh-so-close to the Super Bowl, but a missed field goal at the buzzer sent them home.
So yes, the emotion of Ray Lewis' retirement and the memory of last season's Championship game loss are plenty of ammunition to being into a game like this. But I don't think it's enough.
The Pats defense isn't great, but it is playing better than it was in Week 3 and believe it or not, it is ranked higher than the Ravens D this season (NE 15th, Baltimore 19th).
For the Ravens to win this game (or to even hang lose) they're going to need another big week from Joe Flacco and Torrey Smith. I expect the Patriots to do what they did last week and put up 30+ points (Denver scored 35 on this Ravens defense last week), so can the Ravens score 30 again to keep themselves in the game? I'll say no. But one thing to note is that Texans TE Owen Daniels had a good game last week (15 targets, 9 catches, 81 yards), so expect Ravens TE Dennis Pitta to see the ball a lot to try to help open up the field for the long passes to Smith and Boldin and company. Will this make a difference? Probably not, but if the Ravens end up winning this one they'll need Pitta to have a big game.
Last week, the Broncos scored 35 points in a losing effort. Yes, two of those touchdowns came on special teams but I think Brady can move the ball against the Ravens and put up a similar number.
The big injury news for the Patriots is about TE Rob Gronkowski, he re-injured his forearm last week and is out for the remainder of the playoffs. It will be a blow to the passing game, but Gronkowski was out for five games prior to the playoffs and the Patriots did just fine, going 4-1 including 3 wins on the road. The game they lost was to the 49ers, but that will be something we'll discuss in the Super Bowl preview (foreshadowing!). So, losing Gronkowski will be a setback but it won't change my pick.
Bill Belichick is 0-2 in AFC Championship games when laying seven points or more but this week I think he gets it done. New England has won 10 of their last 11 games, so they are definitely the hot team here. I'll say the Patriots get the win and the cover (barely), New England 34-24.
Pick: Patriots -9

subset: commoncrawl


text:
CANANDAIGUA � A family with two young children escaped from a fire inside their Pleasant Street home Thursday evening.
Canandaigua Fire Chief Mark Marantette said the kitchen fire started just before 6 p.m. at the home of Greg and Lucy Stoyles at 259 N. Pleasant St., Canandaigua.
Lucy Stoyles was cooking on the stovetop when oil in the pan ignited, Marentette said. Greg Stoyles then moved the pan to the floor and attempted to smother the fire before leaving the residence, while Lucy Stoyles escorted her two children outside and immediately dialed 911.
The Stoyles and their children, Isobel, 7, and Caedman, 5, were able to escape the home unharmed, Marentette said, but there is extensive smoke damage throughout the home. The family was able to provide their own lodging while displaced from the home, Marentette said.
Two former Canandaigua firefighters who now work for the Gates Fire Department, Mike Bates and Jason Harris, were two doors down from the home when the fire occurred and responded immediately. They entered the dwelling with a fire extinguisher, but were driven out by the smoke conditions, Marentette said. Bates and Harris kept the situation in check until firefighters arrived by closing the front door behind them when they exited the house, which limited the amount of air feeding the fire, Marentette said.
Canandaigua firefighters were dispatched at 6 p.m., arrived at the home in less than four minutes and put out the fire by 6:09 p.m., Marentette said. All the smoke alarms in the home were sounding when firefighters entered.
Nearly 30 firefighters and support personnel from the Canandaigua, Veterans Affairs and Crystal Beach fire departments responded to the scene and searched both floors of the house in zero-visibility conditions to make sure no one was inside. The family�s dog, originally reported to still be inside, had escaped on its own and was found outside, Marentette said.
The Farmington, Shortsville and Rushville fire departments covered the responding departments� protection areas during the fire.
Marentette said this fire reinforces the importance of fire safety practices in the home � testing fire alarms, having a fire extinguisher accessible in the kitchen, designating a pre-determined meeting place outside the house and closing all doors when leaving the house. Marentette also reminds people to never move pots or pans involved in a fire, never re-enter the home and call 911 as soon as possible.
Family escapes Canandaigua fire
CANANDAIGUA � A family with two young children escaped from a fire inside their Pleasant Street home Thursday evening.


text:
Time: January 27, 2018 at 8pm to January 28, 2018 at 1am
Location: Downtown Independent
Street: 251 S Main St
City/Town: Los Angeles, CA
Phone: 213-617-1033
Event Type: screening
Organized By: Downtown Independent
Latest Activity: Jan 18, 2018
Channel 101 is an untelevised TV network open to all artist submissions that each month screens 10 5 minute shows, 5 episodes from last month and 5 new pilots. At the end of the night the audience votes on their favorites and the winners continue on to next month. There is one screenings in an evening and the event is free and open to the public. Started by Dan Harmon in 2003, each Channel 101 show is a unique and wild experience, well worth checking out!
From their own website:
For the audiences that attend the live screenings, Channel 101 is a chance to sit in the worn-out chair of the fat network exec, drunk on the blood of lowly artists whose right to exist is given in exchange for their ability to nourish. If there are 10 shows in the screening and 7 of them are good, that means 2 good shows aren't coming back and the power of life and death is in your hands. Base your decision on whatever you want. You run the network. You pick the programming. Then come back in a month and see the next episodes of the shows you picked- plus a healthy crop of new pilots. Dump the whole lineup and start fresh, or keep your favorite show running all year. Unlike "real" television, at Channel 101, what you want is what you get more of, and the day you stop wanting something is the day it stops.
For the creatives that participate, Channel 101 is where the rubber meets the road. The deadlines are unreasonable, the time limit is impossible, the pay is non existent and the judgment is blunt. The amount of ego and sense of entitlement with which you enter is exactly proportional to the amount of pain you'll experience before you leave. Channel 101 is where you learn three things: How to fail, how to succeed, and finally, how there is no difference between the two. After all, the only thing as bad as being told your pilot failed is being told that your third episode was worse than your second. And the only thing as good as having the number one show is having a chance to come back with something new. In the mean time, you become harder, faster and fearless. You surrender to the audience as life-giving God and acquire total creative freedom through that surrender. You make connections with fellow creatives, you have something to look forward to all the time and for a few shining moments here and there, you're in the zone and your life takes on a little meaning."


text:
You must login before you can run this tool.
SUGARCube - ADXL Accelerometer
Modeling and simulationg of ADXL accelerometer
Version 0.2 - published on 20 Aug 2014
doi:10.4231/D36D5PC07 cite this
Published on
This tool is capable to do static and parameter(s) sweep analysis with customized material, geometry and actuation properties. SUGAR2.0 is used for all the analyses, and RAPPTURE toolkit is used to create the GUI.
Deflection images, original images with customized view angle for static analysis as well as sweep curve, table-formatted deflection data for parameter(s) sweep analysis are provided as outputs. The netlist which is used to describe the model in SUGAR2.0 can be downloaded for further development.
Cite this work
Researchers should cite this work as follows:


text:
J. Brown needed a new logo design and created a contest on 99designs.
A winner was selected from 133 designs submitted by 30 freelance designers.
Trinity Logistics
We are logistics company that specializes in technology to create savings and efficiencies in companies freight programs. Our main color is maroon.
We are targeting manufactures and distributors. More than just a targeted audience we want to give our company a more modern feel.
I want a modern looking logo that express innovation and success. Please be creative with your designs. Our current logo features a "T" within a shield with the name "Trinity Logistics" under the "T." I am looking for fresh new ideas. We are a Christian based company so the name "Trinity" holds significance to us. Attached is our current logo.
Find out how a design contest works or learn more about our logo design services.


text:
Tools for the Professional
The National Rosacea Society (NRS) seeks not only to raise public awareness and support research, but also to provide medical professionals with patient education and professional tools that can aid in the diagnosis, treatment and effective management of this chronic and widespread disorder.
The widely used patient education materials published by the NRS are available in bulk quantities to health professionals, edited by physicians and incorporating the standard criteria for rosacea. These include the introductory booklets "Understanding Rosacea" and "Managing Rosacea"; the "Rosacea Diary" and the "Triggers Checklist" tear-sheet tablet, both of which aid in identifying and minimizing individual rosacea triggers; and the newsletter, Rosacea Review. An easy-to-use, interactive order form makes it fast and simple to request the desired quantities.
In addition, the NRS makes a broad range of professional materials available specifically for health professionals, such as the clinical scorecard for evaluating rosacea patients and a "Faces of Rosacea" office poster illustrating the four subtypes of the condition. NRS consensus committees and review panels of 26 rosacea experts developed the standard classification system, standard grading system and standard management options to provide standard criteria and terminology for the diagnosis and management of rosacea. The NRS recently published updated rosacea treatment algorithms online, reflecting subsequently approved medical therapies. Professional materials may be additionally requested using the online order form.
Continuing Medical Education
In partnership with the NRS, Haymarket Medical Education has produced the Rosacea Learning Center, an educational resource for dermatologists and other healthcare providers interested in continuing medical education that focuses on rosacea.
Professional Membership
Physicians may also become professional members of the NRS to receive additional benefits to help attract new patients, enhance patient care and support research. By joining the NRS, you will be included in the Professional Member listing in the Physician Finder section of this site, seen by more than 1 million people with rosacea each year, and gain increased access to the broad range of educational resources described above. In addition, your donation will be used to support the NRS research grants program, and you will receive a reception window decal and office display card showing your support. Simply select the Professional Membership option on our online Materials Request form or complete the Professional Membership Form (PDF) and mail it with your donation to the National Rosacea Society, 196 James Street, Barrington, IL 60010.
Contact Us
- Phone:
- Email:
- firstname.lastname@example.com
196 James St.
Barrington, IL 60010
Our Mission
The National Rosacea Society is a 501(c)(3) nonprofit organization whose mission is to improve the lives of people with rosacea by raising awareness, providing public health information and supporting medical research on this widespread but little-known disorder. The information the Society provides should not be considered medical advice, nor is it intended to replace
consultation with a qualified physician. The Society does not evaluate, endorse or recommend any particular medications, products, equipment or treatments. Rosacea may vary substantially from one patient to another, and treatment must be tailored by a physician for each individual case. For more information, visit About Us.


text:
The primary cells of connective tissue are fibroblasts. Found throughout the body, connective tissue exhibits a smaller number of cells than most other tissue types and a significantly larger amount of intercellular substance. In addition to fibroblasts, macrophages, adipose cells, mast cells, lymphocytes, monocytes, eosinophils, and plasma cells are also often present in connective tissue. The connective tissue found in the cortex of the kidney, however, is believed to predominantly consist of fibroblasts and macrophages. Forming a capsule around the organ, this renal tissue is organized into a thin layer but is relatively dense and collagenous. The medullary interstitial connective tissue found in the kidney is significantly thicker than that of the cortex and vascular components and some apparatus of the uriniferous tubules are embedded in the material.
The microtubules present in the log phase culture of CV-1 cells featured in the digital image presented above were immunofluorescently labeled with primary anti-tubulin mouse monoclonal antibodies followed by goat anti-mouse Fab fragments conjugated to Rhodamine Red-X. In addition, the culture was simultaneously stained with DAPI, which selectively binds to DNA in the cell nuclei. Images were recorded in grayscale with a QImaging Retiga Fast-EXi camera system coupled to an Olympus BX-51 microscope equipped with bandpass emission fluorescence filter optical blocks provided by Omega Optical. During the processing stage, individual image channels were pseudocolored with RGB values corresponding to each of the fluorophore emission spectral profiles.
© 1995-2019 by Michael W. Davidson and The Florida State University. All Rights Reserved. No images, graphics, software, scripts, or applets may be reproduced or used in any manner without permission from the copyright holders. Use of this website means you agree to all of the Legal Terms and Conditions set forth by the owners.
This website is maintained by our


text:
Camera Geekery
The Ricoh GR….A buyers guide5 min read
The Ricoh GR series of cameras are great, but what are the differences? This is something that I get asked an awful lot, so I thought I would put together this little guide for you. It should give you an idea about the differences and what to look for.


text: For almost eight decades Citizen Watches have been ahead of their time. Creating innovative and high precision watches, Citizen is at the forefront of design. From their new Eco-Drive watches with batteries that never need replacing, to their Chronograph styles that have enduring appeal; Citizen creates timepieces to suit our ever changing lifestyles.


text:
By Caroline McGraw Jan 31, 2013 0
Seeking Sustenance
I stand in the refrigerated section of Sam's Club, holding a carton of eggs. I pop it open and inspect the eggs, checking for cracks. Just as I ascertain that there are none—that this is a flawless batch—I hear a voice behind me.
"Last time I was here I didn't remember to do that," the voice says. I turn and see a smiling, older gentleman a few feet away.
"... And then I got home and I had four that were broken," he finishes.
I register what's been said and laugh, even as my attention turns to the man beside the speaker. Both men have gray hair and slightly stooped bodies, but while the first speaker is simply friendly, the second man is … radiant. Radiant with joyful energy, with enthusiasm. "Hi!" he exclaims.
"Hi!" I reply, without hesitation. He's beaming, and I can't help but beam back. For a moment, we aren't perfect strangers. We are long-lost friends, thrilled to reunite.
And at some point in this brief interaction it registers in my mind that this second man may have some form of intellectual or developmental disability. It's only a guess, and I could certainly be wrong, but he reminds me so much of my friends at L'Arche. It's not just in his mannerisms or expressions; it's in his transparency of spirit. It's the way he feels like family at first sight.
I remember what the first man said, and reply, "My mom always insisted that I check the eggs before putting them in the cart."
My voice is light, but I feel a pang as I say the words. I miss my mother. It's hard being so far from my family. These men remind me of my father and brother, who go shopping at their local warehouse club on Saturdays. I love that my dad takes Willie with him on this and other weekly errands; it's an act of love and courage, especially because of Willie's potential for meltdowns. And I can totally picture my dad having this same conversation with a fellow shopper as Willie stands beside him, and it makes me miss them both so much that I can hardly breathe.
"Oh, my wife did that too," says the man, bringing me back to the present moment. "She said the same, but I forgot. She's been gone … four years now."
"Oh, I'm sorry to hear that," I say. I feel sympathy for this sweet man who has lost his wife. But the unexpected joy I feel in interacting with these two men mitigates the sadness and the bittersweet sense of missing my family.
I look from one man to the other. Our moment passes; we wave and wish each other a good day. I say, "So good to see you." I feel silly for saying these words—after all, we've never met before—but the younger man smiles at me, radiant once more. Then they turn away, the older man leading the younger one to the produce section.
As they walk away, I see them more clearly. I'd thought of them as father and son, probably because they reminded me of my dad and brother on their weekly shopping trips. But as they walk away, I realize: they're siblings. Of course. An older and younger brother, out shopping together.
As they move away, I wonder about their lives. I wonder if the older brother ever struggled with the idea of accompanying his younger brother through life. I wonder about their connection, if they live together full-time, if they're the only ones left in their family.
It's not reasonable, but I want to follow them and thank them. I want to walk beside them, in their presence, because the gentle way they have with one another gives me hope for my future.
And I think: Dear God, may Willie and I live to get gray hair and shop at Sam's together someday.
Slowly, I start pushing my cart toward the checkout. And I realize that the best way to thank these siblings for being who they are is with my life, not my words.


text:
Canadian performances in week 13 of 2018 NFL season
Canadafootballchat.com (CFC) will be following and reporting on the weekly performances of all Canadians – and those who have declared themselves as Nationals – playing in the CFL.
This article is for CFC Insiders only
Become a CFC Insider Member to see this content. Please login or Signup today!
About Canadafootballchat.com
Canadafootballchat.com (CFC) is the number one (source: comScore.com) and most respected national recruiting and high school news site. CFCs mission is to promote Canadian football players in the high school recruiting cycle.
About the 'CFC Insider'
The CFC Insider exclusive membership section gives you access to:
- exclusive recruiting articles
- exclusive player profiles
- member-only FORUM section
- exclusive team recruiting class rankings
- exclusive player class rankings
Tags: cfc_insider, NFL, NFL Canadian Performances


text:
- Options
Item # SPP0025Item # SPP0025
In order to do routine maintenance on the internals of your Speedplay road pedals you need to remove its dust cap. If you remove & reinstall your dust caps enough times, you'll probably want to replace them in order to ensure that they'll stay firmly in place as you ride.
Please Note: Due to manufacturer restrictions, we are unable to ship Speedplay products outside the United States.
View more Pedal Small Parts
Reviews & Community
Plugging up tiny bicycle hole
- Familiarity: I've put it through the wringer
I lost the original plug when I greased the pedals. I applied too much pressure on the screw when I attempted to replace the original plug and it fell out. I replaced the plug with another one and that one fell out, too because when I applied the extra pressure to the plug I created a little crevice on the side of the plug and the screw was not taut enough to hold the plug. I added a third plug and this time I used a little clear caulking gel, just a little (!), to hold the plug into place. Several rides later and the bicycle plug pedal is still in place!


text:
Azusa Pacific University in partnership with Lifeway Students, World Impact, Young Life, Solidarity, Fellowship of Christian Athletes, DeVos Urban Leadership, World Vision, and the American Bible Society
Urban Youth Workers Institute:360 National Conference. The national, non–profit Urban Youth Workers Institute (UWYI) trains and provides resources to urban youth workers to help them effectively evangelize and disciple youth in at–risk areas.
The 360 Conference invites like–minded leaders to collaborate and learn best practices to help their youth ministries. Speakers include Efrem Smith, president and CEO of World Impact; Larry Acosta, D.Min., founder and CEO of UWYI and an APU Board of Trustees member; Gregg Moder, D.Min., APU associate professor in the Department of Practical Theology; and Viv Grigg, Ph.D., APU associate professor in the Department of Global Studies, Sociology, and TESOL.
Azusa Pacific University, 901 E. Alosta Ave., Azusa, CA
Thurs.–Sat., May 15–17
Registration remains open until the day of the event. For more information, visit http://360.uywi.org.


text:
Antebellum Stair Riser Decal
Antebellum Stair Riser Decal
Our Antebellum design is printed onto durable, adhesive backed vinyl, using the most cutting edge printing technology available. The low tack, readjustable adhesive backing make them a breeze to install. These decals are a great solution for already installed hardwood stairs!
Make the statement you've always wanted without all of the mess of construction or paint. Simply stick our decals onto the existing risers and when heated, they will remain permanent. They are printed on a very durable vinyl substrate that is meant to take years of abuse. It is possible to remove them but much like removing old wallpaper it my require a little "elbow grease."
They have a low luster finish and can be easily replaced if damaged.
Size: Our Packs of vinyl riser decals are available in 2 different sizes with each pack containing 7 of the riser decals.
7 1/4" x 48" - $168
7 1/4'' x 96'' - $315
Small Samples are available for $5
*Please Note: Ordering a test sample prior to placing a larger quantity order is recommended as our decals are printed to order and therefore we are unable to accept returns. It is also suggested to test the sample on your risers to make sure it is a suitable surface for installation.
Material: The material we print on was developed to be used for outdoor signage, vehicle wraps, stadiums and point of purchase for retail stores and malls. We have just taken this high tech material, printed it with our fabulous designs and laminated it with a heavy duty laminate. Though it is a decal, it is seriously durable! Dirt and debris cleans up easily with a damp cloth.
Samples, Shipping & Lead time: Samples typically ship within a week. The packs of 7 vinyl riser decals have a lead time of 2-3 weeks as they are made to order. If you need your order to be quicker, we may be able to accommodate your timeline for an additional fee (for questions about expediting your order please contact our office at 866-519-7727).
Installation Guidelines are available for your reference.
Vinyl Dye Lot Disclaimer:
When ordering Mirth Studio vinyl products, please keep in mind that samples may not always be an exact match to your order and may differ sightly (up to 10%) as they are subject to different dye lots.
We go to great lengths here at Mirth Studio to send only decals that meet our high standards so If you feel you have received a defective product, please contact us immediately and we will send out a replacement.


text:
The ad, which features Abercrombie's famous, bare-torso models taking a trip around famous world landmarks while lip-syncing the pop hit, has been viewed almost six million times since it was published nearly two weeks ago.
The ad was created in-house and has generated 9,500 comments and 320 blog posts.
BMW has entered the chart in second place with a new ad, which juxtaposes classical music with slow-motion shots of its M5 car smashing at high speed through glass apples, targets and popping water balloons.
Created by Cundari, Toronto, the ad has been shared more than 150,000 times this week.
After topping last week's chart, Coca Cola's security cameras have fallen into third place with 74,517 shares, while a Nokia-exclusive trailer for the latest instalment in Christopher Nolan's 'Batman' franchise has entered in fourth with more than 62,500.
Elsewhere in the chart, PBS' remixing of US children's classic 'Mr Rogers' has slumped to sixth place, two weeks after it topped the chart.
The chart, produced in conjunction with Unruly, ranks ads according to the number of times they have been shared on Facebook, Twitter and the blogosphere.
Ads launched more than 30 days ago are not included.
Due to technical issues with Twitter's API, shares from the social network were not included in the count.
1. Abercrombie & Fitch 'call me maybe' created in-house
429,899 shares this week
All time: 1,300,780 shares
2. BMW 'bullet' by Cundari, Toronto
151,407 shares this week
All time: 176,695 shares
3. Coca Cola 'security cameras' by Landia
74,517 shares this week
All time: 449,629 shares
4. Nokia 'Dark Knight Rises' by Warner Bros.
62,631 shares this week
All time: 340,681 shares
5. Microsoft 'surface' created in-house
33,412 shares this week
All time: 258,829 shares
6. PBS 'Mr Rogers remixed' created in-house
32,790 shares this week
All time: 872,875 shares
7. Mercedes Benz 'the new A Class' created in-house
12,677 shares this week
All time: 31,602 shares
8. Aston Martin 'a bold new breed' created in-house
8,893 shares this week
All time: 17,742 shares
9. Coca Cola 'do that toe tappy' by Ogilvy & Mather
8,216 shares this week
All time: 21,242 shares
10. Nike 'Rooney' by Widen & Kennedy
5,585 shares this week
All time: 78,981 shares


text:
|Site Index
Scotiabank is a leading financial services provider in over 55 countries and Canada's most international bank. Since welcoming our first customers in Halifax Nova Scotia in 1832 Scotiabank has continued to expand its global reach. Today through our team of more than 86000 employees Scotiabank and its affiliates offer a broad range of products and services including personal and commercial banking wealth management corporate and investment banking to over 21 million customers.


text: Lysine is an essential amino acid which is critical to animal growth. Its concentration in general animal feed is lower than required, making it the first or second limiting amino acid that is depleted. Lysine is also known for its immunity-boosting performance in hog or poultry raising feed, and when it is added to these feeds, it helps achieve nutritional balance. It provides the feed with the proper quantity of amino acids to reduce the ammonia excretions caused by an oversupply of proteins, thus benefiting the environment. As such, the lysine used by CJ CheilJedang is produced by microorganism fermentation which is a natural resource. This lysine promotes the growth of livestock, reduces the costs for the livestock industry, and conserves the environment.


text:
Chicago Women's Health Center (CWHC) has served Chicago communities with pride for more than four decades. In 1975, a group of health care providers, counselors and health educators, troubled by unjust gynecological care disparities in Chicago, joined together to create CWHC. Emphasizing self knowledge and a peer approach to health care, these early collective members believed that health care was a right, not a privilege, and that gender inequity was a serious barrier to respectful health care. The history of CWHC embodies a dynamic story of the women's health movement and feminism in Chicago. This history and perspective lends CWHC strength and perspective as a leader in reproductive justice and health care .
We are proud of our historical roots which inform our approach and services today. Each time we offer a client a speculum, provide services regardless of a client's ability to pay, or work with a group of middle-schoolers on making healthy choices for their lives, we advance the notion that individuals have both the right to self-determine their health care and the right to affordable services.
As our collective adapts and evolves for today's patient needs, we remain committed to the founding ideals of CWHC. In the early 1980s we were one of the first health centers to provide dedicated alternative insemination services to single women and lesbian and queer families. In the early 1990s, we established one of Chicago's first counseling services that embraced a feminist relational model. Today, our Trans Greater Access Project (TGAP), developed in partnership with the Queer People's Health Collective, offers needed and affordable services to Chicago's trans communities.
Our commitment to complementary medicines and holistic health care has led us to partner with Pacific College of Oriental Medicine, providing us the ability to offer acupuncture on a sliding fee scale. In partnership with Young Women's Empowerment Project, we have helped develop sex education materials for young women involved in Chicago's sex trade and street economies. CWHC continues to adapt and grow as our health care needs and our communities change.
CWHC's flexibility and adaptability has nurtured our slow and steady growth. CWHC has grown from serving hundreds of clients per year in our early days to more than 6,000 clients and student in 2018.We bring the best of our history to the challenges and complexities of the current health care and health education landscape, always working to meet the changing needs and identities of our ever-inspiring community of clients, students, volunteers and collective members.


text:
Shankar Garh, Gauri Shankar Road, Kannauj,
209725 (UP) India,
We, Meena Perfumery, started our mission with an aim to provide complete satisfaction and meet the tastes of our valued clients through superlative products. We manufacture, suplly and export a wide variety of perfums and oil essentials which are in confirmation with the international standards of Valium< quality. our product rang includes perfums and essential oils including Rose Water, Keora Water, Sandal, Khus, Attar Gulab, Sandali Gulab, Ruh Gulab, Kesar Patti, Kesar Oil, Jasmine, Bela, Heena, Gulkand, Seasonal Flowers and many more.
Essential Oil Bulk initiated their mission with a target of offering complete satisfaction. The company believes in fulfilling the requirements of their esteemed customers by providing a rand of superior products.


text:
Jan. 31, 2008
Updated: Photo Gallery from Reunion
It may have been more fitting for the 1977-78 Lady Bisons basketball team to hold a breakfast reunion rather than a luncheon.
Talk to anyone associated with the first ever intercollegiate women's basketball program at Lipscomb University and the time of 6 a.m. quickly becomes a major topic.
"I would sneak doughnuts out of the cafeteria so I would something to eat before our practices," said Julie Kinser Huffman. "I remember we had a lot of injuries that I attributed to practicing so early. We would be so stiff even though we would stretch and warm up."
Eventually the Lady Bisons would make the short drive to Monroe-Harding in order to hold afternoon practices since there was no room for them in the old McQuiddy Gym. Playing with little money and few other resources was everyday life for the 1977-78 team.
• They bought their own shoes and drove their own cars to games.
• They washed their own uniforms after games.
• Their practice clothes, which they had to wear to practice because they didn't have a dressing room, often caused problems.
• If a player needed treatment for an injury she had to be moved to the men's locker room.
• Scholarship money was almost nonexistent.
"I remember being reprimanded for walking across campus to my dorm in my shorts and tank top after a morning practice," said Heidi Overall Block. "Helen Bowers was almost expelled for sleeping in chapel. And one time we ended up in Alabama while we were driving to Memphis to play a game."
The struggles the team endured help to bring them together. In retrospect all of the hardships were worth it to be part of the start of something that is still growing and improving 30 years later.
"The first few years were not easy by any means," said Karen Wallace. "But to see where the program is now makes all we went through worth every minute. I would do it all over again if I had the chance."
They played for the love of the game. The players and coaches and support staff plan to meet for series of events Saturday to commemorate the 30th anniversary of that first season to recall the beginnings of the program.
There will not be a 6 a.m. breakfast, but the members of the team are scheduled to meet for a luncheon at noon in the Hall of Fame room in Allen Arena. The luncheon is for the players and their invited guests. It is not open to the public.
The team members will be introduced at halftime of the women's game with Stetson. Game time is 2 p.m. They will also be recognized during the first half of the men's game which begins at 4:15.
At halftime of the men's game the 2007-2008 Lady Bisons basketball team will be honoring the 1977-78 team with a reception in McQuiddy Gymnasium. At that time a photograph will be taken of the 1977-78 team as well as a photo of both that team and the current team.
"When we played our first season we were not thinking about the fact that it was the first team," said Wallace. "We were not doing it for the recognition.
"We were all happy that we would have the opportunity to play basketball. We all loved the game."
The members of the team were Becky Marler Brandt (Ooltewah, Tenn.); Leasa Slater Clemons (Kansas City, Mo.); Connie Bentley Clower (Kingston, Tenn.); Helen Bowers Davis (Nashville, Tenn.); Jennifer Jones Davisson (Fairview, Tenn.); Lawana Edwards (Nashville, Tenn.); Julie Kinser Huffman (Spring, Texas); Heidi Overall Block (Cheyenne, Wyoming); Cindy Perry Patton (Murfreesboro, Tenn.); Gill Sheppard Reed (Scottsboro, Ala.); Kathy Baker Reynolds (Franklin, Tenn.); Rhonda Bingham Smith (Nashville, Tenn.); Karen Wallace (Nashville, Tenn. and Vickie Clark Yancey (Jackson, Tenn.).
Trish Hodgson Carruth was the first coach.
"Trish was really the reason there is a Lady Bisons basketball team today," said Wallace. "The biggest plus for me was getting to know her. We were truly blessed to have Trish.
"She was the type of coach you dream of playing for, one that teaches you a lot about the game and about life in general. We all learned it's possible to work hard, learn and have fun all at the same time. We wanted to do well for Lipscomb, but our ultimate goal was for Trish to be proud of us."
The first interest in an intercollegiate team began in the winter of 1977. Several women were playing in the intramural league on campus, but some of the players wanted to compete at a higher level.
"It was just a bunch of freshmen that loved to play basketball that got the ball rolling," Wallace said. We had an intramural team that I don't think ever lost a game.
"Trish saw something special and set up extramural games. We played a few local colleges. We even played Vanderbilt. We were so fortunate to be at the right place at the right time."
Some Trevecca Nazarene students mentioned to some Lipscomb women that they would like both schools to play as basketball game. They asked Hodgson Carruth to coach them. She was already the coach of the women's tennis team, but she couldn't turn down their request.
"I understood their desires as athletic competition had played such a beautiful part in my own life," Hodgson Carruth said. "Naturally, we won the game. And that game only served to whet their appetites."
Some of the players asked Hodgson Carruth to talk with the administration about starting an intercollegiate team. She deferred, suggesting that the players and their parents should meet personally with the school's decision-makers.
"The next thing I knew I was being asked if I would coach the team," Hodgson Carruth said.
She suggested that Frank Bennett, a coach and teacher at that time at David Lipscomb High School, should be the coach. Bennett, in his 28th season as the Lady Bisons head basketball coach, can't remember why he did not want the job at that time. At the start of the fourth season Bennett decided the time was right for him to take over the program.
"I was told that the beginning of the program might be delayed another year while it was decided what to do about a coach," Hodgson Carruth said. "That's how I became the coach.
"We made it through the growing pains. We had a lot of heart and desire and players with a love for the game. We had players with wonderful personalities who were also excellent students. That first year was a lot of fun."


text:
Wednesday, May 24, 2006
Green & Black's Ginger Chocolate
After my rave review of Green & Black's White Chocolate (which surprised even me) I got an email from a representative of Green & Black's asking if I'd tried their Ginger bar. They were reading the blog and knew how much I loved ginger! Of course when I said I hadn't seen it in the store yet (Target has a rather limited selection), she offered to send me some. (And some other bars which I'll review in the coming weeks.)
It's a beautiful bar, with the same simple foil wrapping cloaked in a paper wrapper. The bar was shiny with small sections that gave a good snap. It smelled distinctly smoky and earthy. The dark chocolate is 60% cocoa content.
The first flavors I noticed when letting the chocolate melt on my tongue were a rather tart lemon and then a lingering burn of black pepper. Later the rooty, earthen flavors emerged, giving the bar more of a ginger flavor than a chocolate one.
The crystallization of the ginger gives the bar a more distinct graininess. It's also rather sweet. I liked the spicy burn, and I found it very munchable, but the acidity kind of bothered me after a while. (But I have been eating a lot of pineapple lately and may be working with a disadvantaged tongue.)
The integration of the two flavors and textures isn't quite right for me. Don't get me wrong, it's tasty, but I really wanted more essence of ginger and less graininess and of course more of the creaminess and flavors of the chocolate. I do like how generous they are with the ginger, much better than the ratios in the Dagoba chocolate bars I've had (their Chai bar has scant ginger content). I still favor the panned ginger chocolate pieces that I've been getting at Trader Joe's, but if you don't have access to those, this would be a good fallback treat.
I have a few more bars that they sent me to try, so I'll be adding those to the site within the next couple of weeks. On my list is their Caramel, 70% Dark, Hazelnut & Currant and Espresso.
POSTED BY Cybele AT 8:01 am
Next entry: Mel & Rose Wine & Spirits
Previous entry: Kinder Egg
Meticulously photographed and documented reviews of candy from around the world. And the occasional other sweet adventures. Open your mouth, expand your mind.


text:
Event Coverage
NYFW: TIGI's Nick Irwin at Nicholas K PLUS Skull Cap Accessories
The hair for Nicholas K's September 6th show at Lincoln Center for Mercedes Benz Fashion Week had a very sexy '90s grunge feel to it--thanks to TIGI hair lead Nick Irwin for Catwalk.
Sixty-one looks were debuted at NYFW's first official Spring Summer 2012 show--and Nicholas K definitely didn't disappoint. Wedges, rust-colored shorts for men and women, cropped blouses and tanks, and sweater dress-inspired tops were hot on the runway--but the hair looks were really exciting.
As beauty editors, we want to see something unique, something fresh, and definitely not something that covers the hair!
But, when we saw Irwin's skull caps covering the models' heads, we weren't disappointed at all! In fact, it was pretty cool--especially when paired with the two-knot twists on the side.
Even the male models sported the look!
This boho-chic look used TIGI's Session Series Salt Spray for texture and pliable hold, and knots that were looped through elastics.


text:
IN THIS CHAPTER, we're going to explore the central premise of this book: It is almost always the best course of action to make the database perform as much work as possible, thus minimizing the amount of filtering and manipulating data that you do in your programming code. Another way of saying this is that by replacing program logic with SQL logic, it is possible to gain significant optimization benefits. A strong working knowledge of operators, branching, and functions in MySQL, with this optimization goal in mind, is a key part of your database skills.
While the SQL dialect supported in MySQL isn't a complete programming language in and of itself, it does provide many capabilities for manipulating and filtering data. These include logical and arithmetic operators, functions for working with strings and numbers, and branching operators that allow you to make and act on decisions within queries. As you'll see in this chapter, using these, you can create powerful queries and open new optimization opportunities.
We'll start out the chapter by demonstrating that it's possible to replace a lot of your program logic with SQL logic and achieve optimization benefits. Then we'll cover the following MySQL features:
- Logical, arithmetic, and comparison operators
- Math functions
- Functions for manipulating strings
- Date and time functions
- User-defined variables
- Decision-making and flow-control constructs
With the possible exception of the basic operators, these are among MySQL's most underused and underappreciated features.
By the time you've finished this chapter, you'll be familiar with most of these features, and you'll be able to understand their role in optimizing your own projects to improve their performance.
Replacing Program Logic with SQL Logic: A Demonstration
Many application developers don't seem to realize that SQL, while not a complete programming language in its own right, still has a wealth of constructs that can be used to fine-tune queries so that only necessary data is returned by them. Quite often, we've seen cases where programmers will return overly large result-sets, and then filter or modify them in program code.
For example, consider a scenario in which we wish to output to a web page a list of the members of some organization. Let's suppose the member data is stored in a members table that was created using this statement:
CREATE TABLE members (
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
# possibly more column definitions that don't relate to this example…
dob DATE NOT NULL
We want to format the listing nicely as an HTML table with the full name of each member in one of two columns and an age range in the other. Here's one way we could do that using PHP 4:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1″> <title>List All Members With Age Ranges [PHP4 / Logic In PHP Code]</title>
// establish a connection to MySQL, and select the proper database.. .
$connection = mysql_connect("localhost", "jon", "mypass");
mysql_select_db("mydb", $connection);
// get the current year for the age calculation below…
$year = (int) date("Y");
// submit a query…
$query = "SELECT firstname, lastname, dob FROM members ORDER BY lastname";
$result = mysql_query($query);
<!– begin table display –>

MEMBERS BY AGE GROUP

Name	Age Group

// for each row returned from the database…
while($row = mysql_fetch_assoc($result))
// get the year of birth from the birthdate column
// get the age by subtracting it from the current year
$age = $year – (int) substr($dob, 0, 4);
// determine the age range based on the year if($age >= 65)
$age_range = "Over 65";
elseif($age >= 45)
$age_range = "45-64";
elseif($age >= 30)
$age_range = "30-44";
elseif($age >= 18)
$age_range = "18-29";
$age_range = "Under 18";
// output the resulting age range along with the member's name
echo "
$firstname $lastname	$age_range
n";
<!– end table display –>
NOTE Anyone who is familiar with PHP might wonder why we didn' t use a switch … case block instead of the if … elseif … else. The reason is that Python doesn't have an analogue to the former. And the reason why we care about this will become apparent shortly. So please bear with us.
There's nothing really wrong with this approach (it does work, after all), but notice that we need to process each row of the result set as part of the output loop. Wouldn't it be nice if we could obtain exactly the data we needed from the database, formatted exactly as we would like to use it in the output?
It turns out that we can do exactly that, by moving the formatting and decision-making functionality into the query that we send to MySQL:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1″> <title>List All Members With Age Ranges [PHP4 / Logic in SQL]</title>
// connect and select.. .
$connection = mysql_connect("localhost", "jon", "mypass");
mysql_select_db("mydb", $connection);
// new and improved query, which handles the logic and formatting
$query = "SELECT
CONCAT(firstname, ' ', lastname) AS name,
WHEN (@age := YEAR(CURRENT_DATE) – YEAR(dob)) > 65 THEN 'Over 65'
WHEN @age >= 45 THEN '45-64′
WHEN @age >= 30 THEN '30-44′
WHEN @age >= 18 THEN '18-19′
ELSE 'Under 18'
END AS age_range
FROM members ORDER BY lastname";
$result = mysql_query($query);
<!– begin table display –>

MEMBERS BY AGE GROUP

Name	Age Group

// for each record returned by the query…
while($row = mysql_fetch_assoc($result))
// extract and output the data
echo "
$name	$age_range
 n";
<!– end table display –>
By the time you reach the end of this chapter, you'll be able to come back to this example and see exactly what the complex query does, as well as write your own. For now, just assume that we know what we're doing, and that the end result is the same as in the first example.
This second method has three main optimization advantages. We'll cover each advantage one by one now in some detail, as they support the central premise that we are conveying to you in this chapter. We'll also revisit this example at the end of the chapter.
{mospagebreak title=Optimization 1: Separation of Logic and Formatting}
First, we can separate the logic required for formatting the data that's retrieved from the display loop. This is much cleaner code and makes it easier to modify either the data being passed to the display loop (by modifying the query) or the display loop itself.
For example, if we decide to output the names as lastname, firstname, rather than firstname lastname, we simply change the relevant part of the query to CONCAT(lastname, ', ', firstname) AS name , without needing to touch the PHP code. If we do need to alter the presentation, we can tweak the display code without fear of messing up the derivation of the data or formatting of the data itself.
As an added bonus, you'll often find that your code is a bit shorter as well, because you can write fewer and/or shorter loops.
Optimization 2: Speed
This method is also faster. If you're retrieving only a few records, the difference in speed between these two PHP scripts might not be very noticeable, but increase that number to, say, 50,000 records, and you'll see that the second ver sion executes about 10% to 15% more quickly than the first. Naturally, any improvements you might see in your own applications from adopting this methodology are going to be affected by a wide range of variables, but in an enterprise setting with vast amounts of data and many users, or on a busy web site with hundreds or even thousands of simultaneous visitors, any performance gain you can muster becomes important.
TIP You can often pick up an additional speed boost by making use of the query-caching capabilities available in MySQL 4.0 and later. See Chapter 6 for a discussion of query caching.
Optimization 3: Portability
Finally, this method is also more portable. Suppose we're told that (a) we need to port this script to (just for the sake of example) Python and (b) this really needed to be done yesterday. Which version of the PHP script would you prefer to work from—particularly if you're not a Python expert?
Working from the second version of the PHP script plus a rudimentary knowledge of Python, a copy of the Python documentation, and the MySQLdb module ( http://sourceforge.net/projects/mysql-python ), Jon was able to produce a working script in about 30 minutes (including the time required to download, install, and configure ActivePython and MySQLdb ):
#!/usr/bin/pytho n
import cgi
import MySQLdb
# connect to MySQL and create a cursor
db = MySQLdb.connect(host="localhost", user="zontar", passwd="mypass", db="mdbd") cursor = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
# the same query used in the "improved" PHP 4 example
query = "SELECT
CONCAT(firstname, ' ', lastname) AS name,
WHEN (@age:=YEAR(CURRENT_DATE) – YEAR(dob)) > 65 THEN 'Over 65'
WHEN @age >= 45 THEN '45-64′
WHEN @age >= 30 THEN '30-44′
WHEN @age >= 18 THEN '18-29′
ELSE 'Under 18'
END AS age_range
FROM members
ORDER BY lastname, firstname"
# submit the query and store the result set
result = cursor.fetchall()
# begin HTML output
print "Content-Type: text/html"
print "<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/ loose.dtd">n
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1″>n
<title>List All Members With Age Ranges [Python-CGI / Logic in SQL]</title>n n"
# begin HTML table display
print "
n

MEMBERS BY AGE GROUP
n

Name	Age Group
"
# display result rows in HTML table rows for row in result:
print "
%s	%s
" % (row[0], row[2])
# end table display
print "
"
# end HTML page
print "n"
# end of script
The query does all the hard work of calculation, decision-making, string manipulation, and so forth. This means that the tasks remaining for the script in Python (or whatever language the boss told us to use) are easy to implement, almost trivially so:
- Send the query.
- Receive the result.
- Generate the dynamic output by looping through the result set.
Notice that no heavy-duty parsing, calculation, or string-manipulation code is required; we've already done all that using nothing but SQL. In other words, we've abstracted all of those tasks out of our display code and into the query.
Figure 4-1 shows the output of the Python script in a web browser.
Figure 4-1. Output of the demonstration example
NOTE If you haven't encountered Python before and are interested in checking it out, you can obtain the latest version (Python 2.3.4 as of this writing) for a variety of platforms from either http://www.python.org/ (Unix source code;Windows and Mac OS X binaries) or http://activestate.com/Products/ ActivePython/
(installers for Windows, Linux, and Solaris). You might also want to pick up a copy of Magnus Lie Hetlend's Practical Python (Apress, 2002), which we've read and can highly recommend.
{mospagebreak title=MySQL Operators}
As we stated at the beginning of this chapter, our central premise is that it is almost always the best course of action to make the database perform as much work as possible, thus minimizing the amount of filtering and manipulating data that you do in your programming code. Simply put, a strong working knowledge of operators increases your options when it comes to replacing your programming logic with SQL logic.
NOTE Most of the functions and operators that we'll look at in this chapter can be used in SELECT , INSERT , and UPDATE queries, either as column values or in WHERE clauses. We'll provide you with examples of all of these.
Most of MySQL's arithmetic and logical operators are likely to be familiar to you, as they're more or less the same as you'll find in most common programming languages. So we won't spend a great deal of time with them, but we will go over them and point out their MySQL-specific eccentricities where necessary.
NOTE Like most programming languages, MySQL uses parentheses for grouping to force the order in which operations are performed. You can use these whenever you want to override the normal precedence of MySQL operators, which we'll discuss later in this chapter.
Logical Operators
MySQL has the basic logical operators you would expect to find in any scripting or programming language. The list was completed in MySQL 4.0.2, when support for XOR was added.
Logical operators always evaluate to TRUE, FALSE, or NULL. As we've mentioned before, MySQL doesn't have a Boolean datatype as such; instead, it uses 1 for Boolean TRUE and 0 for Boolean FALSE.
NOT (!): Negates the condition it precedes. Generally speaking, MySQL doesn't care whether you use ! or NOT , so you can write whichever suits you.
AND (&&): In order for an AND comparison to be true, both conditions to be tested must be true. You may use AND and && interchangeably. Note that 1 AND NULL returns NULL , and 0 AND NULL returns 0 (FALSE).
OR (||): Is true if at least one of the operands is true. 1 OR NULL returns 1 (TRUE), and 0 OR NULL returns NULL . OR and || are synonyms, so you can use either of them as you prefer.
XOR (^): Yields a true result if one and only one of the operands is true. Any value XOR 'ed with NULL yields NULL . XOR and ^ are synonyms.
We recommend that you use AND and OR rather than && and || in order to preclude the possibility of accidentally leaving out one of the doubled symbols and so writing a bitwise operator instead of a logical operator.
NOTE Bitwise operators aren't used that often, and we don't cover them here. If you need to find out about them, consult the MySQL Manual or other reference.
In addition, the double-pipe version of OR also serves as a concatenation operator when running MySQL in ANSI mode, and it can be used in this manner in Oracle and PostgreSQL as well.
The rules for resolving expressions containing logical operators are shown as in Table 4-1.
Table 4-1. Truth Tables for MySQL Logical Operators
While you may have seen these before, you may not be familiar with how they act on NULL values in MySQL. Basically, the negation of NULL is NULL , and NULL used with any logical operator and any other value also results in NULL , with one exception: A value of FALSE, when AND 'ed with NULL , results in a Boolean FALSE.NULL values in MySQL. Basically, the negation of NULL is NULL , and NULL used with any logical operator and any other value also results in NULL , with one exception: A value of , when AND 'ed with NULL , results in a Boolean . While you may have seen these before, you may not be familiar with how they act on NULL values in MySQL. Basically, the negation of NULL is NULL , and NULL used with any logical operator and any other value also results in NULL , with one exception: A value of , when AND 'ed with NULL , results in a Boolean .
Arithmetic Operators
As in the case of logical operators, MySQL's arithmetic operators are fairly standard. Here they are, along with a few "gotchas" to watch for:
+ (addition / unary positive): Add two numbers together. A unary plus sign can be used to denote a positive number (basically, it is ignored). Note that, unlike the case with some scripting languages and Microsoft SQL Server, you cannot use the plus sign to concatenate strings! (See the notes about type conversion in the next section.)
– (subtraction / unary negative or additive inverse): Subtracts one number from another. Used with a single number, it causes that number to be negative.
* (multiplication): Gets the product of two numbers. The order of the arguments does not affect the value returned.
/ (division): Indicates a floating-point division: for example, 3 / 5 returns the value 0.6.
DIV (integer division): Indicates an integer division; all fractions are rounded down. For example, 5 DIV 3 returns 1, and 3 DIV 5 returns 0. This operator was added in MySQL 4.1.
% (modulus): Performs a division and returns the remainder. For example, 5 % 3 yields 2. If the first argument is negative, a negative value is returned, so that -10 % -3 and -10 % -3 both return –1, but 10 % -3 returns 1. Note that where ABS(a) < ABS(b) , a % b simply returns a; for example, 3 % 10 evaluates to 3, and -3 % 10 evaluates to –3. You may also use the MOD() function for this; for example, MOD(5, 3) returns 2. Beginning with MySQL 4.1, you may also write 5 MOD 3 instead of MOD(5, 3) .
ABS(N) returns the absolute value of a number: if N is positive, the returned value is simply N; if N is negative, the function returns –N. In case you're unfamiliar with absolute values, we show a quick example here.
{mospagebreak title=Type Conversions with Logical and Arithmetic Operators}
Here are a few rules to keep in mind when working with logical and arithmetic operators in MySQL:
- Any nonzero integer used with a logical operator evaluates as TRUE, even if it has a negative value.
- When used with logical operators, fractional values are rounded to the nearest integer. This means that any N where 0.5 > ABS(N) = 0 evaluates as FALSE. (In other words, any number whose absolute value is less than 0.5 is rounded to 0 when used with a logical operator.)
- When adding, subtracting, multiplying, or dividing a mix of integers and decimals, the result will always be a decimal; 3 * 2.33 returns 6.99, and the expression 2.1 + 1.145 – 3.245 yields 0.000.
- Any string value used in a logical or arithmetic context always evaluates to 0 (FALSE). For example, 'a' AND 1 returns 0 (FALSE) and 'b' + 4 returns 4.
- Any arithmetic expression containing NULL returns NULL . This includes the expressions +NULL and -NULL .
- Division by zero produces a NULL result.
- Operators (like all MySQL keywords) are case-insensitive. So it makes no practical difference whether you write A AND B , A and B , or A && B. However, as stated elsewhere, we generally use uppercase for MySQL keywords throughout this book for the sake of easy recognition and consistency.
While this may all look quite familiar, be aware that what is true in your programming or scripting language of choice may not be so in MySQL. So, if you encounter what seems to be a bug in using arithmetic operators in a query, it may just be that MySQL behaves a bit differently than what you're used to.
Comparison Operators
Like all programming languages, MySQL's dialect of SQL has a more or less usual set of comparison operators, as well as a few unusual ones. The equals sign ( = ) serves as both the equality operator and the assignment operator, and an expression containing it evaluates to TRUE (1) if the operands are the same, and FALSE (0) if they're not. If at least one of the operands is NULL , then the result is always NULL .
As mentioned in our discussion of datatypes in Chapter 2, a special "null-safe" comparison operator, <=> , returns 1 (TRUE) if the arguments are equal values or if both values are NULL , and 0 (FALSE) otherwise. In other words, 1 <=> 1 returns TRUE (1), 1 <=> NULL returns FALSE (0), and NULL <=> NULL returns TRUE (1). (Remember that the NULL value is not equal to any other value, not even itself.)
TIP IS [NOT] NULL for testing whether or not a value is NULL , as discussed in Chapter 3. IS NULL can also be written as ISNULL() ; for example, SELECT ISNULL(1); returns 0. You are likely to find that ISNULL() is more portable to and from other databases than IS NULL or the <=> operator. In addition, MySQL supports the IFNULL() and NULLIF() flow-control operators that can be used in connection with null values, as discussed in the "Branching: Making Choices in Queries" section later in this chapter.
There are two ways of writing the inequality comparator. You may use either != or <>; they're exactly the same so far as MySQL is concerned. The <> notation seems to be more common, and it's what we prefer to use ourselves, but the choice is entirely up to you. (As always, we recommend you choose one or the other, and stick with it.) Note that NULL compared with any value—even itself—using <> or != yields the null value. However, when performing branching operations, you're generally checking to see whether a condition is true or not, and since NULL isn't true, a null result still causes you to follow the "false" branch.
We'll discuss IF() and the other branching operators later in this chapter.
NOTE Both forms of the inequality operator (<> and !=) are standard SQL and supported by most other relational databases.
MySQL also has greater-than, less-than, greater-than-or-equal, and less-than-or-equal operators, which are written (in order) >, <, >=, and <=. These behave more or less just as you would expect. As with the equality and inequality operators, any comparison involving NULL and using one of these operators will always yield a NULL result.
CAUTION Some relational databases provide additional comparison operators meaning "not greater than" (!> or />) and "not less than" (!< or /< ). These are not part of the SQL standard and are not currently supported in MySQL.
There's also a shortcut for determining whether a given value lies within a certain range. The BETWEEN operator is used as shown here.
BETWEEN can also be used with nonnumeric datatypes such as strings. Note that (as usual) string comparisons are case-insensitive unless you employ the BINARY modifier.
Dates as well as strings can be compared.
If the value immediately before the AND is not less than the value following it, then 0 will be always be returned.
NOTE There's an additional operator for use in comparing strings.The LIKE operator allows you to do "fuzzy" matching with wildcards to find strings that are similar to one another. We'll discuss LIKE in more detail in the "String Functions and Regular Expressions" section later in this chapter.
{mospagebreak title=Operators for Working with Sets}
MySQL also has several operators and functions for use with sets of values. The IN operator answers the question, "Does value N match at least one of the values in the set A, B, C, D…?" Here are some examples:
You should note the following points when using the IN operator:
- The IN operator returns 1 if a match is found (as in the first and third examples) and 0 if no match is found (as in the second and fourth examples).
- You can use any datatypes for the value to be found and for the values in the list to be searched, and you can mix datatypes in the list.
- When trying to match a string, comparisons are case-insensitive, unless you use the BINARY qualifier. (Compare the first two examples.)
- MySQL will attempt to perform a type conversion between strings and numerals, and vice versa. Hence, the number 5 is matched by the string '5' in the fourth example (but see the rules in the following "Type Conversions in Comparisons" section).
IN can be used in place of (and is basically shorthand for) multiple OR operators in a WHERE clause. For example, this query:
SELECT lastname, dob
FROM members
WHERE firstname IN ('Bill', 'Mary', 'George');
produces the same result as this one:
SELECT lastname, dob
FROM members
WHERE firstname='Bill' OR firstname='Mary' OR firstname='George';
The IN operator can also be extremely useful when used with subqueries in MySQL 4.1 and above. Let's return for a moment to our members table from the "Replacing Program Logic with SQL Logic: A Demonstration" section earlier in this chapter. Suppose that now we would like to know if any members were born in the year 1961. If you're a programmer, you might have visions of writing some sort of for or while loop that iterates over the dates extracted from a query. Or you might be thinking that you could use something like this to accomplish this task:
SELECT COUNT(*) FROM members WHERE YEAR(dob)='1961′;
You could do that, but you would be getting your original question answered only in an indirect fashion; you would still need to test the result to see whether the result was greater than zero. By using IN and a subquery, however, you can obtain a Yes or No (actually 1 or 0) answer:
SELECT '1961' IN (SELECT YEAR(dob) FROM members);
The inner SELECT returns a list of years, and the outer SELECT looks for a match in that list. By the way, the inner SELECT must return a single column; otherwise,
MySQL will signal an error.
NOTE Subqueries were introduced in MySQL 4.1.We'll discuss them in more detail in Chapter 8.
In place of IN, you can also use a comparison operator followed by either of the keywords ANY or SOME.
We show an equivalent using the COUNT() function and a comparison operator in the same example. This example can be thought of as saying, "Is there some
member whose first name is Bill? Yes, there is someone in the members list whose first name is Bill."
The following query and result can be thought of as saying, "There is not any member whose first name is Andy, correct? Yes, that's correct."
CAUTION Through MySQL 5.0.0, it is not possible to use a LIMIT clause in a subquery following an IN, ANY, or SOME clause.
You can use any of the comparison operators =, !=, <>, <, <=, >, and >= with ANY or SOME. (You cannot use <=>.) Here's an example:
This is equivalent to asking the question, "Do we have any members who were born in the year 1922 or earlier?" and getting the answer, "No."
Finally, you can find the greatest and least values in a set by using GREATEST() and LEAST(). They're used in a similar fashion: each accepts a comma-delimited set of values and returns the largest or smallest value from the set. The following is an example of using both of these functions.
Note that since we've mixed integer and decimal values, the result is expressed as a decimal with a precision equal to that of the argument with the greatest number of decimals.
NOTE The order in which arguments are passed to GREATEST() and LEAST() has no effect on the result.
You can also use the GREATEST() and LEAST() functions with strings:
Both functions are case-insensitive. Although you can use the BINARY modifier with either one of them without generating any errors, doing so has no effect on the result.
It's possible to use both numeric and string arguments in one call to GREATEST() or LEAST(), but all of the strings are converted to 0.
CAUTION In older versions of MySQL (prior to 3.23), it was possible to use MAX() and MIN() as synonyms for GREATEST() and LEAST(), and you may see this usage in older references. This is no longer the case, and attempting to use one of these functions on a set will cause an error.
Finally, there are two functions for working with sets of values: ELT() and FIELD(), which complement one another. ELT() is used to retrieve the value of the element at the specified index within a set. FIELD() finds the position or index of a given value within a set. Each takes as parameters a set of values, all of which except the first make up a list to be tested.
For ELT(), the first element in the set is the index of the value to be retrieved.
The first argument used with ELT() must be an integer; if it is less than 1 or greater than the number of elements in the list, the function returns NULL. Note that using 1 for the first argument will return the first element in the list that follows it. You can think of this function as working like an array index does in most programming languages.
The FIELD() function attempts to match the first argument in the list that follows it. Here, too, the numbering of the list starts with 1.
Note that these two functions are usually employed with lists of strings, but it's also possible to use them with numbers, as shown in the next example.
As you can likely deduce from these examples, the value used for the first argument to ELT() can be a string, as long as that string contains only digits, and the first argument to FIELD() can be a number.
{mospagebreak title=Type Conversions in Comparisons}
Here are few points to keep in mind when comparing values of different types using any of the comparison operators =, <>, !=, >, >=, <, and <=:
- Comparing any value with the null value returns NULL .
- String comparisons are case-insensitive unless you use the BINARY qualifier in the query or in the definition of the column whose value is being compared: 'a' = 'A' returns 1 (Boolean TRUE), and BINARY 'a' = 'A' returns 0 (Boolean FALSE).
- When comparing a string with a number, any leading spaces in the string are discarded, then any leading digits in the string that remains are converted to a number and any remaining (trailing) characters are dropped, so both 5 < '8a' and ' 15x' = 15 return 1. If the string does not begin with a digit, the string is evaluated as 0, so both the expressions 5 < 'a8' and ' x15' = 15 return 0. And 3.0 >= '2f5' evaluates as TRUE (returns 1) and 14 < '311mft7' is FALSE.
- When comparing strings and numbers, if the string (after any leading spaces are dropped) begins with one or more digits followed by a decimal point and then by one or more digits, any additional characters following the second set of digits are dropped; for example, all three of the expressions '3.28' = 3.28, '3.28.6' = 3.28, and 3.28 = '3.28x' will evaluate to TRUE (1).
Operator Precedence
When multiple operators are involved in a single expression, things can get a bit complicated. For example, how should MySQL resolve an expression like 2 + 3 AND 1? Should this evaluate to 3 (3 AND 1 evaluates to 1; 2 + 1 is equal to 3) or to 1 (2 + 3 is equal to 5; 5 AND 1 evaluates as 1)? Of course, you can test this directly, as shown here:
However, it isn't really practical to take the time to do this every time you encounter such an expression, not to mention the fact that, in real life, such expressions are likely to be working with values that aren't known ahead of time. Fortunately, there's a set order of precedence that determines which operations are to be done first.
The order of precedence for operators in MySQL is almost identical to that found in ANSI SQL. Table 4-2 shows the order of precedence from highest to lowest.
Table 4-2. MySQL Operator Precedence
DESCRIPTION Parentheses (force grouping)
+, –; ~
Unary plus and minus; bitwise inverse
Multiplication and division
+, –
Addition and subtraction
Null-safe comparison
=, <>, !=, >=, <=
&, |, ^
Bitwise AND, OR, and exclusive OR (XOR)
Logical negation
Logical AND
Logical OR; set membership; "fuzzy" (wildcard) comparison
<<, >>
Bitwise shift
Variable assignment
If you want operations to be performed in some other order, you can always force the issue by using parentheses.
When evaluating complex expressions involving parentheses, MySQL follows what's sometimes known as the "inside-outside" rule: operations inside the innermost set(s) of parentheses are performed first, followed by the next set outward, and then by the next set outward from that, and so on. If you've written code in practically any other modern programming or scripting language, you should be used to this already.
Please check back next week for the second part of this article.


text:
Welcome to the Learning Commons
The Learning Commons is a welcoming place where students can meet with a tutor, study group, or instructor. The Learning Commons is equipped with state-of-the-art computer technology available for your use. Is the Learning Commons the same as the RRCC Library?
Though we are housed in the same building area, and we often collaborate with one another, the Learning Commons is not to be confused with the Marvin Buckels (Campus) Library which is located on the second floor. Both the Learning Commons and Library are located at the east end of the Lakewood Campus. See our services below.
At a glance.
Accessibility Services
Provides advocacy, assessment, direction, learning skills, and school-to-employment transitioning for people with disabilities (including learning disabled).
Career Success Center
Visit the Career Success Center to learn about yourself, explore career options, and research occupational information through exploration; learn how to gain more experience through experiential learning; and tap into employment search skills through employment services.
College Prep Zone
The College Prep Zone offers tutoring for students taking college prep classes. If you are taking CCR 092 or 094, or MAT 050, 055, or 107, this is the place for you.
Communication Lab
Located in the library in room 2264, the Communication Lab is designed to tutor students across the curriculum in all stages of oral presentations.
Computer access for all students
All the computers in the Learning Commons, PCs and Macs, are open for use to all RRCC students and staff.
Connect to Success
Offers navigation and success strategies to reach academic, career, and personal goals.
ESL/Foreign Language Lab
Resources for English as a Second Language students and Foreign Language Students
International Education
Provides college preparatory English classes for international and resident students for whom English is not a primary language. Also provides academic and cultural advising for a diverse student population, and specific immigration advising for International students.
Learning Collaborative
Do you need additional help preparing for an academic placement test? The Learning Collaborative can help increase confidence and skill in math, reading and writing.
TRiO Student Support Services Program
Located in room 1258, TRiO provides services to participants that will guide and assist in completing their academic goals.
Walk-in tutoring in math, writing, sciences, accounting, and other courses is free for Red Rocks students.
Walk-in or Online Writing Center
Located in the northeast corner of the library, room 2257, the Writing Center offers strategies and resources for succeeding in any kind of writing assignment, including essays, term papers, and essay exams. Tutors are available at the Lakewood and Arvada campuses. Assignments can also be submitted online


text:
Quality Inn
Quality Inn offers easy access, approximately nine miles south of GVSU Allendale Campus off I-196 and the 32nd Ave exit. A complimentary continental breakfast, indoor pool and whirlpool are provided. Rooms have coffee makers, hairdryers, irons and ironing boards. AAA 3-diamond rated.
Quality Inn
3301 Highland Drive
Hudsonville, MI
$70 - 120
Number of rooms: 58
Wireless Internet access / Indoor Pool / Exercise Facility / Barrier Free / Special Packages / Whirlpool & Sauna / Whirlpool Suites / Complimentary Breakfast
(616) 662-4000
Fax: unknown
GVSU Contract Rates
General Manager:
Lorianne Dys - Danee - 2014 - Denee 7-21-14 last update
Email Address: email@example.com
Account Number: N/A
Contract Number: N/A
Contract Term: One Year
Expiration Date: unknown
GVSU Contract Rate:
> GVSU Rate: No special rates available for GVSU at this time.
Terms and Conditions:
> Direct-bill charges for University guests: Contract/PO number, guest name, host department, and contact person must be provided when booking reservations. > Only room and applicable taxes will be direct- billed unless specified otherwise. > Rate available for standard queen and king size rooms. > GVSU rate is not available for booking on the web site. > GVSU Rate: Available for guestrooms direct-billed to the University and University business guests responsible for paying their own charges.


text:
Jagan died at the country's state-run Georgetown Public Hospital of an abdominal aneurysm, according to government officials.
In 1963, Time magazine called her "the most controversial woman in South American politics since Eva Peron," partly because she was a "strident Marxist" who many believed was the "brains and backbone" behind her husband's leftist government.
Her husband, Cheddi Jagan, a Guyanese descendant of Indian immigrant sugar-plantation workers, was premier of what was then British Guiana.
"I'm an activist," she told the magazine, denying that she was overly influential. "People either hate me to infinity or love me to death."
She was a 77-year-old recent widow when she succeeded her husband as the country's president in 1997. On his deathbed, he reportedly asked her to "carry on."
Elections in Guyana have often been disputed and volatile. Citizens of East Indian ancestry usually back the party that has ruled since 1992, while those of African descent historically vote for the opposition People's National Congress.
When Jagan was elected, the results were disputed and her victory was not declared for days. Her presidency lasted 20 months and was plagued by opposition protests. She resigned in 1999, weeks after having a heart attack.
Donald Ramotar, general secretary of the People's Progressive Party, told Agence France-Presse on Saturday that "she gave all her life to the struggle for Guyana's independence and democracy."
She was born Janet Rosenberg in 1920 into a middle-class Jewish family in Chicago. She met Cheddi Jagan, a dentistry student, at Northwestern University. She quit nurse's training at Chicago's Cook County Hospital and defied her parents to marry him in 1943.
They soon moved to British Guiana, intent on starting a socialist revolution. He set up a dental surgery practice and she was his assistant. The couple quickly became involved in labor politics and helped found the People's Progressive Party in 1950. She was the party's first secretary-general, a post she held for two decades.
During civil unrest, the Jagans were arrested in 1955 and held as political prisoners for several years, largely because of their communist leanings.
First under British rule and then after Guyana gained independence in 1966, she served in a variety of roles, including in Parliament and as minister of home affairs, of labor, of health and of housing.
"Thunder in Guyana," a documentary by a cousin of Janet Jagan's that aired on PBS in 2005, tried to explain how a Midwestern Jewish woman ended up trying to change the world in Guyana. One relative said she did it for love.
Then in her 80s, Jagan said in the film that her identification with the underdog could have been the result of growing up Jewish in America.
Jagan had two children and five grandchildren, according to her website.