Ocean10000 - 3:53 pm on Nov 17, 2010 (gmt 0)
Is variable2 a category name or something similar that has both a English and French name given?
If it is you can do a simple sql statement looking for the name in the french table if it is not found then no redirect is necessary.
But if it is found, match it to its equivalent in the English version of the table and then do a simple redirect. You can do this code in the Global.asa file so it applies for all classic asp code.
Yes I am ignoring Referrer's as a way to determine if it should be redirected, as it not always returned.