Hi,

Is there an easy way to force a payment option setting onto all the sub-cats (children?) of a category?

Cheers,
Shaun

There currently isn't an easy way of doing it, but I'll add it to my todo list.

Adrian

Thanks Adrian, looks like I'll have to do it manually then ... oh well

Actually, could I use SQL Monitor to blanket change the children of a category by using the Full_Name field?

Maybe something like:

UPDATE lsql_Category SET Payment_Mode="x" WHERE Full_Name="xxxx";

How would I format the query so that the Full_Name matched only the start of the field, e.g.; match "Society and Culture/Relationships" but NOT "Business and Economy/Shopping/Society and Culture"?

Cheers,
Shaun

WHERE Full_Name LIKE 'Society and Culture/%'

Adrian