Posts

Tidy badly encoded DB TABLE french chars

These few SQL lines came in handy when wanting a quick-fix for a poorly imported table UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á©','é') UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á´','ô') UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'ÁŽ','Î') http://stackoverflow.com/questions/5127744/how-to-convert-these-strange-characters-%C3%83-%C3%83-%C3%83%C2%AC-%C3%83%C2%B9-%C3%83

Home Truths

Image
  Had to pinch a couple of these       https://www.facebook.com/MicrosoftDeveloper/photos/a.237767339690433.61184.231824870284680/533208980146266/?type=3&theater           http://www.wickedfire.com/shooting-the-shit/175475-anyone-else-hate-not-being-programmer.html       And one I could not find….   There is a graph showing how much as a percentage a programmer thinks a project is completed, vs how much its actually completed.   If someone knows where I can find this graph  - please let me know.    Here is the rough idea:      

Why web forms can be very irritating when they not working

Image
I got an ACE-FX card when in the UK recently as my Credit Card companies were charging a horrific "Foreign Currency Surcharge" on every payment I was making in USD and EUR. It came quickly, in a day or two, and the original 50 GBP I loaded I was able to buy something from Google in USD for 25 USD no problem. So I get to Andorra and think, "Right I need to load this up".  So login to the Account. Huh, there are no transactions and no details.  They did have a problem initially with my details - damned apostrophe and some incorrect data entry their end (wrong birthdate) and a lovely little 0870 line where you have to "activate" your card before use that forces you to spend at least 3 mins on the phone - and considerably more if they have screwed your birthdate up, so you will never manage to activate... It's all coming back to me now. Anyway... Here I am.. I need to mail them.   Huh.. no traditional email just one of these damn form...

how to actually burn the files to cd-rom disk

Image
Windows 8.           Clicking “Burn to Disc” on the Share Tab of the Ribbon did not work  

how to build using msbuild

This is the format   MSBuild "MyProjectName.csproj" /T:Package /P:Configuration=Staging;PackageLocation="D:\Vishal\Package.zip"     MSBuild "C:\Users\Karl\Documents\VSO Local Rep\RedPlanet\RPT Umbrella\RedPlanet\redPlanetWebsite\redPlanetWebsite\redPlanetWebsite.vbproj" /T:Package /P:Configuration=Debug;PackageLocation="c:\buildPackage\redplanet.zip"     A reference to could not be added a reference to the component already exists in the project

AWS Amazon Webservices Appostrophe Hall of Shame

Image
Don't let Bezos find out.  Someone there will be for the high-jump!

Yahoo Mail Phone Number Hall of Shame

Image
I wonder if Yahoo mail ( http://mail.yahoo.com ) have noticed a lack of signups from Andorra?  No.. I didn't think so. We have real short numbers here in Andorra.  The one you see below, is perfectly valid.