Monday, July 30, 2012

double quotes in formula

easiest method & CHAR(34) &

Subkeys in Cookies

are stored as NameValueCollection ; therefore, you have to urlencode the values before disaster strikes

Friday, July 27, 2012

Exception from HRESULT: Excel automation issues

I was getting bizarre Exception from HRESULT: on vista where it worked fine on xp
I tried setting security to allow vba projects - nyet
I tried dcom - it wasnt there
I finally tried savecopyas   lo  and behold - it worked

Thursday, July 26, 2012

Publish Issue

I had to compile before publishing to get my latest changes in the XAML file

Wednesday, July 25, 2012

Cannot find a Resource with the Name/Key blah

Fascinating point - if the resource is included in a different xap file there wont be an error

Tuesday, July 24, 2012

Comparing Images In Sql Server


SELECT 1 where
HASHBYTES('MD5',image) =HASHBYTES('MD5', image)

or the following function 

CREATE FUNCTION [dbo].[fn_HashLongString] (@InputData NVARCHAR(MAX))
RETURNS BINARY(20)
AS
BEGIN
RETURN HASHBYTES('SHA1',SUBSTRING (@InputData,1,3989) + CAST(CHECKSUM(@InputData) AS NCHAR(11)))
END
 

ReportViewer greyed out or without images?

You may need to add managed handler.