How Ajax works

AJAX has gotten more and more popular over the years, and has allowed web applications to act more and more like desktop applications. AJAX can provide a lot of additional functionality that could not be accomplished any other way.

Read More

Substring syntax in sql

Yesterday I was trying to get a part of a string from a field where the first comma occurs.

For example there is a field named 'Descriptor' which is a combination of "full name, Date of birth, unique number of the record" in that order. I wanted to get the full name using a select statement.

Here is the syntax I used.


select substring(descriptor,1,charindex(',', descriptor)-1) as [fullname]
from contacts

CSS Bubble Tooltips

Avoid cross-browser javascript when you can use css to make tooltips with less code. Honestly you were going to use css to style your tooltips anyway right? Your probably already have most of this code in your css already too. You can hover over meThis is my Bubble Tooltip with CSS to see how well these bubble tooltips work. Besides that if you have an advanced site in the first place you probably have enought javascript already.

For more info click here