September 11, 2001

This tip will trim the contents in the input box of an HTML page using java script. Call the Trim function by sending the Textbox element as the parameter. Example:

If you come across a situation where you need to prompt the user to download an XML file with

You might have a table with different PEOs for each Company ID. For example: Table name : tblRankingCid peo———– ———–1 200003311 200006301 200009301 200012312 200003312 200006302 200009302 20001231 To give

This is a SQL trick for spreading out data across months on a single row. It also works with Sybase TSQL. The 1-ABS(SIGN()) function will evaluate to zero for all

The JavaScript Array intrinsic object (and others) can be extended to include user-defined functions in the object definition. These extensions can be placed in a .js file and included in

C++ smart pointers are the idea of using a selector to access a class. This gives the class writer an option to control access to class members and function. For

Creating dynamic Microsoft documents may be useful. The problem is that creating Word documents in ASP will result in an error saying that IIS cannot run out of process components.

This code shows how to get value from the control irrespective of the control type used in the client side Javascript. function GetValue(ControlName,FormName){var Control=document.forms[FormName].elements[ControlName]alert(Control.type) switch(Control.type) { case “select-one”: case “select-multiple”:

Using Count(*) is generally better than using Count() with a specific column name, because it gives the query engine the flexibility to find out the row count any way it