Javascript Everyone Should Know - Iterating URL Args

Here's some javascript I'm often looking for, because I can't remember it off the cuff after 3 months of LINQ coding and I've started writing something where JQuery isn't available...

It iterates through all the parameters and their arguments passed in the URL...

var url = window.location.toString();
var query_string = url.split('?')[1];
var params = query_string.split("&");
for (var i = 0; i < params.length; i++)
{
var name = params[i].split("=")[0];
var arg = params[i].split("=")[1];
alert(i+': '+name+' = '+unescape(arg));
}

Simple Category Tree Walking In T-SQL

I needed, as many have done before me, to create a snippet of SQL which was short and fast and returned a flattened table of tree nodes. In short, if you have a tree of nodes, get all the nodes below a specified node. The result is surprisingly simple and straightforward. Here it is, both as a snippet and a stored procedure. Assume the tree is stored in a table called Category, with CategoryID being the primary key and ParentCategoryID being the foreign key, to the same table, but nullable...

--------------------

declare @collect table ( catid int, tlevel int )

insert into @collect values (3,1)

declare @count int

set @count = 2

declare @maxlevel int

set @maxlevel = 2

while ((select count(1) from @collect where tlevel = @count-1) > 0 and @count <= @maxlevel)

begin

insert into @collect

select c.categoryid, @count

from category c inner join @collect b on c.parentcategoryid = b.catid and b.tlevel = @count-1

set @count = @count + 1

end

select * from @collect order by tlevel

--------------------

--------------------

CREATE PROCEDURE [dbo].[GetCategoryTree]

-- Add the parameters for the stored procedure here

@ParentCategoryID int

AS

BEGIN

-- the category id's to be output

declare @collect table ( catid int, tlevel int )

insert into @collect values (3,1)

-- a loop counter used to limit the depth we go to

declare @count int

set @count = 2

-- the deepest level to go to

declare @maxlevel int

set @maxlevel = 2

-- the loop to collect category id's

while

(

(select count(1) from @collect where tlevel = @count-1) > 0 -- keep going while we have categories

and @count <= @maxlevel -- keep going until the max level depth is reached

)

begin

-- insert the categories where the previous level contains the parent ids of the current level

insert into @collect

select c.categoryid, @count

from category c inner join @collect b on c.parentcategoryid = b.catid and b.tlevel = @count-1

-- increment the level being collected

set @count = @count + 1

end

-- return the found category id's

select * from @collect order by tlevel

END

--------------------

Writing Windows Services

Just found a really neat (as in compact) post on writing Windows Services in C#:

• http://industriousone.com/blog/writing-windows-services-c

And here's some Windows Services resources for doing different things in a service:

• http://msdn.microsoft.com/en-us/vcsharp/aa336739.aspx

Present!