Hi,
Actually, you wouldn't need the ID numbers for the links. This is because the CatLinks table has two fields:
LinkID and CategoryID
The SQL commands noted would only find those records in the CatLinks table where the CategoryID matches the one you specify. Then it will only find the Links records where the LinkID matches the CategoryID, and it will then set the isValidated field = No only for those link ID numbers.
So basically you wouldn't need to specify any LinkID's as it can find these from the CatLinks table when you specify the category ID. Kind of confusing, I agree. I tried it and it worked, but I would test it first with a custom field Validate_Test as noted in the previous post. And if you don't feel comfortable doing it, then it might be best not to try as mistakes in SQL Monitor can cause big problems. I just wanted to provide a solution that worked for me.
--Frank
Actually, you wouldn't need the ID numbers for the links. This is because the CatLinks table has two fields:
LinkID and CategoryID
The SQL commands noted would only find those records in the CatLinks table where the CategoryID matches the one you specify. Then it will only find the Links records where the LinkID matches the CategoryID, and it will then set the isValidated field = No only for those link ID numbers.
So basically you wouldn't need to specify any LinkID's as it can find these from the CatLinks table when you specify the category ID. Kind of confusing, I agree. I tried it and it worked, but I would test it first with a custom field Validate_Test as noted in the previous post. And if you don't feel comfortable doing it, then it might be best not to try as mistakes in SQL Monitor can cause big problems. I just wanted to provide a solution that worked for me.
--Frank