|
Posted by Anon on 10/13/26 11:25
Im wondering if someone could help me with a recursive style sql command
section = SectionID, parent
I want to be able to delete a row where SectionID=X but also delete any
section that matches SectionID.
Kinda like the hierarchy of folders on your harddrive.
I want to delete any subfolders of the main folder I am deleting.
Can anyone give me some direction, my SQL isn't up to all that much.
Ive got the following but its more pseudo code rather than something I
expect to work.
DELETE *
FROM jss_sections
WHERE Parent=SectionID AND (DELETE * FROM jss_sections WHERE
SectionID.new=Parent)
TIA
Simon
Navigation:
[Reply to this message]
|