text:
Q: Retrieving values of a linked component in Dreamweaver TBB - and making it SiteEditable I am working on Dreamweaver TBBs in SDL Tridion 2011 SP1.
I am unaware of handling component links in Dreamweaver TBBs.
Consider my Component name is "A" which has link to another component "B".
Component A source looks like this:
<Content xmlns="Some UUID">
    <Name xlink:type="simple" xlink:href="tcm:184-1897"
          xmlns:xlink="http://www.w3.org/1999/xlink" xlink:title="B"></Name>
</Content>

Component B source is:
<Content xmlns="Some other UUID">
    <first>first field</first>
    <second>second field</second>
</Content>

I want to write a DWT TBB which can access the fields in the linked component B from Component A.
I want to use RenderComponentField rendition method.
Do I need to add any extentions to it, will I be able apply SiteEdit on it.
Please share your views on it.
Thank you.

A: There are two separate questions in this topic:

*

*How to access fields from a linked Component in DWT?

*How to make fields from a linked Component editable in SiteEdit 2009?
This is the answer to question 1. I will provide a separate answer for question 2.
In Tridion's default handling of expressions in DWT templates you only have access to fields of Components that are in the package. So if you want to access the fields of Component B, you will have to write a C# TBB that pushes that Component into the Package.
A sample C# fragment:
var componentA = (Component) engine.GetObject(package.GetValue("Component.ID"));
var fieldsA = new ItemFields(componentA.Content, componentA.Schema);
var linkField = (ComponentLinkField) fieldsA["Name"];
var componentB = linkField.Value;
var itemB = package.CreateTridionItem(ContentType.Component, componentB);
package.PushItem("ComponentB", itemB);

If you put this in a C# fragment TBB and drop it into your CT before the DWT, you can do this in your DWT:
@@ComponentB.Fields.first@@

Alternatively you can use Nuno's Dreamweaver Get eXtension (DGX) to access such fields without writing a TBB:
@@Get("Fields.Name.first")@@"/>

The only downside to using the DGX is that you will need to install it on every Tridion server. After that, a heap of extended functionality is available in your DWTs.

A: Allowing fields of a linked Component to be editable has been introduced in SiteEdit 2009 SP2. The SiteEdit front-end works based on the SiteEdit command language that is embedded into the HTML it gets back from the staging server.
So let's say you have a single Component in there:

    Title:

        Tips for getting insurance when you have a pre-existing condition

Those Start SiteEdit comments in there are commands that your HTML gives to SiteEdit and you can see how they mark the Component Presentation and the title field.
If you render fields of a linked Component, you need to also have a corresponding Component Presentation command like this:

    Title:

        Tips for getting insurance when you have a pre-existing condition

        Byline:

            "It's a huge problem, because ..." says one expert.

        Copyright:

            Getty Images

The there are now two Start SiteEdit Component Presentation commands, one for the outer Component and one for the linked Component. One important thing to note here is that the IsQueryBased property of the nested Component Presentation must be set to true. This tells the SiteEdit front-end that the Component Presentation is indeed not supposed to be present in the Page XML it retrieves from Tridion.
To the SiteEdit front-end it doesn't matter how the commands are put into the HTML.
Most common is for people to call RenderComponentPresentation and RenderComponentField, which marks the corresponding parts. But unfortunately the RenderComponentField function can only be used to render fields from the so-called "context Component", which it looks up like this:
Item component = _package.GetByType(ContentType.Component);

This means that in a single DWT all calls to RenderComponentField will work on the same context Component. So you can never call RenderComponentField in a single DWT to render fields from two different Components.
You have two options to solve this:

*

*Call RenderComponentPresentation for the linked Component

*Render the Start SiteEdit Component Presentation and Start SiteEdit Component Field commands yourself in the DWT

Option 1 is the cleanest separation you can get: since you are rendering fields from another Component, you are essentially rendering another Component Presentation. If you split out the layout for the linked fields into a separate DWT and build a CT around that, you can render it like this in your main DWT:
@@RenderComponentPresentation(Component.Fields.Name, "tcm:1-2-32")@@

Walter explained this best in his article on Tridion templating:

Since the scope of this Dreamweaver template is limited to displaying the current component fields, an extra step is necessary by using the RenderComponentPresentation function. We need to pass the TCM URI of the multimedia component to this function, together with the TCM URI of another Dreamweaver template.

Although it does lead to more CTs and DWTs, those DWTs will be a lot simpler since you can now use RenderComponentField in them as usual.
Option 2 really just means that you're outputting the HTML comments with the SiteEdit commands in your DWT. Since the command language is documented as part of the API (see link above) there is little chance that it will change in future versions of SiteEdit 2009.
Sorry for the long story, you happened to trigger a tricky use-case here. I hope it makes sense.

A: If you are using SiteEdit 2009 it is possible, just a bit more difficult than it would be with the main component fields. SiteEdit works by wrapping the content fields with JSON markup. There's no reason why you can't detect if the publication target is staging and write this JSON out yourself.
Alternatively Will Price has developed some Template Building Blocks to help with SiteEdit which are available here.
These are accompanied by a guide here, specifically the section on embedded components will be of use to you.

