Web Analytics Made Easy -
StatCounter lower OR upper case...search form & - CodingForum

Announcement

Collapse
No announcement yet.

lower OR upper case...search form &

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    shervell
    New to the CF scene
    Last edited by shervell; Jun 21, 2002, 06:26 AM.

  • #2
    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.

    Comment

    Working...
    X