Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Removing Entire Categories

Mar 23, 2001, 6:57 AM
pauls
User (61 posts)
Mar 23, 2001, 6:57 AM
Post #1 of 3
Views: 1424
Shortcut
Quote Reply
Removing Entire Categories
Is there an easy way to remove an entire group of categories and all their links associated with them? I imported the entire DMOZ database recently and want to remove the entire WORLD and ADULT categories. I don't have time to do it by hand as there is thousands of links. :)

Thanks again,

Paul


Mar 23, 2001, 7:47 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Mar 23, 2001, 7:47 AM
Post #2 of 3
Views: 1396
Shortcut
Quote Reply
Re: Removing Entire Categories In reply to
Code:

DELETE FROM CatLinks WHERE CategoryID = 'somenumber';


via the SQL Monitor.

Regards,

Eliot Lee
Mar 23, 2001, 8:07 AM
pugdog
Veteran / Moderator (6956 posts)
Mar 23, 2001, 8:07 AM
Post #3 of 3
Views: 1386
Shortcut
Quote Reply
Re: Removing Entire Categories In reply to
go to the browser, and delete the top category.

Because of time outs, I might go to the second level and delte the
subcategories, but when you delete a category, all it's subcategories and links are deleted due to the way the tables are related.

PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum