Removing items from todo list

User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Removing items from todo list

Post by Thunderstone »



I managed to add a page at members.aol.com to the todo list in such a
way that gw is now prepared to index every page it can find on that
machine -- which isn't quite what I had in mind, since it seems that
everybody there references everybody else's pages. <sigh>

I've tried several things like

gw -d- -s "delete from todo where Url like '/members.aol.com'"

but as far as I can tell the command is just echoing as if it were
select; the items seem to still be there when I do a select.

What is the best way to rescue the situation?


User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Removing items from todo list

Post by Thunderstone »




SQL delete echos everything it deletes.
gw -s "select Url from todo"
will tell you if you were successful.

You also need to delete undesired pages from your html and
refs table according to the examples in the manual.
You may also want to delete it from the options table:
gw -s "delete from options where Name='URL' and String like '/members.aol.com'"

Make sure you are using the correct command line syntax and
not running arguments together.
This is correct: gw -s "select Url from todo"
This is not: gw -s"select Url from todo"

If you were to do the second, gw would not see your query and
perform a default one of "select Url from html".

If you want to walk just a particular section of a site, you can use
the -j option:
gw -jhttp://members.aol.com/joebob/ http://members.aol.com/joebob/
will walk http://members.aol.com/joebob/ without wandering all over aol.