Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jun 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question lower OR upper case...search form &

    re: non case senstive search throgh html form querying oracle database - quite a few folks have given me code or ideas could for 2 search boxes for upper & the other for lower case data but is there a way to have one submission & query the database on both lower & upper case & return the results?

    cheers

    g
    Last edited by shervell; 06-21-2002 at 10:26 AM.

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Posts
    626
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I believe that you are going to have to do this on the Server Side rather than the Client side. You will need to convert the data in the database to either Upper Case or Lower Case or both to make it effective. This probably would involve pulling the data into a temporary variable and performing the Upper/Lower Case conversion then comparing it to the search value.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •