Converting Things to Lowercase

  • I was having a little problem excepting all the different capitalizations in my calender, you know when you mouse over a date and the tool tip tells you the titles of entries. So I used
    UPDATE wp_posts SET post_title = LCASE(post_title);
    To convert all the titles to lowercase, of course this works for uppercase (UCASE), too. Just thought someone might find this useful. Remember to back up the database before you do anything new though ??
    PS. For those that don’t know, this is an SQL query no WP code was hacked. See the SQL manual.

Viewing 7 replies - 1 through 7 (of 7 total)

  • well i believe css could well be used… ??

    You could create classes to style the entries, which, in my personal opinion, is preferred over direct hacking of the code, since future upgrades my result in having to re-hack the code all over again.
    Example classes:
    .ucase { text-transform: uppercase;}
    .lcase { text-transform: lowercase;}
    You could use these classes in many ways:
    < span class=”ucase” >
    < p class=”lcase” >
    < h2 class=”ucase” >
    and so on.

    though i doubt it will change the case of the text in the tool tip! :S

    The Wiki needs food, badly.

    Thread Starter Chris

    (@chris)

    I use css to style my titles already.

    You could create classes to style the entries, which, in my personal opinion, is preferred over direct hacking of the code, since future upgrades my result in having to re-hack the code all over again.

    I did not hack any code..
    Why spend all day setting up nice styles for my tool tips? I just simply wanted all the titles in lowercase ??

    a layer in place of a tooltip?
    god save me…

    OK if I add that bit of code to my main page or somewhere can everything i type come up in lower case?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Converting Things to Lowercase’ is closed to new replies.