Hi Carey,
Thanks for your suggestion.
I tried replacing the query with following:
( 'Vendor Name' LIKE ( "[Aa]" + "%" ))
but this does not return any results (There are about 20 Vendors beginning with the letter A) , may be this has to do with the database (Oracle 9.2) not supporting regular expressions.
I enabled the SQL log and tried to execute the query directly, but even that does not return any results.
Please let me know if there is any alternate solution to this problem.
Here are the server details( Sorry for not mentioning this earlier):
AR Server 6.3 patch 13
Mid-tier 6.3 patch 15
Solaris 9
Oracle 9.2
Apache 2.0.54
Jakarta tomcat-5.5.9
jakarta tomcat connector 1.2.6
Mid-tier 6.3 patch 15
Solaris 9
Oracle 9.2
Apache 2.0.54
Jakarta tomcat-5.5.9
jakarta tomcat connector 1.2.6
Thanks,
Prasan.
On 7/24/06, Carey Matthew Black <
[EMAIL PROTECTED]> wrote:
Prasan,
How about you muck with the value the user gives you before the search?
if:
$VendorName$ = "AdFtt"
Then
you fix it to be: "[Aa][Dd][Ff][Tt][Tt]"
And your resulting LIKE operation should be "case insensitive".
(('Vendor Name' LIKE ( "[Aa][Dd][Ff][Tt][Tt]" + "%" ))
An Active link guide that keeps track of which character it is
processing, and creates a "[<UPPER($LETTER$)><LOWER($LETTER)>]" (set
of 4 characters) for every character it finds in the field should get
the job done.
[ I guess I am just in a loop'ing mode today. I keep answering
questions with the same basic idea. :) ]
Or you could go for ARS FTS licenses. :)
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.
On 7/24/06, Prasan Katti < [EMAIL PROTECTED]> wrote:
> **
> Hi List,
>
> We have developed a customized workflow application and we are having
> problems with one of the set field condtions.
> We have a Vendor Form master data which basically consists of the Vendor
> name and Vendor Address.
> I have the same two fields in another form which is used to create the
> tickets, the users type in the first few letters of the vendor name and
> click on a search button.
> If there are multiple requests matching the query, we display a list and if
> no requests match we show an error.
> The problem we are facing is that the following query in the set field
> action of the button click is case sensitive
> ('Vendor Name' LIKE ( $VendorName$ + "%" ))
> The Vendor Name data in the master form is a mixture of Capital and Small
> case letters, and should match with any data the users type.
> Is it possible to implement a case insensitive search in this scenario??
> We have ruled out using a direct SQL because for multiple request match, the
> list diplays the header as Column1 and Column2 instead of "Vendor Name" and
> "Vendor Address".
>
> Any help is greatly appreciated.
>
> Thanks,
> Prasan
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