A: You cannot read the fields from B using standard Dreamweaver templates. You will need to write a C# TBB to extract the linked Component and place it in the package as type Component. You then can use DWT syntax to read the fields from that component. Eg: @@linkedComponent.Fields.first@@
Siteedit is problematic on this one and different versions use different syntaxes and capabilities. I'm afraid with the latest version you cannot edit such fields...


text:
Whitwick Historical Group
Ashby Tourist Information Centre
Information for Group Tour Operators
Conference & Meeting Room Venues
The history of Whitwick
The story of Whitwick since the Norman Conquest of 1066, is inextricably linked to the Lords of the Manor and seems to be one of exploitation, absentee landlords and underage heirs, although it's history goes back in time to an Anglo-Saxon second stage settlement about 700AD. The name is most likely derived from the Anglo-Saxon word "hwita" meaning white and 'wic' meaning outlying farm possibly started as a forest clearing known as an assart.
Unusually, the Doomsday entry for 1066AD does not tell who administered the land before the Conquest, but clues point to the powerful Earls of Mercia. Lady Godiva of Coventry, wife of Earl Leofric, reputedly rode naked through the streets to save the people from excessive taxes. Lady Godiva is still Lord of the Manor of Coventry and Norton (Juxta Twycross), Appleby (Magna) and Bilstone, nearby in Leicestershire.
There have been a number of attempts to produce a definitive narrative of Whitwick's early history and the earliest by John Nicholls in his Historie and Antiquities of Leicestershire still stands the test of time as the best secondary source available to date. There have been a number of writers on Charnwood Forest, which include Whitwick and the best of these is George Farnham, for he is meticulous and thorough in his preparation. His notes on the Mediaeval Villages of Leicestershire, now deposited with the Record Office for Leicestershire, Leicestershire and Rutland (ROLLR) at Wigston Magna, are his direct translations of the original abbreviated Latin documents now held at the National Archives, Kew. These give vital details about all kinds of events from the mediaeval period for the whole of Leicestershire. However, as individual items, these need further investigation to fit them into the wider picture of local history and Whitwick in particular.
In 1984 'A Brief History of Whitwick' by Sheila Smith, published by Leicestershire Libraries and Information Service, remains a good general introduction to Whitwick's history but her chapter on the early history now needs updating since our current research into this period, especially the associated histories of the Lords of the manor, indicates links to national events.
Very few Whitwick Historical Group members are interested in this particular period of research, which is difficult and time consuming but Whitwick Historical Group's Vice-chairman Maureen Cowell Partridge has gathered a considerable amount of information about the Lords of the Manor, which simply raises even more questions waiting to be resolved. (The group would welcome anyone interested in this particular period of history).
It was poetic justice that Sir John Talbot was probably buried at Whitwick by the vicar he had assaulted.
Old Station & Railway
Whitwick railway station was built by the Charnwood Forest Company, serving the Charnwood Forest Railway, and was officially opened with the rest of the completed line on April 16, 1883. Following the closure of passenger traffic (aside from a few specials and other organised events) in 1931, the station building became a blacksmiths. Following total line closure in 1963, the history of the building is more difficult to chart. However, it is apparent that the waiting rooms and other facilities on platform level were demolished in the mid-1970's. Whitwick Historical Group was created in 1983, meeting at The Black Horse public house, later they moved to the old station building which is still their home.
The building is situated close to the village's Market Place, which is essentially the centre of the village, on North Street. The trackbed between Coalville (starting at Morrisons) and Whitwick (terminating just past Whitwick Station) has been turned into a public right of way. This passes the station building and the remains of the platform, which sadly, although intact, is overgrown and unkempt. All that remains now is the landing at the road entrance.
Spring Hill Farm
Spring Hill Farm Whitwick was once a favourite picnic area for families from the Whitwick area. It was the venue for many Sunday school outings even before the First World War, teas were served in the barn then and afterwards frolics and sports took place on Spring Hill itself. The Spring Hill Farm tea room heyday was between the two World wars, there were wooden beams and biblical quotations on the walls.
People travelled to Spring Hill in the early days by Wagonette and later by bus or cycle. Whitwick families would walk up Leicester Road and climb the steep steps known locally as Bilberry Hill; you could see the farm, the ice cream van at weekends and bank holidays and in the distance Gunn Hill. The farm could also be reached from Loughborough Road or Abbey Road.
The tea room was eventually closed by the public health officer because it had no piped water, this ended the happy times in the tea room but the farm lived on with its name advertising teas faintly seen on its roof and walls.
In the school summer holidays local children would take jam jars to collect bilberries and if they hadn't eaten them all by the time they arrived home a delicious pie would be made for tea. Their fingers, mouths and teeth would be stained with purple Bilberry juice a sure sign they had eaten their pickings.
Today the farmhouse and 'Bilberry Hill' have gone, only the memories are left. The land is now part of the Whitwick Granite Company.
The Park King George's Field
It is appropriate that the fields known as Ivy Woods (also known as Ivory or Hervey Woods) should be the site for Whitwick Park. For many years the children from Church Lane, North Street and Brooks Lane had used it as their playground.
In the early 1900s H. Seal & Co. built a factory fronting onto Church Lane on part of the ground. The fields behind the factory were still used as a children's playground. Conveniently, a footpath ran from Church Lane to the fields, providing easy access for the boys who played football or cricket depending upon the season. By the 1920s, the Whitwick Imperial Football Team (the Imps) was using the ground and was well supported by the local community.
The Mining Industry Act was passed by Parliament in the 1920s enabling a fund to be set up for the well being of workers in the coal mining areas. Mr. Dennis Otter requested that a recreation ground be provided for the people of Whitwick from this fund. After much discussion and deliberation, the land was purchased from the brewers, Shipstone's, who also owned the Duke of Newcastle inn on North Street. Coalville Urban District Council agreed to take over the running and maintenance of the park and soon the plans were drawn up.
The Silver Jubilee of King George V and Queen Mary was celebrated on the 'Duke's field', the year before the Whitwick Park came to fruition.
In the year 1939 and in memory of King George V, a heraldic plaque was designed by Mr. George Gray, which was to be displayed at the entrance to all fields established under the King George V Fund. The fund donated £600 towards the design and manufacture of the plaque. From then onwards, the Whitwick Park was officially named 'George V Fields'.
Eleven years after the Silver Jubilee celebrations held on the 'Duke's Fields' the community was bought together again to celebrate the end of the Second World War on what is now known as Whitwick Park.
City of Dan
The City of Dan stands at the bottom of Leicester Road, now an open area where the Whitwick Colliery winding wheel stands.
The name 'City of Dan'. How did it get its name? Neither by research or speaking to older residents of Whitwick do we know.
It would seem that at the time it received its name, the survey maps available show a cluster of buildings in this area, and when talking of a city, one immediately thinks of a concentration of houses and other buildings. In the research that has taken place the following facts were brought to light. There were fourteen numbered buildings on that section of Leicester Road and eighteen residential buildings in the City of Dan. Included there were two public houses, pig sty's, slaughter houses, barns and a small workshop. If aerial photographs had been taken in those days it would have looked like 'A place within a place', this is one reason that can be found to give some credence to the name of City.
An issue of the Loughborough Echo in 1939 included a comment from George Parker of Whitwick, he said the City of Dan was named because a man named Dan Williamson resided there and left for Salt Lake City.
In the Coalville Times in 1945 Lavengro reported that Mr Thomas Aris said that the City of Dan was named after Dan Frearson, a well known Latter Day Saint, who held a number of regular meetings in the neighbourhood. He had a son Dan junior and the whole family went to Salt Lake City. Researchers at Salt Lake City say there are no records saying that early members that left Whitwick to go to Utah have the name Dan.
Gunn Hill
Gunn Hill, known as the haunted house was built by Kirby Fenton with local materials. It was the Gamekeepers cottage and is now part of the De Lisle estate. Eric and Nellie Cook were the last inhabitants leaving in 1950.
Did your family live at the City of Dan?
BURBANK Mrs MOORE Edward WILLIAMSON N 1922
MOORE Mrs LACK John 1887 MOSELEY Edward 1940
BRADSHAW Amy SMITH Francis 1887 HUTCHINSON John 1943
BURTON Eric & Kath OTTEY Mary 1889 LYDALL Henry 1943
GREASLEY Mr WILLIAMSON Horace 1889 FAIRBROTHER William 1948
WARD Joseph 1876 WILLIAMSON Arthur 1891 FINDELL William 1948
BRIERS Edward 1876 HARPER Mrs 1891 SHAW Edwin 1950
JENNINGS John 1876 MANCINI Jane 1909
RAWSON William 1950ROOM John 1876 MANCINI Arthur 1909 WHITE Kim 1952
OLIVER William 1876 HAWLEY Mrs 1909 SMITH Roy 1953
NEALE Francis 1876 OTTEY William 1909 YOUNG Roy 1957
STORER Elizabeth 1876 HARBUCK Mannam 1910 MIDDLETON Colin 1960
WEST Thomas 1876 HARPER Mr 1910 WALDRUM Charles 1960
FREARSON William 1876 BACKWELL C 1914 COOPER Charles 1960
ALLGOOD Landley 1876 SADLER Mr 1914 CARTLIDGE Colin 1960
HALL Thomas 1876 SMITH C 1914 BEESON Joseph 1960
SHARP Joseph 1887 MILLS Mr 1914 CLARKE Albert 1961
SPRINGTHORPE Andrew 1887 STANLEY Mr 1914 PARKER John 1963
KIDGER Mr 1887 FRASER Mr 1914 HICKEN Herbert 1964
BRANSTON Joseph 1887 PARES Allen 1914 SQUIRES Edward 1964
CUMBERLAND Charles 1887 HURST Samuel 1918
HODGKINSON Elizabeth 1887 TUGBY Joseph 1920
The lodging house building on the right was run by John Casey and John Hodgkinson in 1888 and later ran by Elizabeth Hodgkinson. Elizabeth was recorded as living in the lodging house and the others were listed as lodgers.
LODGERS IN 1891
GIBSON George CLIFF George CLARKE Ben
REYNOLDS Ellen BOFFEY James EGLESTON John
BARON Rueben SMITH James CROSS Thomas
SMITH George SMITH Ann Henry.
WRIGHT George WRIGHT Caroline
CROSS Jane REYNOLDS Herbert
LODGERS BETWEEN 1934 AND 1959
ATHERTON Bill MULLINS Frank SHAYNE Mick
MARTIN Danny MULLINS Fred WARD George
EYETIE Jimmy TRANOR Patrick GORMAN Patrick
PRICE John (Juggler) COOPER Henry CHAMBERS Sam
DAVIS Henry (Hummy) DOWNING John WILEMAN Joe
DAVIS Jim DOYLE John MARTIN Charles
HILLIARD Arthur (Candles) ELSE George FISHER Fred
DUNAGAN Lanky HARTLE John
KERRY Joe HUGHES Alfred NICK NAMES FOR THE LODGERS
ROWLEY George KENNY Thomas Joe Soap
BEESON Enid LOWE Thomas Nugger George
THACKER Walter MURFIN Bill Windmill Joe
SHANNON Bill ROACH Patrick Happy Jack
Finally JackaBill, I wonder what his real name was, Jack or Bill - or neither?
The last keeper of the lodging house was Teddy Eggleton running from 1934 until 1959 when the lodging house was closed. There were twelve lodgers left who were transferred to Shardlow.
Teddy Eggleton was moved in to a Council Flat at Greenhill where he lived until he passed away. The council emptied his rooms and his belongings were thrown into a skip. There was no one to look after a man who had done so much for others.

