Jakob,
This seems to work for me.
Thanks much!!!
Paul
-Original Message-
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 21, 2004 3:50 PM
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
i commited support for escaping
[mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 12:29 PM
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
use addLike(your_attribute,P%)
hth
jakob
Nase, Paul R. wrote:
I would like to perform a query where a description could have
, 2004 11:03 AM
To: OJB Users List
Subject: RE: Query with criteria - like using '%' or '_'
I assumed (AKA ass-u-me) that OJB does a database independent wildcard replacement.
For example, MSSQL uses % as the wildcard character, but ojb will replace a * with the
database specific wildcard
:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 11:03 AM
To: OJB Users List
Subject: RE: Query with criteria - like using '%' or '_'
I assumed (AKA ass-u-me) that OJB does a database independent wildcard replacement.
For example, MSSQL uses % as the wildcard character, but ojb will replace
in this
case you have 3 files to change - Criteria, a new LikeCriteria, and
SqlQueryStatement - instead of 2.
Paul
-Original Message-
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 11:45 AM
To: OJB Users List
Subject: Re: Query with criteria - like using
: Friday, February 20, 2004 11:45 AM
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
i'd prefer to have the whole escape handling in one place, in critria.
also i do not know if the escape handling is platform independent.
jakob
Nase, Paul R. wrote:
It shouldn't
Message-
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 11:45 AM
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
i'd prefer to have the whole escape handling in one place, in critria.
also i do not know if the escape handling
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
Nase, Paul R. wrote:
I don't think there are any platform issues, we aren't talking about
path names to look for files or anything like this. We are simply
Talking about an SQL92/SQL98 feature
: Re: Query with criteria - like using '%' or '_'
hi paul,
Nase, Paul R. wrote:
Jakob,
i just don't see why we can't construct the whole string in criteria.
in appendSelectionCriteria you simply append ESCAPE '\\' . why
can't this be done in criteria#generateSQLSearchPattern ?
We cannot
Braeuchi [mailto:[EMAIL PROTECTED] Sent: Friday, February
20, 2004 2:49 PM
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
Nase, Paul R. wrote:
Jakob,
i just don't see why we can't construct the whole string in criteria.
in appendSelectionCriteria you simply
sql wildcard, it won't query for
items that actually contain the '%' character.
Paul
-Original Message-
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 12:29 PM
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
use
, February 19, 2004 12:29 PM
To: OJB Users List
Subject: Re: Query with criteria - like using '%' or '_'
hi paul,
use addLike(your_attribute,P%)
hth
jakob
Nase, Paul R. wrote:
I would like to perform a query where a description could have a '%' or an '_'. Is this possible using QueryByCriteria
12 matches
Mail list logo