Do you want to have custom tooltip without using JavaScript in your website? Using following code you will have custom tooltip in your website. a:hover { background:#ffffff; text-decoration:none; } /*BG color is a must for IE6*/ a.customtooltip span { display: none; position: absolute; padding: 2px 3px; margin-left: 2px; } a.customtooltip:hover span { display: inline; background: [...]

Posted in Programming, Tips & Tricks No Comments »
Tags: CSS

It is common developer requirement to get missing records from series. For that they generate temporary table and insert complete list of numbers and then find missing numbers using LEFT JOIN. In SQL Server 2005 and 2008, new keyword “WITH” introduced that works with SELECT, INSERT and UPDATE statement that use to create temporary resultset [...]

Posted in Microsoft, Programming No Comments »
Tags: SQL Server, T-SQL

There is no function in ASP to count number of words in sentence or long string. Bellow is very simple function that count number of words and return that count. < % Function CountWords (StrValue) Dim iWords, mLengthWithSpaces, mLengthWithoutSpaces ‘ following line calculate the actual length of string mLengthWithSpaces = Len(StrValue) ‘ following line remove [...]

Posted in Programming, Visual Basic No Comments »
Tags: ASP

Trim is a useful String function available in languages like Visual Basic, Java & PHP which removes all leading and traling whitespaces from a String. Unfortunately Javascript does not provide Trim functionality to the String object. But there is solution using Regular Expression. Use following code in top of your Javascript file. Following code will [...]

Posted in Programming No Comments »
Tags: Javascript, Regular Expression