29 April 2011

Word Mail Merge - How to merge through Javascript

Hello,

Word Mail Merge - How to merge through Javascript?

What I will describe here will work only on Internet Explorer. Because it is using an ActiveXObject which is not available in other browsers other than IE.

I know just one way to make Word Mail Merge to work cross browser and that is to implement this in code behind in C#, you can find an article about that on Microsoft's support page: http://support.microsoft.com/kb/301659.

I will probably also make a C# version of my own, if I have a good solution I will post it on the blog.

Here is a Javascript function that I have written for Javascript Word Mail Merge.
Code:

11 April 2011

SQL - trigger fired when table is not updated

Hi,

First of all what microsoft tells us about triggers:
"A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. These triggers fire when any valid event is fired, regardless of whether or not any table rows are affected."
            Taken from: http://msdn.microsoft.com/en-us/library/ms189799.aspx
There is something interesting in above sentences, I suppose many of us would not understand correctly the last sentence: "These triggers fire when any valid event is fired, regardless of whether or not any table rows are affected". I have also walked through these problems some days before.

Need more? Leave comments and subscribe to my blog.

.