Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

Re: How can I delete links from 100 to 2500 ?

Dec 21, 1999, 2:16 PM
pugdog
Veteran / Moderator (6956 posts)
Dec 21, 1999, 2:16 PM
Views: 2547
Shortcut
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).]
Subject Author Views Date
Thread How can I delete links from 100 to 2500 ? ekaram 2643 Dec 21, 1999, 1:11 PM
Post Re: How can I delete links from 100 to 2500 ? 		pugdog 2547 Dec 21, 1999, 2:16 PM
Post Re: How can I delete links from 100 to 2500 ? 		ekaram 2534 Dec 21, 1999, 2:40 PM
Post Re: How can I delete links from 100 to 2500 ? 		pugdog 2541 Dec 21, 1999, 11:31 PM
Post Re: How can I delete links from 100 to 2500 ? 		ekaram 2541 Dec 22, 1999, 5:04 AM
Post Re: How can I delete links from 100 to 2500 ? 		pugdog 2540 Dec 22, 1999, 7:05 AM