quote:

---

The {0} is a mathematical representation of the empty set

---

quote:

---

Er, no it isn't. It's a set containing one element: zero.
Empty set is {} or ∅ (U+2205)

---

I think that's what he meant Arnie. Easy on the guy!
I prefer my theory though!

Long live the {0}

quote:

---

Empty set is {}...

---

SET NOCOUNT ON

	--Get the Form ID so we can find out what the upper most node ID is
	DECLARE @intFormID int

	SET @intFormID = (select intUDFormID 
				from tblUDNode 
				where intUDNodeID = @intUDNodeID
				and intUDNodeObsolete = 0)

	
	--Now determine what Node ID is the upper most root node for the passed in Node ID
	DECLARE @intTopLevelParentID int

	SET @intTopLevelParentID = (select intUDNodeID 
					from tblUDNode 
					where intUDFormID = @intFormID
					and intUDNodeParentID IS NULL --Null parent ID is the Upper most Node
					and intUDNodeObsolete = 0)
	
	--Find out what the users profile is
	DECLARE @intProfileID int
	
	SET @intProfileID = (select intUserProfileID 
				from tblSysUsers
				where intSysUserID = @intUserId)

	--Now build a temp table that holds all the parent node ids for the passed in node
	
	DECLARE @tmpNodes TABLE
		(
			intUDNodeID int
		)

	--Insert the current node into the table 
	--This will handle hybrid nodes (nodes with a form but no databound child nodes)
	INSERT INTO @tmpNodes
				VALUES (
					@intUDNodeID
					)

	DECLARE @intFlag INT

	SET @intFlag = 1

	DECLARE @intCurrentNodeID INT

	--Now go get all the parent nodes and insert them
	--The loop will stop when it hits the @intTopLevelParentID node
	WHILE @intFlag = 1 
	BEGIN

		SET @intCurrentNodeID = (SELECT intUDNodeParentID 
					FROM tblUDNode 
					WHERE intUDNodeID = @intUDNodeID
					AND intUDNodeParentID <> @intTopLevelParentID)
	
	
		IF @intCurrentNodeID IS NOT NULL
		BEGIN
			INSERT INTO @tmpNodes
				VALUES (
					@intCurrentNodeID
					)

			SET @intUDNodeID = @intCurrentNodeID

		END
		ELSE
		BEGIN
			SET @intFlag = 0
		END
	END

	SET NOCOUNT OFF
	
	

	--Okay, we have the Profile, now check to see what the permission level is for 
	--the passed in node 
	
	SELECT 
		intCPPermissionDefaultID
	
	FROM tblUserProfile_Nodes

	WHERE intUserProfileID = @intProfileID
	AND intUDNodeID IN (select * from @tmpNodes)