Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

How can I delete links from 100 to 2500 ?

Quote Reply
How can I delete links from 100 to 2500 ?
Hi,

I imported some ODP links to a category, but some of the links were added to my existing categories... and now it's a mess Frown

How can I delete links from x to xx ?

Why were some of the links imported to the specified category and some to my existing cats?

Thanks,
Emilio
Quote Reply
Re: How can I delete links from 100 to 2500 ? In reply to
If the links are at the END of the database, you can use the SQL monitor to

DELETE FROM Links WHERE ID > 100

(I'm pretty sure that will work).

IF you have other stuff after link 2500, then you would do something like:

DELETE FROM Links WHERE ID > 100 and ID <2500

You'd have to re-index the database and rebuild.


------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/









[This message has been edited by pugdog (edited December 21, 1999).]
Quote Reply
Re: How can I delete links from 100 to 2500 ? In reply to
It worked... thanks.

Do you know why Parse_RDF.pl appended some links to my existing categories and some to the one I indicated?
Quote Reply
Re: How can I delete links from 100 to 2500 ? In reply to
The Parse_RDF program sticks the links into the category they are in on ODP. So if you had a matching category it would probably put it there. If not, it would create the one that it was in on ODP. I have not looked at the current release (1.11) of the program -- Alex made some changes to it to allow the links to be directed to a subcategory .

If that's not working for you, explain what happened in more detail and let Alex take a whack at it Smile

Quote Reply
Re: How can I delete links from 100 to 2500 ? In reply to
OK...
I have several categories, and created another on to import ODP. Some links were added to my existing categories, and some under the new cat I created. BTW, the links didn't match the category they were supposed to be added.

I got the following output in every of the categories imported:

Topic: 10 (Top/World/Espa±ol/Negocios/MÚxico/Informßtica) - 43
Execute: Duplicate entry '1' for key 1 at Parse_RDF.pl line 222, <CONTENT_FILE>
Quote Reply
Re: How can I delete links from 100 to 2500 ? In reply to
A suggestion --

Post that last message as a new topic with the appropriate subject. Alex may not see it in this thread since it's a new thought.