Rodan Sotto's Tech Blog

To call a Windows Form application (*.exe) with arguments in VBA, you use the Shell() function. Shell “C:\Dev\SampleWinFormWithArgs.exe arg1”, vbNormalFocus   Inside the Windows Form application, you get the command line arguments using Environment.GetCommandLineArgs(). string[] args = Environment.GetCommandLineArgs(); // you can call GetCom... Read More

SYNONYM Starting in SQL Server 2005, you can use SYNONYM in place of their referenced object in SQL statements.  It’s like an alias.  The benefit here is that if you decide to alter the name of the object being referenced by the synonym, let’s say you want to change the name of the table or use a totally different table, or change the location ... Read More

Event Handling, Attaching and Detaching Events 3 phases of event dispatch: Capturing – going down the DOM tree until it reaches the target element Target Bubbling – going back up the DOM tree from the target element // standard way of accessing the Event object var eventHandlerDOM = function(evt) { alert(evt.type); //displays clic... Read More

This post is a follow-up to my previous posts, Object Oriented Programming In Javascript and JavaScript Array and How It’s Different from Object.  In this post I will touch on regular expressions, error handling, basic DOM scripting, image preloading, and timing events. Regular Expressions // creating patterns var pattern1 = new RegExp(“Rodan”... Read More

I talked briefly about regular expressions in .NET Framework here, how you can test for a match and how to extract or replace a matched group, or matched substring if you may.  The examples there used a named group to extract a matched group (e.g. **?**, **?**, etc...).  It's worth mentioning that you can also extract a matched group using **$**... Read More