Using SPLIT()

[timcadieux]

Ok, i have a dilemna. I have a Field for our articles called Category. Inside, I have things ie., Car, Boat, Plane.

I allow my users to insert multiple categories, therefore, I was using Split() to read things like "car, boat". My problem is that I need to offer the same info in French. I really DO NOT want to go back and re-tag all my Articles with a new field called Category_F.

What i was hoping to perhaps do was translate each category and hopefully do something like the following:

boat|bateau, car|voiture. I guess my dilemna is first, is this a good idea and secondly, can i come up with a good Script to Split the categories and then display the English on the English page and the French on the French page!

I hope this is clear?

 

[DotNetGnat]

i would suggest you create a new field that has the equivalent french names...sounds logically and efficient...

-DNG

 

[Sheco]

Are there a fixed number of categories from which users can choose?

If so you can maybe add a field to your category table:[tt]
CatID CatName FrenchName
----- ------- ----------
1 boat bateau
2 car voiture
[/tt]

Then you could just use a different SQL statement if the user if viewing the categories in french...

 

[DotNetGnat]

but Sheco, it seems that timcadieux is not happy with creating a new field...

-DNG

 

[Sheco]

No I didnt mean to retag all the items... just add a new field to the table of categories... assuming there is such a thing.

 

[DotNetGnat]

yeah..thats was i suggested...create a new field...

-DNG

 

[timcadieux]

No fixed number and i was hoping to avoid adding a new field, argh....

 

[Sheco]

Maybe you could make a new "translation" table and query against that.

 

[Sheco]

So that your code first grabs all existing categories for an Article and then, for each category go back and query for the translation... it wouldn't be very efficient and you'd have to compensate for the fact that perhaps there is no translation in the table... so it wouldnt be a perfect solution but it would kinda work.

 

[Sheco]

So is the reason the title of this thread mentions the Split() function because the categories are stored in a comma separated list in a single field?