Hi there
Can any one send me a procedure that performs the following operation
I am having a table consisting of MasterId(numeric,auto ,Primarykey) |
Parentid(numeric) | Title(varchar) | description(varchar) columns
if parent id=0 the data belongs to main or first level
if parentid=(existing)Masterid then the item belogs/or is a level with in
the master id it is having as parentid
This is just simulation of a tree structure
My Requirement is to delete all data under neeth the master id i have
selected for deletion
so this should delete all childs underneeth the given master and i want it
to be done within the serverside for minimum trips to Database server
A recursive procedure is to be written which deletes data from the table of
the selected masterid and all items unde it
Database Geniuses help me out of this Tree/Recursive Problem
Regards
Hari
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
