Problem started as a simple CAN’T CONVERT NUMBER INTO A STRING in Excel. But solving this problem revealed a deep difference between character Space and character No-Break Space. I was coping some text from Internet and pasting it into Excel to extract QTY, Amount and Total. The ultimate goal is […]
Problem You need to search and replace large registry databases with a set of new values. You have a third-party utility to do the job, but this utility can only update values writable by administrator. Thousands of registry keys are owned by NT Service\TrustedInstaller and protected even for Administrators. What […]
Today we woke up at 9:15 in Lucca. This is a middle of a second week and it is a midpoint in our trip. This is night number 12 out of 24. Right now (10:37) we are finishing our fruit breakfast in the kitchen, and planning to stroll around […]
As your custom ASP.NET Web control grows, you might realize that it is time to split it into two or more controls. But how new pieces will communicate with each other? This article describes how event in one control can trigger a method in other control. [Environment: Visual Studio 2008, VS2008] […]
Completely alone in the woods. For many miles around. I didn’t see a single person on the entire wilderness portion of the trail. And now, as planned, it is my first night in the White Mountains is closing in around me. Even now it seems strange to remember […]
It is meaningless to compare for equality (==) two fields of type SmallDateTime, because they contain time component and they are hardly ever the same. Here are some interesting ways around this problem to check, if two SmallDateTime fields have the same date component.
We are in Pescia in a Villa Vezzani somewhere near even smaller Collodi. We added this village into our itinerary, because we thought that there is a link exist between Collodi the village and Collidi the author of Pinocchio. There are none. We woke up at 7:30 and took a quick […]