redpajama_set_name: RedPajamaCommonCrawl


The Tripod – An essential piece of gear for the landscape photographer. We all love locking those cameras into place to get that perfect razer sharpness. While getting a shot using the tripod is certainly ideal, I have found myself in multiple situations where reacting to the weather, conditions, and light in a split moment would have only been possible by ditching my tripod entirely and going… HANDHELD. And I did just that and got the shot. Not just some simple point and click, one off exposure, but complicated images involving focus stacks, exposure brackets and focal length blends! Here are some tips that could help you feel better prepared to take a chance at losing a little bit of sharpness in exchange for getting the fleeting moment captured.
First and foremost is to be open to the possibility that something is going to happen to entirely change your approach in the field that day. An example for a shot of mine is this shot from Cinque Torri. I had a comp other than this one all set up and ready to go. But then I noticed the light shining through the rock spires and playing beautifully with the flowers and grass… on the OTHER SIDE OF THE MEADOW. It was moving fast, and I saw the flower patch it was headed for. I had no time to try and set up my tripod again, so I snagged the camera off of it and went running across the meadow with only moments to spare to fire off a 5 shot close up focus stack of these flowers as the sun JUST started to shine on them. The light never hit my first comp the same way it did this, so it was a great call.
Second, be open to not having perfectly aligned exposures to make post processing quick and snappy. Were the exposures for this shot perfectly aligned? Nope. Was there really painful blending that needed to be done to fix minor shifts in perspective from the little movements my body made as I fired off 5 shots? Yes. And it took some time, and some ingenuity. But I did it, and I think it was worth it.
Be mindful of the 2x focal length = shutter speed rule, and use ISO to compensate. Sometimes in the low light at the end of the day, getting a fast enough shutter speed with a low ISO is not possible. Don't be afraid to push the ISO at the expense of some image quality. Is the image going to speak to you? Is the light great and the composition spot on? So what if you get a little noise from a higher ISO. Do what you have to do to get the shot. Zero noise and perfect sharpness do not make great images. Vision does.
Stay tuned for more about this topic!
Ted Gore is a landscape photographer based out of Los Angeles, California. He was awarded the title of USA Landscape Photographer of the Year for 2015, judged by a panel of highly regarded landscape photographers such as Marc Adamus, Art Wolfe, Charlie Waite, and others. He has a sophisticated style of photography characterized by a combination of ambitious compositions and seductive processing. His love for the outdoors has led him to complete the Appalachian Trail and the John Muir Trail in their entirety, and this sense of adventure regularly leads him off the beaten path in search of compelling and unique images. Ted leads workshops across the globe and also provides processing instruction. His creative output also includes projects in the motion graphics industry, which gives him a breadth of expression and a unique multidisciplinary perspective that informs all of his creative and instructional endeavors.


