I’m struggling to get into it to be honest….although that may be because I hadn’t seen the earlier series. The Killing grabbed me straightaway, to the point I was actively looking forward to each week’s double bill. I hadn’t felt like that about a telly programme for years. Spiral isn’t as subtle, and it doesnt seem to flow as well. Will stick with it, maybe it’s a grower.

Mailmerge from a query rather than direct from the table. Use the format function in the query to sort the date for you:

=FORMAT(<mydate>,”DD/MM/YYYY”)

Used to live not far from this… surprised not to see it yet:

cheers… how’s it working out cost wise?

Anyone else noticed that the gear arrangement would lock up?

you clearly have far too much time on your hands….

Anyone got experience in fitting an external flue? We’re moving to a new build house and I really want to put a log burner in, but there’s no chimney :(

now you’ve got me wanting an xtracycle….

What’s the problem. Fusion innit?

Following on from post above, just to whet your appetite:

View from the back of the van @ Graig Wen last year:

Not a great pic, but gives an idea of how far from anything Mynydd Mawr is:

Sunset view from Tristram, Polzeath:

We love Caerfai Farm near St Davids in Pembrokeshire. Lovely spot with fantastic views – great for kids as above a really safe beach. The area in the middle of the camping fields is kept clear so there are always impromptu games of cricket and football going on with the kids from the site. Dogs allowed too.

For something a bit wilder, then it’s hard to beat Mynydd Mawr on the Llyn peninsular near Aberdaron. Facilities very basic, but again, stunning views out over Bardsey Island and a real back of beyond feel.

We’ve also stayed here a number of times: http://www.graigwen.co.uk/modx-0961p2/index.php

The camping area down near the estuary is stunning. Direct access onto the Mawddach trail and handy for CyB.

In Cornwall, I really rate Henry’s on the Lizard: http://www.henryscampsite.co.uk/ … a bit hippy dippy, but good fun, and again great for kids. Some great walking thereabouts as well.

Although it’s v expensive, I also like Tristram campsite at Polzeath. You can’t beat it for views / location / easy access to the surf etc, but it does get very busy – probably best left for out of season.

Not stayed at Pool Bridge, but it gets very good reports. Nearby there is also Burrowhayes Farm – http://www.porlock.co.uk/members/index.php?id=00073 much bigger, more commercial site, but has some of the best facilities of any campsite I’ve stayed in, and direct access onto Exmoor. Very friendly too.

Thanks folks – but having checked the brakes a bit further I’ve noticed the lever isn’t too clever either so I’ve just bitten the bullet and bought a complete front M535 brake.
This is the second LX caliper I’ve had go the same way (sounds like this must be a common problem), whilst the M535s I’ve had on my other bike for ages have been genuinely hassle free.

My bike is rapidly becoming a frankenmonster with all the mismatched components, so I’m past caring about how it looks!

I think that’s what I was trying to do above… not sure if it’s right, but I think its on the right track

What about something like this – may need to do a group by to incorporate the count on the second part of the union:

–gives you matching records

select
c.*
from
a
inner join
b
on
a.company_id = b.company_id
inner join
c
on
b.template_id = c.template_id
where
a.company_id = <required company_id>

–joins the results of c where there is no link to company ID in a via b

union select
c.*
from c
left outer join
b
on
c.template_id = b.template_id
left outer join
a
on
b.company_id = a.company_id
and
b.company_id = <required company id>
having
count(a.company_id) = 0

So if there are records in the link table with a specified company ID I want only those templates that apply to the company. If there are NO records in the link table with that ID then I want all the templates.

This is somewhat different to what you asked for earlier – you want everything from c if no match is found between a, b and c. Right?

…jeez. I come on here to get away from the day job!

I’m really confused – you said you wanted to select all rows from a – I think you need to provide some examples.

Or are you saying that you want to filter records from table A for a particular company, in which case you just specify the company ID in the WHERE clause against table a.

select
a.*,
c.<column name>
from
a
left outer join
b
on
a.<linky column> = b.<linky column>
left outer join
c
on
b.<linky column> = c.<linky column>
where
a.company_id = <required company_id>

There’s two tables A and C, and a link table B between them – many to many relationship.

However the link is not implemented for all companies. So if there are NO rows in the link table matching the company id then I want to select all rows in A *

This still sounds like an outer join to me – would something like the following not work?

select
a.*,
c.<column name>
from
a
left outer join
b
on
a.<linky column> = b.<linky column>
left outer join
c
on
b.<linky column> = c.<linky column>

However this van was used in my parents business and after around 200-250k km it then began to be sloooooow.

Sounds like a daft question but did you check the throttle cable? They stretch really badly on T4s and the impact on performance is massive. Mine went a couple of years back while my wife was away on holiday in the van with her mum – they apparently had a mile long tail back behind them driving across Dartmoor! Cost £50 to replace the cable, and all was fine again.

… and the romantic scent of drying mud and GT85 just to set the mood.

Have to say that two people plus bikes sleeping in a van that size sounds really cramped particularly as access will be difficult without a side door.

Remember that if you’re insulating and ply-lining it, that is going to take up some of the space

These guys do camper conversions on vans your size so may be able to advise / give you some ideas of what is possible:

http://www.amdro.co.uk/jump.php

Random thought now, does anybody know of vegtable oil conversion being done on one of these engines?

Yes – again, check out the T4 forum. May need to swap out the fuel pump (apparently veggie oil eats the seals on some types, but loads of folk seem to be running their T4s on veg oil.

http://www.vwt4forum.co.uk

I looked at a couple of 2.4Ds before buying my 1.9TD Westy. They’ve got a fair amount of low end grunt but do feel a bit ponderous through the gears. As pointed out above, they’re not as slow as you think and are a pretty comfortable cruise on the motorway.

The 1.9TD needs to be worked a bit harder but feels a but nippier through the gears (you need to tackle hills in a singlespeed style though :-) I personally preferred how the 1.9TD drove, but it’s all down to personal taste. I think both have pretty good reliability records.

Servicing is slightly more expensive on a 2.4 I think because it’s a 5 cylinder engine.

As stated above, both are pretty gutless compared to a TDI, but you pay more for them. For what you describe, I’m sure it will be fine provided it has a sound service history.

Have a look at the T4 forum – there are a few threads on there about the 2.4.

You say the thread is stripped all the way in – is that just with the standard bolts?

Reason I ask is that I actually did the exact same thing a couple of weeks after buying my MX Comps about 4 years ago after an ill advised trailside fix. :oops:

I was looking at helicoils etc but I actually got away with it by just using some slightly longer bolts -they’ve been fine ever since.

Can also get sleeper trains dirt cheap if you book well ahead and aren’t travelling at peak times (ie Friday / Monday). Wife and I got one a couple of year ago for £40 each return.

Is there an echo in here? :D

England or Britain as a whole?

Sleeper train from Euston to the highlands. Leave work, few beers and something to eat in town on Friday night, get on the train at 11pm and wake up in the mountains. Two full days of fun and then back in town for 7am Monday.

Locally, you’ve got both the Surrey and Kent end of the North Downs and the South Downs within an hour’s train journey.

I’d also +1 for the Quantocks, or stay on the train a little further and get off at Exeter or Newton Abbot for a stab at Dartmoor.

I spotted some in someone’s garden this morning here in Kent- haven’t been out for a ride this w/e due to packing / various family illnesses so not sure if my local woods have any yet.

From Wikipedia:

Hot air balloons are able to fly to extremely high altitudes. On November 26, 2005, Vijaypat Singhania set the world altitude record for highest hot air balloon flight, reaching 21,027 meters (68,986 feet). He took off from downtown Mumbai, India, and landed 240 kilometers (149 miles) south in Panchale.[16] The previous record of 19,811 m (64,997 ft) had been set by Per Lindstrand on June 6, 1988 in Plano, Texas. As with all unpressurized aircraft, oxygen is needed for all crew and passengers on any flight that exceeds an altitude of about 15,000 ft (4,572 m).[17]

NCB – You’re in the right area – East coast of S Harris, just off the Golden Road.

Might be easier to see in this one…. oh and I had to move the saddle forward and fettle the fork a bit as well, otherwise it felt a bit wandery on climbs with the extra weight on the back. I was running a longer stem anyway, but if you’ve currently got a short one, you might want to consider swapping it out.

I had the same problem on my Gary Fisher. On my rack, the length of the chainstay supports are adjustable so I sorted it by making the rear supports a bit longer and angling the rack slightly. It meant the panniers were tilted forward slightly, but worked a treat. Not sure if you can see it in the pic below.

I’m sure someone on here will be along to correct me if I’m wrong, but I thought BMX calipers / levers had the same or similar pull ratio as road brakes (I quite often see fixies and the like running BMX levers with centre pivot brakes). In that case if you use standard V levers I guess you would find them really grabby.

+1 for Stockholm – very interesting and atmospheric city with lots of great bars and restaurants. Pricy though!

Depends on the size of the house and distance being moved. We’re moving from Kent to Devon and ours is a 3 bed house. We’ve had 4 quotes so far with a massive range between them – cheapest was £1100 – most expensive was £1800 8O

That’s three Harris ones so far – maybe we should form a support group.

Bit more of a trek (about 45 mins), but some really good riding around Kentmere – Have a crack at the Garburn Pass if you get the chance.

Riding to Tarbert on our Hebrides tour. Looking forward to the long downhill to Tarbert from Uabhal Beag. Crested the pass and straight into the worst headwind ever – had to pedal all the way down despite heavily loaded bikes.

The first pint in the Harris Hotel didn’t touch the sides!

… or add an additional access point if you can get some Cat 5 into the area where you need access. You can pick up some models on Amazon for less than £20

This one has power over ethernet, which is quite handy:

http://www.amazon.co.uk/TP-Link-TL-WA701ND-150Mbps-Wireless-Access/dp/B002YETVVE/ref=cm_cr_pr_product_top

They’re great bikes. Can’t see myself ever getting rid of mine (in fact the only thing I’d swap it out for would probably be the Troll).

Will pretty much take any punishment you like. Sharp handling, comfy ride. People go on about the weight, but can’t say I’ve ever noticed it – in fact mine in it’s current build is the lightest bike I own – obviously all my other bikes are chuffers!

I’m 6’1″ and have a 20″ frame- would easily fit someone a bit taller I reckon.

I have met many Brits who could not find their own aerses with both hands and a torch. We live on a small island – they live in a country damn near the size of Europe. We have far less excuses.

Reminds me of a conversation with our estate agent:

“Where are you moving to?”

“Devon”

“Oh I’ve been there – it’s near Stonehenge isn’t it?”