Wednesday, July 25, 2007

document.getElementId() has no properties

Today I was getting this error, in Firefox even though the Javascript code that I wrote was working fine.

I had a feeling that my javascript code was not working, and concentrated to work on that.

But the error was not in the javascript code but in the xsl code.

To solve these kind of errors in FF give your elements IDs instead of names and reference them with

document.getElementById("id")

IE seems to be a bit relaxed even though you have a name defined and not the Id.

Tuesday, July 24, 2007

Adding lines on a stacked column chart

Today I had a need to do a graph in Excel where it need to display a stacked column chart and also a line in the same graph.

The data for this is as follows for three years

2008 2009 2010
12000 14000 16000
1000 1000 1000
170000 180000 200000

I wanted a stacked column with the first two rows and a line with the last row. But when I chose the normal 2d column chart, it was showing all three rows as one stacked column.

To get the desired results, I followed the following steps

First, include all three rows in the series part of the chart data and choose the 2d stacked column chart

Next, right-click on the colored part of the bar that corresponds to the year and choose "Chart Type". Then select the first Line graph. Click Ok

Finally, right click on the graph and choose chart options and tick the 'Value Y Axis' tick box under the secondary axis lable of the 'Axes' tab

You should now have the first two rows displayed as a stacked column chart and the third row displayed as a line graph above your columns.

Monday, July 23, 2007

Convert VBscript to Javascript

I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful

Beware that this tool does not work in firefox though.

Sunday, July 22, 2007

New transaction cannot enlist in the specified transaction coordinator

I was faced with this error when I was trying to configure a web application and trying enter a transaction through the virtual website. Thanks to the internet, I found a lot of information on the internet.

Here are the steps I followed to correct this:

Start the Component Services administrative tool. To do this, click Start, click Run, type dcomcnfg.exe, and then click OK.
In the console tree of the Component Services administrative tool, expand Component Services, expand Computers, right-click My Computer, and then click Properties.
Click the MSDTC tab, and then click Security Configuration.

Turn on the Network DTC Access
Allow Inbound
Allow Outbound
Enable XA Transactions
Choose No Authentication required

Save these settings and reboot your system.

The error is fixed.

In Windows Server 2003 SP1 and in Windows XP SP2, the Distributed Transaction Coordinator service gives you more control over the network communication between computers. By default, all network communication is disabled. The Distributed Transaction Coordinator Security Configuration dialog box has been enhanced so that you can manage these communication settings.

Friday, July 20, 2007

Tuesday, July 10, 2007

Understanding the C in CSS

This simple tutorial explains the cascading feature of CSS. Useful for those starting out with CSS or if you need a refresher.

read more

Thursday, July 05, 2007

Creating Excel Spreadsheets from VB.NET

This nice tutorial walks you through step by step creating an Excel spreadsheet with multiple worksheets. This nice introduction includes full source code and detailed instructions to help you get started.

read more

Sunday, July 01, 2007

Step By Step Guide to resolve SQL server connection issues when connecting from R Studio

Yesterday I tried using a couple of  RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio.  These are my learnings as part of ...