The Site With the Lamp

June 10, 2004

I have never aquired a liking for link checkers. Never bother to use them. For that reason some of my sites do have a few broken links.

Aspseek, my favourite search engine has the solution. Once you run the index, do this query on your ASPSeek database taking care to replace localhost with your site's name.

select a.url,b.url from urlword a, urlword b where a.status=404 and a.referrer = b.url_id and a.url like 'http://localhost%';

It will give you a nice listing of all the pages that were reported as missing and the pages that linked to them.