We have all read the headlines and gasped at the accompanying photos of botched cosmetic procedures – but, when it comes to choosing to undergo surgery or even a less invasive treatment, how do we now how to avoid falling into the same trap as these other victims?
Any aesthetic procedure is not without risk – and your chosen practitioner will talk you through both the benefits and the dangers.
But, there are a number of ways in which you can help yourself and lessen the possibilities of treatment going wrong or delivering unexpected results.
It is far better to be educated and cautious than ignorant and reckless, so here we offer some tips to help you avoid the pitfalls.
Do remember that not everyone is suitable for all treatments. Firstly, you cannot always realistically achieve the effect you may wish for. Secondly, a practitioner may turn you away if you are suffering serious health problems, such as high blood pressure or heart disease or suffer with psychological challenges or depression. Other factors that will be taken into consideration include your alcohol intake, whether or not you are a smoker, taking certain medications or supplements, how much you exercise and your weight. Your health will be assessed during the initial consultation so be prepared to be honest. It is in your best interests and anything that will impact negatively on your recovery following surgery will be taken into consideration. This may mean quitting cigarettes, for example.
Do your homework. If you are reading this, then you have already taken a step in the right direction towards safer cosmetic treatments. Our website has some of the most experienced and well respected practitioners in the UK as members. You can view profiles of clinics and clinicians, discover what they specialise in, see 'before and after' photos as well as hear from patients just like you who have undergone similar aesthetic procedures. You can also be guided by our special Comparethetreatment.com expert panel, who are happy to answer any of your queries. Spend time settling on the right practitioner to suit you. Remember, like anything in life – right person for the right job.
It's all in the prep – and the after care. You wouldn't turn up at your own wedding without spending time choosing the venue, the caterers, the photographer and the music, without getting your hair just so, your make up and dress (or suit) perfect or without a honeymoon booked and so on… Likewise, cosmetic surgery is not an impromptu decision. It should be given the same consideration as any big purchase or major milestone in your life. Take your time and ensure your mind and body is well prepared for any procedure you have chosen. Ensure you are fit mentally and physically and understand the consequences of any major surgery. Recovery time may require a number of weeks off work, specific demands upon you regards sleeping, exercise, diet or medication. You will be required to attend follow up appointments and, should anything go wrong, you may require further treatments. If you have a long recovery period, arrange for family and friends to rally round. Additionally, choose a time of the year that suits you best when it comes to time off work. Christmas and New Year are popular as are the summer holidays – although, take note that sun exposure may be problematic with certain procedures.


