Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Case Sensitivity
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Case Sensitivity
 Login/Join
 
Silver Member
posted
Hi,

I am developing a launch page where there are text boxes for firstname,lastname.The requirement is when the user enters firstname in lowercase letters it should be converted into CAPS,because firstname is stored in CAPS in the database.To achieve this I am using UPCASE() function.

Now there is new requirement,where firstname can be in uppercase or lowercase or mixedcase in the database.
for example if the user enters 'temp' in the textbox and we have 'Temp','TEMP','temp' in the database.user should be able to see all the three records.

Can somebody put some thoughts into this.Thanks.

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.7
windows
Html,Pdf and Excel
 
Posts: 39 | Registered: September 03, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
Try using the UPCASE function on both the input field and the database field. I did that and it works.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Which database?

If you're using SQL Server then the COLLATION settings may help.

See some ideas here.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thankyou both RSquared and njsden.
I tried both the ways and they worked fine for me.
The COLLATION setting is very helpful.


WebFOCUS 7.6.7
windows
Html,Pdf and Excel
 
Posts: 39 | Registered: September 03, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Case Sensitivity

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.