I've read some posts about it, but none gave me the answers i needed.
http://www.gossamer-threads.com/...n%20category;#111038
I'm using multiple categories. A lot of my links have several subcategories (provinces in my case) where they are listed. A company can be active in several provinces, but i want to flag the province where they are operating from.
So, in CatLinks i created a new field called 'main'. Further more, i've created a field in 'Links' called 'Province' (This is the province where the company is operating from). Now, can anyone help me create a global that will compare the 'Province' field with the categoryname (the subcategories are provinces) and if this is true put a 1 in the 'main' field under CatLinks and if this is false put a 0 in that field.
Now order the link listing in the province category so that the companies who operate from that province come first, then the companies who are active in that province but do not operate from that province; Main DESC.
Thanks, Dirk
http://www.gossamer-threads.com/...n%20category;#111038
I'm using multiple categories. A lot of my links have several subcategories (provinces in my case) where they are listed. A company can be active in several provinces, but i want to flag the province where they are operating from.
So, in CatLinks i created a new field called 'main'. Further more, i've created a field in 'Links' called 'Province' (This is the province where the company is operating from). Now, can anyone help me create a global that will compare the 'Province' field with the categoryname (the subcategories are provinces) and if this is true put a 1 in the 'main' field under CatLinks and if this is false put a 0 in that field.
Now order the link listing in the province category so that the companies who operate from that province come first, then the companies who are active in that province but do not operate from that province; Main DESC.
Thanks, Dirk