Cleopatra
Posts: 73
|
| Posted: 03/10/2010, 6:44 AM |
|
Hi,
I'm using CCS 4.2, Oracle and PHP
Need some help with the searches. All my searches are case sensitive, I've tried using the Upper() function in the sql query but to no avail. I only get the results typed in just as they are stored in the database.
Any ideas anyone?
_________________
php newbie |
 |
 |
melvyn
Posts: 333
|
| Posted: 03/10/2010, 8:04 AM |
|
That's up to your databse, not codecharge. Check your table, the column you're searching, it's defined as case sensitive. Make it case insensitive.
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
mrachow
Posts: 509
|
| Posted: 03/15/2010, 9:30 AM |
|
When using upper() you have to "upper" both sides, e.g. upper(<your_column>) = upper(<literal>)
_________________
Best regards,
Michael |
|
|
|
|
