Yup - It could also be used to solve the problem I discussed in this thread. It may be a bit different from dates but being able to slice of the actual category would be useful as well.
Example: Category = Region/Country/State/
When a user selects to place a link in that category it would be great to also split up the category name and save the Region, Country and State values in their own fields in the links table. That way they can simple be called as a tag from all the links templates.
I'm trying to do some geomapping (calculating distances between points) against my db and are running into the problem that the country and state for each link, which is pretty crucial for mapping) sits in the category table and not with the rest of the link info...
Safe swoops
Sangiro
Example: Category = Region/Country/State/
When a user selects to place a link in that category it would be great to also split up the category name and save the Region, Country and State values in their own fields in the links table. That way they can simple be called as a tag from all the links templates.
I'm trying to do some geomapping (calculating distances between points) against my db and are running into the problem that the country and state for each link, which is pretty crucial for mapping) sits in the category table and not with the rest of the link info...
Safe swoops
Sangiro