I just checked and it should work with 3.0.2.
Are you using JBossQL or EJB-QL. This is only supported by the JBoss
proprietary extension to EJB-QL as EJB-QL does not support the LCASE
functions and does not support LIKE clauses with functions on either side.
If you are using JBossQl in 3.0.2
This works for shure!
WHERE SUBSTRING(LCASE(Customer.name1), 1, LENGTH(?1)) = LCASE(?1)
I hope this can be helpfull to someone.
cya,
kiuma
Marius Kotsbak wrote:
> I have done something like that in 3.0.2 as well, and it seems to work!
>
> Dain Sundstrom wrote:
>
>> If you run Branch_3_0 (no
I have done something like that in 3.0.2 as well, and it seems to work!
Dain Sundstrom wrote:
> If you run Branch_3_0 (no binary release yet), you can use this syntax:
>
> LCASE(Customer.name1) LIKE LCASE(?1)
>
> -dain
>
> kiuma wrote:
>
>> How can I render a case insensitive searc ?
>>
>> Custo
Yes.
-dain
Emerson Cargnin - SICREDI Serviços wrote:
> doesn't 3.2beta incorporate this fix(feature) ?
>
> Dain Sundstrom wrote:
>
>> If you run Branch_3_0 (no binary release yet), you can use this syntax:
>>
>> LCASE(Customer.name1) LIKE LCASE(?1)
>>
>> -dain
>>
>> kiuma wrote:
>>
>>> How can
doesn't 3.2beta incorporate this fix(feature) ?
Dain Sundstrom wrote:
> If you run Branch_3_0 (no binary release yet), you can use this syntax:
>
> LCASE(Customer.name1) LIKE LCASE(?1)
>
> -dain
>
> kiuma wrote:
>
>> How can I render a case insensitive searc ?
>>
>> Customer.name1 LIKE ?1 is
If you run Branch_3_0 (no binary release yet), you can use this syntax:
LCASE(Customer.name1) LIKE LCASE(?1)
-dain
kiuma wrote:
> How can I render a case insensitive searc ?
>
> Customer.name1 LIKE ?1 is case sensitive
>
> LCASE(Customer.name1) = LCASE(?1) doesn't match partial pattern match
How can I render a case insensitive searc ?
Customer.name1 LIKE ?1 is case sensitive
LCASE(Customer.name1) = LCASE(?1) doesn't match partial pattern matching
Thanks,
kiuma
---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek hea
