Skip to content

Categories:

Remove MS Word Smart Quotes in Vbscript

just a little tidbit that was driving me crazy.

Haven’t used ASCW and CHRW much, but here it goes:

strtitle = Replace(strTitle,ChrW(8211),”–”)
strtitle = Replace(strTitle,ChrW(8212),”–”)
strtitle = Replace(strTitle,ChrW(8216),”‘”)
strtitle = Replace(strTitle,ChrW(8217),”‘”)
strtitle = Replace(strTitle,ChrW(8220),”"”")
strtitle = Replace(strTitle,ChrW(8221),”"”")
strtitle = Replace(strTitle,ChrW(8226),”*”)
strtitle = Replace(strTitle,ChrW(8482),”")
strtitle = Replace(strTitle,ChrW(8230),”.”)

Posted in code.

MSXML Object ASP

2 errors today:
msxml6.dll threw
The host name in the certificate is invalid or does not match
-2147012858

which can be fixed by using the following code:

http.open “GET”, url, True
Const SXH_SERVER_CERT_IGNORE_ALL_SERVER_ERRORS = 13056
http.setOption 2, SXH_SERVER_CERT_IGNORE_ALL_SERVER_ERRORS

then msxml6.dll threw
The connection with the server was terminated abnormally
-2147012866

In the code I found the following line which caused the trouble:
http.setRequestHeader “Connection”, “Close”
Why oh Why?

Posted in code.

Facebook connect blocked by company internet / firewall

We recently had the problem that our site was loading very slowly for some users because their firewall blocked any access to facebook (company guidelines). After a quick search I found a great solution by the guys at tripadvisor.
http://tech.tripadvisor.com/

Posted in code. Tagged with , , .

great example of facebook integration on classic asp

Here’s an excellent example of facebook integration using classic ASP by Larry Boeldt.
http://www.codeproject.com/KB/asp/classic-asp-facebookweb.aspx

Posted in code.

Basement Reno Day 8 9 and 10

Building the base for the shower p-trap

bathroom behind the scenes

Insulation bedroom outside wall (inside utility room)

moving more air ducts between joists for more headspace

bringing power to the gym

Day 9: adding the new waste water Y-connector from the bathroom to the main pipe

Day 9: Bathroom Insulation around the plumbing

Day 9: Bathroom power

Day 10: Building boxes for the waste pipe in the bathroom

Day 10: closing the bathroom walls

Day 10: Bedroom: Building a box around the ductwork

Day 10: Drywall ceiling around the corner window

Posted in reno.

Basement Reno Day 5 & 6 & 7

Day 5: new walls for the bathroom

Day5: new walls for the utility room

I’ve clumped the recent days together. A holiday and a family visit took the concentration off the basement for a couple of days.

New purchases: Maax Yarrow shower kit $400 (just polystyrene, not acrylic because of the price difference), Watergenie mascerating toilet, pump and tank ($1000), Diplex bathroom heater ($200).

new walls going up in the future play room - Ah the basement is nice and cool in the summer!

Day 6: adding sound insulation to the bedroom / bandroom walls

Day 6: adding new ductwork to bring some heat into the bedroom :)

Day 7: Adding drywall on top of sound insulation in the bedroom.

Day 7: Adding some plumbing in the bathroom

Day 7: where the new shower will be.

Posted in reno.

Basement Reno Day4

Day 4:

Today we added water connections for the new bathroom, the framing for the bedroom and some insulation for an outside wall that had been left uninsulated since an oil tank had been removed some time ago.

new frame for the coming bedroom

new water connections

Posted in reno.

Basement Reno Day 3

Day 3:

Some new frames are built for the coming bathroom and guest room in our basement. It’s getting exciting! What made it even more exciting is that we had our first power outage last night. From about 7pm to midnight we had no lights and no water (well pump). I guess it’s time for a generator. I’ve been scouring through Home Depot, Rona and online reviews quite a bit of the day. We’ll have an emergency panel added to our electrical panel to connect the generator to. In case of a power-outage we’ll have our microwave and some smaller kitchen appliances, a light on every floor and the water pump and sump pumps working. Hey, maybe even a bit of television and radio (and the cable modem of course). Hmh, what generator to purchase?

new frame for the coming bathroom

How framing is done these days..

wall for new gym / band room

Posted in reno.

Basement Reno Day 1&2

Day 1:

Removed wall along floor in the new storage/utility room

The first day was not very exciting but it was immediately clear that this was going to take some time. One basement wall was removed  and the new wall positions were discussed and drawn on the floor. We also took some action with regards to our well water source. There is too much sulphur in the water and this created a rotten-egg smell everytime one turned on the tap. Not very appealing when brushing your teeth! So we had the local Pump & Well guys come in to install a chemical free iron filter. This little rocket (Duro Duroclean IF) now stands next to the well pump and does its job perfectly. The smell went away immediately.

Day 2:

A crack in the foundation wall was filled up to make sure we wouldn’t have any water problems after the wall gets covered with insulation and drywall. Some of the forced-air ducts were sitting too low in the basement (at six feet tall I had to duck to cross the room). There wasn’t any good reason for the ducts not to run between the joists however, so we had them moved up. For there to be enough room for the new basement bathroom, we also had the hot water heater moved a bit to the right.

DuroClean chem-free Iron filter to remove foul odours from well water

Fixing a crack in the foundation wall: epoxy

Ducts moved between joists to create more headroom in the basement

Move hot water tank and realign connecting pipes

Posted in reno.

from tech to home renovations

We just bought a great house on a beautiful piece of land. After a minute or two to enjoy it, we’ve decided to do home renovations. First up is the basement!

Posted in misc. Tagged with .