I'm not sure what my problem is (no comments from the peanut gallery please) but I just cannot get motivated to post on our blog. Quite a bit has gone on in the last month or so. We've finally got our house on the market (fingers crossed for a quick sale!), I've been working on potty training Amelia (don't get me started), Easter and so forth. We've had some fun weekends meeting up with my old roommate Risa and her husband Bryan and last weekend Catherine came down to visit.
Adjusting to our new routine here in Beaufort is going pretty well. Amelia has been waking up at 6:30 in the morning and I DON'T like that at all. The girls have been sicky sicky this last week, and unlike previous boughts of illness, the girls actually slept well (instead of less) during their illness. I'm definitely enjoying having cable. One of my new favorite shows is "Say Yes to the Dress" on TLC. Love it! I feel like I'm apart of cultural America now. On that note, I'll leave you with a couple pictures of my completely adorable girls.
Hurray! I'm so glad you posted and changed your background!! It looks great. And I love the pics of the girls. Can't wait to visit again. It's so nice down there.
I am glad you posted. I check almost everyday. But then, I have no room to talk, since I have equally as difficult time making regular posts. The girls ARE adorable and I can't wait to see you all in two weeks!! Oh, and I Love the background.


LAKIN Custom Plate Brackets™ is a small business located on the North Central Coast of Tasmania, Australia, in the town of Ulverstone.
I had been looking forward to the day – you know the one. I was going to take delivery of of my new car – the Audi I'd been working towards for some time. I'd looked, compared, ordered, paid, waited and finally it was ready to be picked up from the dealership. They drive my baby out in all its gleaming glory. The salesman points out all the special features; aiming to impress me with the build quality and attention to detail inside and out. I transfer a few articles from my trade to the boot of my new pride and joy.
A box of chocolates from the dealer and he closes the boot for me. Rattle, rattle, boing!...What the hell is that? It seems the number plate is loose! Well...not really loose - just that it's only held on by a couple of self-tapping screws in the top edge. I have a closer look. I can hardly believe it; they've drilled holes right through the boot! Did they ask me? Did they consult me about positions or alternatives? They certainly didn't tell me that the most they were prepared to pay was less than $10 for plate covers in an attempt to cover up the butchery! Had they even considered an alternative?
My brand new car! They've just drilled right through it! The rattles were there from the start and my outrage just grew and grew. Speaking with friends and colleagues, it became obvious I was not alone in my feelings about this.
I was frustrated, but then I got creative, and designed the world's best Custom Plate Brackets that allow you to use the manufacturer's mounting points, without having to drill holes in your plates.
"Hi Philip, have installed the plates, very happy thanks, now i need a set of brackets for my wife's Captiva, 2009 model for heritage plates, please tell me what to order."
The brackets and covers have just arrived, well packed and the covers are an excellent fit for the plates. With all the instructions so clear there should be no problem fitting and I should be mobile again quite soon. Many thanks for your very pleasant service, it has been a pleasure dealing with you.
A few weeks ago you supplied front and rear custom brackets for my new Skoda Octavia RS.
I am thoroughly impressed by the quality. THe fit was perfect and the finish is spot on too.
My only criticism or suggestion would be to make the plate a few mm larger than the number plate. It seems a shame to have such a nicely finished product hidden behind a tin numberplate.
I received my bracket today and it fits perfectly. Just a quick e-mail to say many thanks for your excellent service and fast delivery. I will be recommending your business to my family and friends.
Plates received and fitted. I'm absolutely delighted with the results, particularly for the back plate - photos attached. Seeing plates on the car that are the right size and properly fitted is the perfect finishing touch. Having the brackets & screws in black makes it look so much better!
I fitted the brackets and covers today, and just wanted to say how pleased I am. Everything has been excellent - the product, packaging, instructions and service.
You might like to check the Photo Gallery. As customers send me photos of their vehicles with LAKIN brackets or Kingpin covers fitted, I add them to the gallery. While you may not find exactly your vehicle/plate combination pictured, you will get a fairly good idea of the range of situations I can provide brackets for.
The range of brackets offered increases week by week. If you need something which is currently not listed on this web site, just let me know. Even if I don't have access to exactly the same make and model, I'll work with you to manufacture a set of brackets to suit your needs. I don't charge any extra for this totally personal service. Contact Philip here.
I hope I am able to help you soon.


