Showing posts from June, 2008

Decimal datatype in sql server 2000

The decimal data type in sql server 2000 has precision and scale.

The precision defines how many length of chars that can exist from left to right including the the numbers after the decimal point.

For example col1 decimal(3,2) can contain total of 3 numbers. 9.20 is valid whereas 99.2 is invalid because sql server will add a zero at end to make it 99.20 and that invalidates the rule of precision 3.

try this

drop table testDec2

create table testDec2(col1 decimal(8,2))

insert into testDec2 values (999996.9999999)
--number on left is of len 6 and even thogh we have 7 digits after decimal point, sql -- will truncate the number to insert 999997.00 . Notice the rounding.

-- if you try to insert 999999.99 it wont work because of rounding. The number will
-- be 1000000.00 i.e. total of 9 chars.

select * from testDec2

give it a try. ;-)

Outlook appearance like Gmail Conversation style

Found this great tutorial to mimic the gmail conversation style threading of conversation / emails in one single thread.

Right click on From, or Subject and select Field Chooser. Select Conversation and drag it to any place where From, Subject etc appear. Conversation will appear along From, Subject wherever you have placed it. Right Click Conversation and select Group by this field.

Thats it. You are done. I got a message saying cant group by Date and conversation. so I sorted my mail by sender and then clicked on conversation. It worked for me. Make sure you arrange mail in such a way that the new email is listed on top.


Translators not loaded --- Translators error in Dreamweaver for coldfusion.htm

I use Dreamweaver 8 on Windows XP and recently started to get this error message for no reason. It just started one day.

the following translators were not loaded due to errors coldfusion.htm has configuration information that is invalid.

This could also happen for
XSLT.htm has configuration information that is invalid,
ASP.htm: has configuration information that is invalid.
ASP.NET.htm: has configuration information that is invalid.
and so on.

The solution to this problem is to delete FileCache_X.dat files from the Dreamweaver user configuration folder, where X is a random number and it could be different for your system. See below

Dreamweaver 8 on Windows XP:
C:\Documents and Settings\[username]\Application Data\Macromedia\Dreamweaver 8\Configuration

All the best. I was able to successfully solve this problem