I have a table inside access DB built like a tree, every record(=node) is a "title" that has a 'name' and 'paret' fields (and some other fields that are not relevant).
I'm simpley trying to print out all the tree's records but I keep getting only a path from the root record to the first leaf.
I have a recursive sub called 'deleteTitles' that needs to perform this task.
The var 'currentTitle' is the root node.
On every iteration of the sub I print one son of the current node 'T'. Code:
I need to write a recursive function and treeview using asp. It will show the manager and staffs under him/her. There will not be a fixed layer for the tree. Can someone guide me how to write?
I have adapted the code below but it gives me an error "exception occcured" after the first recursion. Any ideas what can be done to make the following code work. Code:
I've recently made a recursive sub in asp to search all folder and subfolders of the map "file" for a certain filename. It will list all results and show a link.
Now there's still a bug. I can't place files in the root because this script won't find 'em. The root i mean files.
If i replace the empty dir with Server.MapPath("") it will show the files in the root but it will show 'em twice. Code:
MS Access 2000 (host charges extra for SQL/MySQL) MS Windows Server 2003 (prod) / MS XP SP1 (dev)
..:: The setup:
The database has been setup with two tables;
tblDownloads tblCatagories
Each "download" consists of a catagory field that corresponds to fldID in tblCatagories. Each catagory, where the catagory is a parent, has a parent field of value: 0 and each child, has a field with a value corresponding to the fldID of it's parent. Code:
I'd want to make a custom class that will generate breadcrumb navigation for my site via a recursive query, e.g. Home > Page1 > Subpage 1. I've structured my database with hierarchical parent/child relationships.
I'm using ASP VBScript, and I have a table structure similar to the following: Code:
I have implemented a logic for my requirement with a recursive call. The logic is I need to get IDs from database for a scenario. There are corresponding records for each ID.
I need to store these IDs in an array variable. Then I need to get (dependent)IDs for the fields in each ID. There may be morethan one dependent per each ID. I append these IDs to my array. Like this it goes.
The problem is if there are many levels like this, the number of database cursor count is reaching to maximum and I'm getting the error
{Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded }
each recursive call runs a SELECT query.
Can any one suggest me an alternate solution for this ?
i am working on ecommerce site and would like to display the categories (and sub categories) from the db recursively, i did it but i also want to add the level of each category like : main_cat_1 (level 1) --------sub_1 (level 1_1) --------sub_2 (level 1_2) ------------sub_sub_2 (level 1_2_1) ------------sub_sub_2 (level 1_2_2) ------------sub_sub_2 (level 1_2_3) --------sub_3 (level 1_3) main_cat_2 (level 2) main_cat_3 (level 3) --------sub_3 (level 3_1)
I'm using the following function, which uses a recursive call. every time when I get a conf it opens a record set. So increases the cusor count. Some times I'm getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded.
I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:
I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.
Function ShowXML(strXML,strStyleSheet) Set objXML = CreateObject("MSXML.DOMDocument") Set objXSL = CreateObject("MSXML.DOMDocument") objXML.load(Server.MapPath(strXML)) objXSL.load(Server.MapPath(strStyleSheet)) Response.Write objXML.transformNode(objXSL) Set objXML = Nothing Set objXSL = Nothing End Function %>
calling the function in an asp file <%Call ShowXML("http://msn.foxsports.com/feedout/syndicatedContent?categoryId=142","nhl/xsl/news/teamNews.xsl")%>
the errors 1. the http:// part 2. and the ? mark
the error message says that the path has been typed wrong.
I am using the now() function to be displayed on an email after a form submission has been sent. The problem is that the server is not in the same timezone as I am for the result. How do I adjust the hours on the now() to allow for this please ?
I know the basic difference between a subroutine and a function is a subroutine performs a task and a function performs a task and returns a value. The Call keyword is required when using parens with subs with more than 1 parameters. Parens around values passed are ByVal vs ByRef and is a waste of processing if passed ByRef for no reason. I am told there is no reason to ever use a subroutine as a function can be used even if it doesn't return a value. While this appears to be true, is there any reason why it's ever a bad idea to use a function, instead of a subroutine, that doesn't return a value? Are there memory, performance, etc. issues?
I am trying to locate information on how to call a sub within VBScript on an ASP page but I can't locate generic information. What I want to do is generate a page that will stay up but the information on it will change based on a series of drop down boxes. I need the first drop down box to call a second dropped down box based on the state that is chosen then city and so on.
I have a column in the table which contains 2 full names seperated by "&" (e.g: Joe Smith & Jeff Scott) I want to display only the first names of the whole record in an asp page. Is there an asp function using which i can do this?
im using the mod function to create a calendar for me, which everything works perfectly, all is totally well with that! but...when i use the mod function it churns out this loooooooooong string which is the whole table... if there is some way that i can insert hard breaks IN THE CODE ITSELF.
I used to be quite an experienced ASP programmer but I haven't used it for a while
I’m trying to do something that I remember as very simple I'm trying to check that the value of a form text box is numerical using the isNaN function. The code I am using is:
<% quantity = Request.Form("number1")
if isNaN(quantity) = true then Response.Write "Your input was not a number" else Response.Write "Your input was a number" end if %>
var str = "A" 'convert to ascii num = asc(str) Response.Write num ' 65 shows up 'when I have a whole string str = "hello" str = mid(str, 1, 1) ' return 'h' num = asc(str)
'I get an error:
Invalid procedure call or argument:'asc'What can be done to fix this?
I've an array to store alphabets, in my code...in a random order. How can i use the Asc() function to get the equivalent Ascii of each alaphabaet of that array.... whenever i use ,
for i = 0 to NoOfElements Response.write Asc("ArrayName(i)") next
it displays 65, "NOOfElements" times (ascii of A)...on the other hand..i can't write
Response.write Asc(ArrayName(i))
since this shows some error...How can i solve this?
Depending on some situations, I or the user, need to execute a function (e.g., login, sending email, etc...) and then continue from the original place. How can I make one function to be available from any page from my site?
I have a problem with max() function. The SQL is as follow SELECT max(group_no) as group_no FROM doc_groups. if I run the sql in MS SQL server, it will return correct result. However when I run in ASP file, there is no record return. I check with RecordCount property and it return -1.
i need to write sql statment to compeare the first three letters btween input user and a field in a database, i used the Mid function but it seems there is something wrong ..
dim str1 str1= Mid((Form1.SiteName.value), 0, 2) <% strSQL = "SELECT EQUIPMENT_ID FROM ne.equipment_view WHERE Mid([EQUIPMENT_ID], 0, 2) = '&str1&'" %>
by the way i use dropdown list for user input ....
I need function that will recognize URL in some string. For ex. somebody in forum sends some text which is in variable TEXT. I want a function to look at it and if it finds www... , http://... or https:// - he has to change it into url link.
