Or you could call the function:
Call passTwoValues(value1, Value2)
Look into this code snippet:
<%
QS = Request.Querystring("ID")
'Now pass the querystring to the following function.
if QS = trim(aCategory(0, iRows)) then
Call GetProducts...
Hi,
This is my result set from which I would like to show an indented hierarchy:
Emp_Name Indent Mgr_ID Sub_ID Lft Rgt
William McMonigal 4 862336 862336 604 617
David Block 5 862336 627298 605 606
Joseph Hennessy 5 862336 862337 607 608...
Using this query, I got the indentation of everybody in the orgstructure. I just showed the data for one top level manager - W. McMonigal so that you can see the indentation for him and his subordinated who have the indentation of 5.
The query I made to get this indented Org Structure is...
Even if I were to split the code, how my getProducts.asp call a Javascript function without having a script tag in the asp page as it is an embedded within the Categories_dynamic.asp
Wait a minute...as I am writing this message I noticed that when I view the page source, I cannot see the...
Hi,
I get an error at this line:
'/// Collect the Values wanted into the dictionary object
for i= lbound(aParams) to ubound(aParams)
aKeyValue = split(aParams(i),"=")
sIDX = aKeyValue(lbound(aKeyValue))
sParam = aKeyValue(ubound(aKeyValue))
dList.add sIDX, sParam
next...
Hi,
I have 2 seperate queries from a nested table structure.
This query returns the emp and his subordinates.
SELECT s2.*, dbo.Employee.FirstName + ' ' + dbo.Employee.LastName AS Emp_Name
FROM dbo.Stack1 s1 INNER JOIN
dbo.Employee ON s1.employee =...
Code above is the Javascript.
For the ASP part, it is below:
<a href="#" class="a_style" onclick="showProducts(<%=aCategory(0, iRows)%>);s_Hide('<%=aCategory(0, iRows)%>'); return false;"><%=aCategory(1, iRows)%></a>
<ul id="UI_<%=aCategory(0, iRows)%>">
<div...
Hi,
Thanks for the response. The above code is one single ASP page. It is the entire code. Is It too much to ask you to try it your machine and see how it works now?
I first use the server to load only the top level category - in this case 1 which is "Beverage". I use AJAX function...
If I do a SQL Statement:
Select Max(Indentation) from View_OrgStructure_Indent
I get a value of 5, but I do not want to hardcode that value into the ASP page.
Hi,
I am using SQL Server 2000. I am using Joe Celko's example of nested set model. I am trying to implement his example for hierarchical structures. So his example must be based on Oracle.
Thanks.
Hi,
I built indentation that would show the the hierarchy of the people in the org structure in the SQL Server database. So I have got rows with values like this:
Indentation Employee
1 4655
2 5623
2 8956
2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.