2. ASPRunnerPro General questions
  3. Case sensitive in search function
This topic is locked

Case sensitive in search function

 		8/11/2004 5:19:25 AM
ASPRunnerPro General questions
P
 paho01 author

I dont want my search function to be case sensitive because when people do the search they doesn´t know if there is upper case or lower case in the word they search for.

Does anyone know how to change to be not case sensitive?
Sergey Kornilov admin 8/11/2004

Hi,
take a look at this post that explains how to build case insensitive search:

http://www.asprunner.com/forums/index.php?...ic=187&hl=ucase
I hope this helps.
P
 		paho01 author 8/12/2004

Hi,
Thanks for your answer, but it didn´t work. I get this erroe message when I do the search.
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[Oracle][ODBC][Ora]ORA-00904: invalid column name

/apps/DATA_list.asp, line 516
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:

POST 806 bytes to /apps/DATA_list.asp
POST Data:

TargetPageNumber=1&sourceID=&cmdGotoPage=&action=Search&SQL=select+VERSIONSID%2C+++PROGID%2C+++VERSION%2C+++SERIALNUM%2C+++BELONGING%2C+++BOUGHT%2C+++PLATTFORM%2C+++NUMLICENSE%2C+++DEALER%2C+++PURCHAS . . .
Time:

Thursday, August 12, 2004, 8:26:19 AM
Sergey Kornilov admin 8/12/2004

Hi,
this example won't work for Oracle because Ucase function is Microsoft specific. Instead of Ucase you need to use another Oracle function that converts text values to uppercase.