Whoops

,

I setup an announcement for today (Sept 14) that the Sept CTP for SQL

Server 2005 was released and that Database Mirroring is disabled. It's

also got more language support and a few other things.

Apparently, however, my coding skills were a bit challenged. I forgot a

primary rule in working with data, especially outside of SQL Server.

      x > "10" does not equal x > 10

I setup a time check based on the current time and a number I was

checking, but I used the first expression, which is a string comparison

expression. So "2", "3", etc. are all > "10". Only "1" would be

less. So the article text got released a little early and hopefully MS

isn't too upset 🙁

I've gotten so used to working with SQL Server data and I always check

the time values when working with dates. In VBScript, however, it's a

little more complicated. I should have used the CINT() function to

ensure I was comparing a numerical value and then comparing that to a

numeric, 10, not "10".

Rate

Share

Share

Rate