Hi, Firstly I thought I would reply to this existing thread as I believe my situation is similar. I'm using oracle and have an index on a varchar field that I would like to do a case insensitive search still using the index on last_name since I know all my last_name start with a capital. e.g select * from user where last_name = 'smith' will use the index but not return any Smith's because of the upper case 'S' and if I did a: select * from user where upper(last_name) = 'SMITH' The select would not use my index and do a full table scan. What I would like to do is select * from user where last_name = initcap = 'smith' Which would return the rows and still use my index. Is there an easy way of doing this instead of using: a) Use _javascript_ to change the form field to Smith instead of smith b) ERXJDBCAdaptor c) subclass the OraclePlugIn Regards David On 02/08/2006, at 8:49 PM, Anjo Krank wrote:
|
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
