Blog

Trimming

T

If you have imported a large amount of data, or had some rogue users, helpfully putting a space at the beginning and / or end of a string, then this simple update will clear that out: UPDATE TableName SET ColumnName = RTRIM(ColumnName) 1 UPDATE TableName SET ColumnName = RTRIM(ColumnName) Of course, if you only want to select the data, you could also: SELECT RTRIM(ColumnName) FROM TableNames 1...

Disallowed Parent Path Fix

D

If you ever get this error: Active Server Pages error ‘ASP 0131’ Disallowed Parent Path The Include file ‘../myFile.asp’ cannot contain ‘..’ to indicate the parent directory. or something similar, then below is a quick fix for those of you running IIS6, and want to allow parent paths. Right click on the web application that’s throwing the error. in my...

Arriving In Taba

A

We arrived at Taba Airport around 7pm, and, after a short (we’re talking 30 seconds) bus ride from the plane to the terminal, we were put into various que’s. One for people who wanted a visa, and one for people who didn’t. If you intend to leave the Sinai, you’ll need a Visa. That means, if you intend to go to Cairo, you will need one. If you only want to sit by the pool...

Marriott Resort

M

First impressions of the resort were very pleasant. Although we arrived at night, the grounds still looked good. We had filled in a check in card on the coach, so were checked in within literally 5 minutes, and shown to our room by a friendly chap. I’d read that the staff here seemed to be miserable, however I didn’t find this the case. After around 10 – 15 minutes, another man...

Dinner Time

D

Dinner at the Marriott (for those staying Half / Full Board) is provided in the Al Alandalus restaurant, located near the pool. It’s a “help yourself” buffet, with many different things to choose from – various meat dishes, salads, homous, bread, pastas, fish (the fish by the way, is excellent) For desert, they have on offer one of the larges selections of cakes etc…...