In today's episode, Bigg Boss asked the housemates to welcome new guests. By saying this, Bigg Boss actually promoted a new upcoming show of Colors television called "Saleem Anarkali Ki Prem Kahani" which would be on air from October 01, 2018.
It was then shown that Jasleen Matharu was talking to Anup Jalota regarding Dipika Kakar. She was saying that Dipika gets on her nerves and both of them were not having good relations with each other anymore. Anup being the elderly did the right thing and asked Jasleen to end this up. Jasleen stood up, went to Dipika and hugged her.
Bigg Boss then announced that all the housemates should be statue until the next announced. It was then mentioned that Vikas Gupta, one of the most famous contestants ever in the history of Bigg Boss, was coming to analyze the housemates' performance up till now. Vikas then came and analyzed each housemate turn by turn. He said to Karanvir Bohra that he was doing good in the house but he could be even better.
To Srishty Rode, he said that she was not being seen anywhere in the house and needed to do something. He said to Urvashi Vani that she was brilliant and extremely natural. Vikas hugged Dipika and encouraged her to give her best in the show. He then went to Saurabh Patel and said that he was chosen for the show over millions but was not doing too much there.
Bigg Boss then asked the housemates to give the names of one pair and one single whom they would like to send to prison. Bigg Boss announced that this decision should be based on the happenings of the last week and all the housemates should have a mutual consent on the names announced. Based on this, the majority of housemates started taking the names of Nirmal Singh and Romil Chaudhary and all of them indulged into a huge fight.
In tomorrow's episode, this fight will grow really worse and the housemates will not easily agree to three suggested names for punishment.


text:
On	Posted on March 21, 2016 March 21, 2016 by	Tracy Jonsson to	Theater
The Little Theatre of Fall River's "Broadway Bound" at BCC a it
By Tracy Jonsson on March 21st, 2016
Neil Simon's Broadway Bound is like a family holiday dinner at your aunt's house; everyone is there, and you know you'll be chided for your life decisions, patted on the back by an understanding distant relative, cry in the bathroom, find the humanity in one of your parents, be extremely annoyed with your sibling and walk out with leftovers. The play is currently being presented by the Little Theatre of Fall River at Bristol Community College with direction from Kathy Castro, who won the Motif award for best community theater direction in 2012, and assistant director Betty Teixeira, another Motif award recipient.
The piece appeared on Broadway in 1986 to much acclaim (it received four Tony nominations). The story is a semi-biographical piece that at its core is about a divorcing couple and their family. It is told through access to the internal monologue of Eugene, a young Jewish guy living in the New York "suburb" of Brighton Beach, as he observes his multi-generational household. Set in 1949, before the widespread adoption of home television sets, we're instantly privy to Eugene's dream of becoming part of a "genius radio comedy writing team" in New York City. His brother Stan is his partner, main motivator and collaborator, and the brother-team finds no lack of humorous inspiration within the walls of their own home.
Living within view of the skyscrapers of New York City in a single family house, we observe the interpretations of capitalism and opportunity that such sights inspire. With each having their own understanding of the American dream, we get to know parents Kate and Jack Jerome, housewife and ladies raincoat cutter respectively, his brother, and his maternal grandfather, Ben. This domestic domain serves as a backdrop for dives into the strata of the American story, including but not limited to Jewish persecution and immigration in the first quarter of the 20th century and the moral conflict of being a socialist in the capitalist hot bed of the world, the first generation experience of culture shock, social pluralism, cautious optimism and access to economic comfort and (even) wealth in the trajectories of Eugene's parents' generation, and the complete assimilation into American mainstream society exhibited through the pop interests of Eugene and Stan. These larger themes add nuance to a story about our most basic commonalities; the hypnotic and engrossing effects of romantic infatuation, the restrictive institution of marriage and how our time-space reality influences our ability and to express our need for affection, love and life purpose. Simon adds layer after layer of depth to a story that could be very simplistic, to great effect.
Michael Eckenreiter, who plays Eugene, does a great job enthusiastically interacting with the set and his fellow actors in a way that hints at mid-century culture, while Nishan Lawton (Stan) provides comedic relief in this play about comedy writing. The play snakes its way through tragedy and humor, at times in confusing ways that really do bring flashbacks of your own family gatherings. At one end is Stephen R. Kay's hilarious and convincing depiction of a man of conviction going senile (funny), and on the other end is Erica Borges Vitelli, brilliantly holding down an unflinchingly smothering but loving Jewish mother role. With even a hint of comedy in her performance, Kate would seem so parodied it would border on offensive, but she balances the typical nagging, overbearing, overprotective generalization with a warmth and groundedness that make her the star of the play. A definite highlight is when Kate slides out of her domesticated psychological confines to show us a glimpse of the sexual, graceful and enchanting young girl she once was. Her husband, Jack, played by Matt Morin, comes in and out of the play and in many ways is its only villain (other than capitalism and the numbing effects of selfless devotion). He plays the cheating father role, but keeps our sympathy. The play is framed by a well-designed split level stage that fittingly enables montage-like scenes and views into multiple situations at once.
The experience is a roller coaster, but one that will ultimately let you off with a bit more appreciation for your parents, and maybe a deeper empathy for the small tragedies and the healing powers of family relationships. If you want to see a play layered with relativism that ultimately has a happy ending, then Broadway Bound is for you. It won't disappoint.
Summer In Newport: An Alternative Approach
SENE Celebrates its 8th Season with Shows in Providence, Warwick and East Greenwich
Take a Ride on the Wild Side with "Becky's New Car"
My Husband's Wild Desires Almost Drove Me Mad Challenges Audiences to Face Their Sexual Fantasies with Self-Compassion
Spring in Newport's Salty Air
Join the discussion and tell us your opinion.
Kathy Castro says:
On March 24, 2016 at 7:22 pm
Thanks for the great review Tracy~~~We've posted to our show page.
− 2 = zero


