During a recent change of server, import etc ... I now have a couple of thousand (I believe) links without a category!

Does anyone have any solutions how I can: -

1. Search for links without a category;or
2. Fix this problem without getting sore fingers!!

It's a real problem .... and I've asked this question before but no one seems to have an answer. Any help would be appreciated.


Regards,


Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory

Hi,

The next version will have this built in, but to generate a list of Link ID's that are not in any category you could do:

SELECT Links.ID
FROM Links LEFT OUTER JOIN CatLinks ON Links.ID = CatLinks.LinkID
WHERE CatLinks.LinkID IS NULL

Then when you have the list of ID's you need to do:

INSERT INTO CatLinks (LinkID, CategoryID) VALUES (1,1), (2,1), (3,1), (4,1), ...

where 1,2,3,4 is the link id's, and the other 1 is the category id you want to insert it into.

Hope this helps,

Alex

--
Gossamer Threads Inc.

Thanks Alex:

I was able to bring up the list alright (once I remembered the _ prefix!).

I have about 2000 links - is there any command in msqlMonitor that I can use to move ALL of these in one hit to a temporary category so I can work on them a lot easier (other than going one at a time!).

Thanks again,

Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory

Alex:

Please don't worry about my last post ... I sorted it out ... A bit of cut and paste and Textpad did the trick!

Thanks,

Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory