Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [Palehorse777] Lower Case Directory Names, but Multi-case Category names

Quote Reply
Re: [Palehorse777] Lower Case Directory Names, but Multi-case Category names In reply to
In Reply To:

I did this:
Enter mysql monitor (backup database first)
Do this for the whole aphabet (one at a time):
UPDATE lsql_Category SET Full_Name = REPLACE(Full_Name,"A","a")
UPDATE lsql_Category SET Full_Name = REPLACE(Full_Name,"B","b")
etc etc

The result is lower case directories and since you are only changing the filed "Full_Name" the <%category%> tag will still output the upper case directory names on the home page and category pages.

I am sure there is an easier way to do this, but I am a novice. Bottom line is that it works.

Mike
Yep, there is an easier way with one query...

Code:
UPDATE lsql_Category SET Full_Name = lower(Full_Name);
Subject Author Views Date
Thread Lower Case Directory Names, but Multi-case Category names DogTags 10514 Sep 22, 2002, 4:18 PM
Thread Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
DogTags 10307 Oct 12, 2002, 10:24 AM
Thread Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
Andy 10295 Oct 12, 2002, 11:45 AM
Thread Re: [Andy] Lower Case Directory Names, but Multi-case Category names
DogTags 10254 Oct 13, 2002, 9:41 PM
Post Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
Andy 10279 Oct 14, 2002, 1:04 AM
Thread Re: [Andy] Lower Case Directory Names, but Multi-case Category names
Paul 10287 Oct 14, 2002, 2:38 AM
Post Re: [Paul] Lower Case Directory Names, but Multi-case Category names
DogTags 10266 Oct 14, 2002, 4:47 AM
Thread Re: [Paul] Lower Case Directory Names, but Multi-case Category names
DogTags 10262 Nov 4, 2002, 7:21 AM
Post Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
afinlr 10187 Nov 5, 2002, 9:11 AM
Thread Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
Clint 10218 Nov 6, 2002, 3:32 AM
Post Re: [Clint] Lower Case Directory Names, but Multi-case Category names
afinlr 10188 Nov 6, 2002, 3:54 AM
Thread Re: [Clint] Lower Case Directory Names, but Multi-case Category names
afinlr 10144 Nov 6, 2002, 4:01 PM
Thread Re: [afinlr] Lower Case Directory Names, but Multi-case Category names
Clint 10127 Nov 8, 2002, 3:54 PM
Post Re: [Clint] Lower Case Directory Names, but Multi-case Category names
afinlr 10123 Nov 8, 2002, 4:05 PM
Post Re: [Clint] Lower Case Directory Names, but Multi-case Category names
DogTags 10143 Nov 7, 2002, 12:53 PM
Thread Re: [Clint] Lower Case Directory Names, but Multi-case Category names
DogTags 9623 Jan 25, 2006, 5:35 AM
Post Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
brewt 9586 Jan 25, 2006, 12:29 PM
Post Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
dearnet 10237 Nov 6, 2002, 10:40 PM
Thread Re: [DogTags] Lower Case Directory Names, but Multi-case Category names
Palehorse777 9874 Feb 8, 2004, 12:24 PM
Post Re: [Palehorse777] Lower Case Directory Names, but Multi-case Category names
paulj 9856 Feb 8, 2004, 8:35 PM