text:
James Madison and the Shutdown
Once again, James Madison is in the news. At Bloomberg, Richard Brookhiser writes:
In the last few weeks, Doug Bandow of the Cato Institute wrote that Madison wouldn't let President Barack Obama bomb Syria without authorization from Congress; Lyle Denniston of the National Constitution Center and Bloomberg View columnist Cass R. Sunstein each wrote that Madison would deplore the factionalism that has shut down the federal government; William Bennett and Christopher Beach wrote in the Wall Street Journal that Madison would scorn Congress and its staff members for exempting themselves from the provisions of the Affordable Care Act; and Jeffrey Anderson wrote that the health-care measure, though it is the law of the land, hasn't been ratified by what Madison called "the cool and deliberate sense of the community."
At The Washington Post, Dylan Matthews says Madison is behind gridlock, which is a bad thing:
But the deeper answer is that it's James Madison's fault. This week's shutdown is only the latest symptom of an underlying disease in our democracy whose origins lie in the Constitution and some supremely misguided ideas that made their way into it in 1787, and found their fullest exposition in Madison's Federalist no. 51. And that disease is rapidly getting worse.
...'
The thesis of Federalist 51 is that elections alone are insufficient to guard against the possibility that a government will encroach upon the rights of citizens, either by a majority faction oppressing others or through all-out tyranny. "A dependence on the people is, no doubt, the primary control on the government," Madison writes, "but experience has taught mankind the necessity of auxiliary precautions."
Subsequent experience, however, has shown Madison to be incorrect. New Zealand, Norway, Israel and Sweden all have unicameral parliaments whose leader serves as the executive, with only a weak monarch or powerless president and (in some cases) the judiciary to check them. None of those countries have collapsed into despotism as a result. The UK, Japan, Germany, Spain, Canada and the Netherlands have upper houses of parliament that are formally much weaker than the lower houses, and each has the leader of its lower house serve as executive. No coups d'état ensued in those places either.
Michael Barone says Madisonianism is a good thing:
The problem was caused by James Madison. And by the 39 other men who signed the Constitution in 1787.
The problem, of course, is the government shutdown. It was caused because the Framers of the Constitution wisely provided for separation of powers among the three branches of government.
That understanding, together with the constitutional structure, imposes something like a duty of consultation between the president and members of Congress. Otherwise — and you may have heard about this — the government will have to shut down.
Republicans are furious that their members can't defund or delay Obamacare. They want to see politicians stand up yelling, "No!" Theater has a function in politics.
But in fact, they've had a partial victory this year, a win that didn't seem likely last December. By accepting the sequester despite its defense cuts, Republicans have actually dialed down domestic discretionary spending.
Democrats' position now is essentially the sequester. They're swallowing something they hate. No wonder Obama seems sullen.
So both sides will have frustratingly partial victories and not get everything they want. That's how James Madison's system is supposed to work in a closely divided country.
Labels: American Constitution, Congress, government, Madison, political science, politics, presidency, separation of powers, shutdown


Super Cheap price Mid Star Sneakers outlet online sale at more than 58% discount including free shipping all over the world. Welcome to order !
Golden Goose Mid Star Womens Black : Golden Goose Mid star sneakers nike outlet prices black khaki s..
Golden Goose Mid Star Womens Black : Golden Goose Mid star sneakers factory outlet orange black beig..
Golden Goose Mid Star Mens Black : Golden Goose Mid star sneakers australia outlet store orange blac..
Golden Goose Mid Star Mens Black : Golden Goose Mid star sneakers outlet store online black khaki sn..


