Category being overwritten

[CPW-Carl]

Nice script you guys have here. I am working with data that has been imported from another application. David either did the conversion, or had somebody do it, I'm not exactly sure.

When I create a new category, I find it is taking over an existing category. ie. Whatever I write in the name, url, description for a new one, gets implemented in an existing category.

I was looking through the database, and wondering the purpose of the PLD_CATEGORY_SEQ table. All it contains is a number, and I am wondering the purpose of this number. Coincidently the number in this table is the name number as the category id which just got taken over.

[David]

Content visible to registered users only.

Yep, I had requested specifically the sequence table be given to you also. I should have checked it before I gave it to you....sorry for that. I don't recall exactly the answer right now, but I'll have it for you shortly.

[Ap0s7le]

Hello Carl, we're sorry for your inconvenience.

The PLD_CATEGORY_SEQ table should match the highest ID of the PLD_CATEGORY table.

If you have any questions, comments and or suggestions feel free to contact David or myself and we will handle them.

Thank you for your time.

Sincerely

-Casey

[CPW-Carl]

After I posted I figured I would change it and see what happened, so I set the seq number to the highest id in the category table and it is working fine now.

Thanks.