RE: Query with criteria - like using '%' or '_'

2004-02-23 Thread Nase, Paul R.
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

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread 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 addLike(your_attribute,P%) hth jakob Nase, Paul R. wrote: I would like to perform a query where a description could have

RE: Query with criteria - like using '%' or '_'

2004-02-20 Thread Nase, Paul R.
, 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

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
:[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

RE: Query with criteria - like using '%' or '_'

2004-02-20 Thread Nase, Paul R.
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

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
: 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

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
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

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
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 '_'

2004-02-20 Thread Jakob Braeuchi
: 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

Re: Query with criteria - like using '%' or '_'

2004-02-20 Thread Jakob Braeuchi
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

RE: Query with criteria - like using '%' or '_'

2004-02-19 Thread Nase, Paul R.
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

Re: Query with criteria - like using '%' or '_'

2004-02-19 Thread Jakob Braeuchi
, 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