text:
CategoryLegacy Lawsuits
All in the family: Does Jindal have a conflict of interest on BP legislation?
In BP Spill, Commentary, Important Articles, Investigations, Legacy Lawsuits, Legal, Main, Ocean Life, Politics
It's not surprising that Louisiana Gov. Bobby Jindal has served as a handmaiden for the oil-and-gas industry during his six-and-a-half years in Baton Rouge. For one thing, it's in keeping with the pro-business-at-any-cost, environment-be-damned-philosophy of today's Republican Party. What's more, Jindal has been on the receiving end of more than $1 million in campaign...
Bobby Jindal's folly
In Commentary, Important Articles, Legacy Lawsuits, Legal, Main, Ocean Life, Politics, Restoration
This weekend, Louisiana Gov. Bobby Jindal had a clear choice. He could follow the advice of the state's attorney general — his fellow Republican Buddy Caldwell — and many other legal scholars. That would mean vetoing a poorly drafted, ill-thought-out measure that came about from Big Oil's desperation to block legal action that would force it to pay millions to restore the...
Something's happening in South Louisiana, and the "Dirty Dozen" doesn't get it
In Fracking, Important Articles, Legacy Lawsuits, Legal, Main, Politics, Regulation, Restoration, Safety
Every day, there's more evidence that the healthy winds of change are blowing through Louisiana. That's especially true in the southern part of the state which has been battered by events that have been both epic in scale — the BP oil spill and 2005's Hurricane Katrina — and more prosaic, like the Bayou Corne sinkhole and the day-in, day-out toxins pumped into the...
Louisiana awaits 2015 to undo the damage caused by Big Oil
In Commentary, Important Articles, Legacy Lawsuits, Legal, Main, Politics, Regulation
Sometimes it's a struggle to find the kernel of good news amid the morass that is our corrupted political system, especially in my home state of Louisiana. Earlier this year, I told you about the big reactionary push in Baton Rouge, by the oil giants against the state's up-and-coming environmental movement. The Republican pro-business majority, with control of the legislature and with...
Saving the wetlands: The empire strikes back
In BP Spill, Important Articles, Legacy Lawsuits, Legal, Main, Politics, Restoration
In the last week, there's been a lot of discussion about the 4th anniversary of the BP oil spill — and how Louisiana's critical wetlands had been pummeled and degraded by an onslaught of crude. These marshes aren't only places of great natural beauty and biological diversity, but they're also a critical buffer — the buffer, actually — between a major...
Why Big Oil's assault on Baton Rouge must be stopped
In Important Articles, Legacy Lawsuits, Legal, Louisiana Sinkhole, Main, Politics, Regulation, Restoration, Victim Claims
The other day I told you that Big Oil — alarmed in Louisiana about the citizenry finally fighting back after decades of environmental abuse, and uncertain about their political prospects past 2015 — is launching an epic legislative assault in Baton Rouge. Their army of lobbyists is seeking no less than a rollback of anti-pollution standards in the state, back to a time before the...
Stop the polluters from taking back Louisiana
In BP Spill, Important Articles, Legacy Lawsuits, Legal, Louisiana Sinkhole, Main, Politics, Regulation
The next two years will be more critical for Louisiana and its beautiful yet fragile environment than any time in the state's history. On one hand, the surge in oil and gas production across the United States is placing new pressures on my home state in the terms of more rigs in the Gulf of Mexico, more pipelines crisscrossing the state, more barges coming down our waterways and more tanker...
Respected general declares war — on the abuses of Big Oil
In BP Spill, Human Interest, Important Articles, Legacy Lawsuits, Louisiana Sinkhole, Main, Oil Spill Facts, Politics, Response
There's been more environmental news than usual in recent weeks, and so it's been a while since I've given readers an update on the giant sinkhole in Bayou Corne, the slow-motion ecological crisis that's been assaulting the Louisiana bayou for more than 14 months now. That doesn't mean that the situation is better. To the contrary, some experts say the sinkhole may...
Magazine exposes how Big Oil lobbyists run Louisiana
In Important Articles, Investigations, Legacy Lawsuits, Louisiana Sinkhole, Main, Oil Spill Facts, Politics, Regulation
The new November issue of Harper's magazine — available on newsstands now — features a must-read article on the issues that launched this blog in the first place: Big Oil's domination of Louisiana politics and its fight to protect polluters over landowners whose property has been dumped on. The piece entitled "Dirty South: The foul legacy of Louisiana oil," by...
Wall Street Journal relies on debunked data to make the case for Big Oil on legacy lawsuits
In Legacy Lawsuits, Legal, Main, Politics, Victim Claims
"Louisiana has had its fair share of oil troubles…" Those are the opening words of an editorial that ran in the Wall Street Journal recently, and its hard to disagree with that. While oil exploration and drilling has been a source of jobs and revenue for my home state, it's also been the source of a lot of unnecessary environmental woe. The Deepwater Horizon spill and the...


text:
Q: How to create a 3rd column based on 2 columns from two tables [inner and outer join]
*

*I have a lot of rows in 'table alpha' where some of these rows occurs in 'table beta' as well.

*Both row alpha and beta have a date column.

*

*However, when i select both date columns the rows from table alpha that do not occur in row B will have a null-value assigned to them.

My problem is that I want to make a third date-column that will use the dates from table beta if they are not null. If they are null, it should use the dates from table alpha.

A: Since you have not provided any info about your data model. I have given you a rough draft based on your problem.
Select
colA,
colB,
...,
alpha.date1,
beta.date2,
COALESCE(beta.date2,alpha.date1) date3
from
alpha
left outer join beta (your keys)

A: Since you did not provide any good data example (db schema) and expected result
Here is my approach:
SELECT
   a.date,
   COALESCE(b.mycolumn, a.mycolumn)
FROM alpha a
LEFT JOIN beta b
ON a.date = b.date

redpajama_set_name: RedPajamaStackExchange


Projects can include partners that do not receive any funding (for example, non-UK businesses). Their eligible costs will count towards the total project costs but they will not count as collaborators.
Recording of the briefing event.
What will happen to the project in the absence of funding? Describe and provide evidence for what will occur if the application for funding is not successful.