Dave Crandall
|
| Posted: 01/13/2003, 4:33 AM |
|
Looking for the method to force an uppercase search against Oracle db.
ex:
john doe entered into the keyword box.
No records returned because db contains all uppercase characters.(JOHN DOE)
|
|
|
 |
Dave Crandall
|
| Posted: 01/13/2003, 4:36 AM |
|
Forgot to mention specs.
CodeCharge Studio.
W2K/IIS5 web server.
CF 5
Oracle 8I
|
|
|
|
RonB
|
| Posted: 01/13/2003, 7:42 AM |
|
Use the upper or lower function in your sql statments.
build the grid and search with query builder switch, in query builder, to sql and adapt the statement. Where the parameter is mentioned you add upper('{yourparameter}')
That should work
Ron
|
|
|
|
|
