Friday, December 23, 2005
So ok - here goes:
The perfomancing shortcut is quite unobtrusive...
Most of what you need is here - except tags, of course...
Thursday, December 22, 2005
Wednesday, December 21, 2005
Thursday, December 15, 2005
Might be come tedious after a while, but so far I like it. Now they just need to add technorati (or their own) tags.
Wednesday, December 14, 2005
I encountered a strange bug in some sql code I was refactoring this morning, when I replaced a number of IF .. ELSE statements with a simple COALESCE. The essence of the buggy code was as follows:
USE Northwind GO CREATE FUNCTION dbo.Foo (@EmployeeID int) RETURNS nvarchar(20) AS BEGIN --Declare a variable that really shouldn't be used DECLARE @EmployeeName nvarchar(20) SET @EmployeeName = 'Not expected' RETURN COALESCE ( (SELECT e.LastName FROM dbo.Employees e WHERE e.EmployeeID = @EmployeeID), '(Not Found)' ) --The function SHOULD have exited by now... RETURN @EmployeeName END GO --Both of these return unexpected results SELECT dbo.Foo(1) --Returns 'Not expected' SELECT dbo.Foo(564654) --Returns 'Not expected'As can be seen from the code - I would have expected the first RETURN to exit the function. Instead what is actually returned is the contents of the @EmployeeName.
This appears to be a bug in how SQL handles the combination UDF, multiple RETURNs and a SELECT statement within a COALESCE.
(For the record, the following version of the function works fine:)
USE Northwind GO ALTER FUNCTION dbo.Foo (@EmployeeID int) RETURNS nvarchar(20) AS BEGIN --Declare a variable that really shouldn't be used DECLARE @EmployeeName nvarchar(20) SET @EmployeeName = 'Not expected' RETURN COALESCE ( (SELECT e.LastName FROM dbo.Employees e WHERE e.EmployeeID = @EmployeeID), '(Not Found)' ) --The function SHOULD have exited by now... --RETURN @EmployeeName <--SECOND RETURN COMMENTED OUT END GO --These now return the expected results SELECT dbo.Foo(1) --Returns 'Davolio' SELECT dbo.Foo(564654) --Returns '(Not Found)'
Monday, December 12, 2005
I'm a tad slow, so I just discovered MyWeb2 the day before the Yahoolicious deal, but from a first glance, MyWeb2 has one notable feature that del.icio.us doesn't: the option of privacy. I guess that feature will come to del.icio.us as well now, along with ads, I'm sure.Technorati Tags: yahoo, del.icio.us, tagging, business, web2.0
* Editor: highlighting of caret row
* Extract Class from Method Parameters refactoring
* Generating Equals and GetHashCode method implementations (via Alt-Insert popup)
* Implement members: ability to generate fields for implemented properties
* Implement members: option to generate explicit (private) implementations
* Implement members: additional treatment of ISerializable interface
* NAnt build files: completion for tags and attributes
* Ctrl-N: auto-switch to searching in libraries when no matching type found in solution
* Obsolete attribute is taken into account by code highlighting and intellisense
* Context action for changing visibility modifier (available on visibility modifier keyword)
* Context action for splitting local variable declaration and initialization
* Context action for joining local variable declaration and initialization
* Context actions for converting implicit interface member implementation into explicit and vice versa
* Context action for navigating implementations (overriding members) of particular interface (class) in this class's bases list
* Code completion: option to not narrow down list of suggestions (as in VS intellisense)
Sunday, December 11, 2005
Writely has been around for a while now, and as usual I tried it out, without much of a purpose for doing so. Then Michael Arrington did a review in TechCrunch, and I had a second look.
The WYSIWYG features are nice, being able to collaborate is also useful, but I think, if anything I'd use Writely mostly for it's blogging integration. We'll see. The AJAX wordprocessor market is getting crowded, and my attention span is limited.
Monday, December 05, 2005
I downloaded Attensa today to see if it would give me anything over RSSPopper which in general has served me well, but is a little skinny on the features. Primarily, the feature that drove me to download was the del.icio.us tagging support, but it also supports posting via Outlook, which could be useful as well (depending on how the html ends up). Then there’s also the Attensa toolbar for Firefox, which brings feed auto-discovery, in browser feed-reading, and a single button that brings the same functionality as the delicious and foxylicious extensions combined.
This may be a keeper.