Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Combining DMOZ and existing data...

Quote Reply
Combining DMOZ and existing data...
Hi,

I'm trying to combine DMOZ data with data already existing in my database, however the dmoz links/categories have the same ID's as the existing links/categories. Is there an easy way to go about combining the two without conflicts?

I have tried this:

UPDATE CatLinks SET LinkID=LinkID+9000;

This successfully updated the ID's so they didn't conflict with the dmoz ID's but when I try:

UPDATE Links SET ID=ID+9000;

and

UPDATE Category SET ID=ID+9000;

...I get the following error:

ERROR 1062: Duplicate entry '9001' for key 1

I know I'm missing something simple but I don't get why it works for CatLinks but not Links and Category. Is this re-numbering even necessary?





Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Subject Author Views Date
Thread Combining DMOZ and existing data... Paul 2360 May 24, 2001, 2:11 PM
Thread Re: Combining DMOZ and existing data...
Paul 2282 May 26, 2001, 11:58 AM
Thread Re: Combining DMOZ and existing data...
pugdog 2250 May 27, 2001, 3:27 AM
Thread Re: Combining DMOZ and existing data...
Paul 2242 May 27, 2001, 6:32 AM
Thread Re: Combining DMOZ and existing data...
pugdog 2242 May 27, 2001, 9:49 AM
Thread Re: Combining DMOZ and existing data...
Paul 2238 May 27, 2001, 9:52 AM
Thread Re: Combining DMOZ and existing data...
pugdog 2233 May 28, 2001, 12:54 AM
Thread Re: Combining DMOZ and existing data...
Paul 2233 May 28, 2001, 6:38 AM
Thread Re: Combining DMOZ and existing data...
Dinky 2197 Jun 3, 2001, 1:28 PM
Thread Re: Combining DMOZ and existing data...
Paul 2220 Jun 3, 2001, 1:33 PM
Post Re: Combining DMOZ and existing data...
Dinky 2206 Jun 3, 2001, 5:35 PM