April 2009 Entries

MSI Installer logging

Need to turn on or off MSI installer logging? Found the reg setting here http://support.microsoft.co... To enable Windows Installer logging Open the registry with Regedit.exe and create the following path and keys: HKEY_LOCAL_MACHINE\Software... Reg_SZ: Logging Value: voicewarmupx The letters in the value field can be in any order. Each letter turns on a different logging mode. Each letter's actual function is as follows for MSI version 1.1: v - Verbose output ......

ADODB XML datatype

I need to pass an xml document to a SQL 2005 stored procedure as a parameter with a XML data type. I'm using VBScript with ADODB. I was getting the error of "Bad variable type." The problem is the Provider. The SQL Native Client provider uses an Xml type ( 141) that ADODB doesn't recognize. The OLEDB provider converts the xml type to varWChar. To set things up here's a sample sql stored proc create proc stor_PassXml @xmlVar xml as select @xmlVar end So here's the VBScript to call it Dim conStr Dim ......

XPATH Max

I needed to find the maximum attribute value using XPATH. I found the solution here http://www.dpawson.co.uk/xs... but below is my sample. Here is my test xml <maxValue> <node value='1'/> <node value='2'/> <node value='3'/> <node value='4'/> <node value='2'/> <node value='1'/> </maxValue> Here is my xsl <xsl:variable name="maxValue3"> <xsl:for-each select="//node"> <xsl:sort data-type="number" select="@value" order="descending"/> ......

No VS2005 debugging with IE8

I haven't had a chance to do any web work in a while, but I have a new web app this week. Being the lazy programmer I decided to step through the page execution from VS2005. For some reason the breakpoints weren't being hit. I even tried debugging web apps I've debugged in the past but no luck. I installed IE8 last week. Apparently there is some great new feature that causes VS2005 not to attach to the process if more that once copy of IE8 is running. There is a registry hack to fix it. 1) Open RegEdit ......