Re: wildcard Query

2010-11-11 Thread ISHIMOTO Ken
attern.compile("\\Q*\\E"); >>m = p.matcher(input); >>if (m.find()) { >>System.err.println("test starts" + >> " with * signs...input: " + input); >>} >> But then the

Re: wildcard Query

2010-11-10 Thread Cheong Hee (Gmail)
Message - From: "Mark Wardle" To: "Cheong Hee (Gmail)" Cc: "ISHIMOTO Ken" ; "WebObjects Development" Sent: Thursday, November 11, 2010 5:37 AM Subject: Re: wildcard Query I think I'd do this with raw SQL. I needed to execute raw SQL to optim

Re: wildcard Query

2010-11-10 Thread Mark Wardle
downside is you will have to enumerate each string one at a > time. > > Cheers > > Cheong Hee > > > - Original Message - > From: ISHIMOTO Ken > To: Farrukh Ijaz > Cc: WebObjects Development > Sent: Wednesday, November 10, 2010 5:44 PM > Subject: Re: wi

Re: wildcard Query (Read-Attribute in EOModel)

2010-11-10 Thread arosenzweig
Hi Ken and everyone :-) Farrukh's solution is ok but as he also pointed out, it is "in-memory" and will only work on small data sets. Amedeo's solution is "memory-stable" but requires a schema change and data duplication / synchronization (on edits). Here's another solution: Consider adding

Re: wildcard Query

2010-11-10 Thread ISHIMOTO Ken
Hallo Amedeo, That is a way that I maybe try to go. But I will changed maybe the Original Data. I think it is not possible to make a new column. Because this Database has about 500 Columns with that kind of Data. I have to make 500 new Columns, and that is a Problem. The best way is to make the

Re: wildcard Query

2010-11-10 Thread Farrukh Ijaz
Hi Ken, I spent some time exploring all the possibilities at the EOF level but it looks like it does not work at the EOF level. I also inspected the PostgresPlugin and found that the escape character is "|" instead of "\\" but still it doesn't work. If your data is not very large, you can do so

Re: wildcard Query

2010-11-10 Thread ISHIMOTO Ken
Hi Farrukh, Sounds nice, I will take a look at that and give you feedback. On 2010/11/10, at 10:09, Farrukh Ijaz wrote: > Hi Ken, > > I spent some time exploring all the possibilities at the EOF level but it > looks like it does not work at the EOF level. I also inspected the > PostgresPlugi

Re: wildcard Query

2010-11-10 Thread Amedeo Mantica
Hello Ken, After reading the other responses I figured out a possible solution but requires a bit of database change... Assumed that we know that there is no way to search for " * ", we need to search for something else... So, add a new column in your table where you will put the same value o

Re: wildcard Query

2010-11-10 Thread Cheong Hee (Gmail)
" with * signs...input: " + input); } But then the downside is you will have to enumerate each string one at a time. Cheers Cheong Hee - Original Message - From: ISHIMOTO Ken To: Farrukh Ijaz Cc: WebObjects Development Sent: Wednesday, November 10, 2010 5

Re: wildcard Query

2010-11-09 Thread Cheong Hee (Gmail)
May be go back to the basic quailifier - EOQualifier.qualifierWithQualifierFormat and use "name like %@" with "*"? - Original Message - From: ISHIMOTO Ken To: WebObjects Development Sent: Tuesday, November 09, 2010 10:34 PM Subject: wildcard Query H

Re: wildcard Query

2010-11-09 Thread ISHIMOTO Ken
No On 2010/11/09, at 15:48, Farrukh Ijaz wrote: > Try using "*[*]*" and see it works? > > Farrukh > > Sent from my iPhone > > On 2010-11-09, at 5:34 PM, ISHIMOTO Ken wrote: > >> Hi everyone, >> >> I am fighting with a Qualifier and my Question is "Is there any way for >> query all Data wit

Re: wildcard Query

2010-11-09 Thread Farrukh Ijaz
Try using "*[*]*" and see it works? Farrukh Sent from my iPhone On 2010-11-09, at 5:34 PM, ISHIMOTO Ken wrote: > Hi everyone, > > I am fighting with a Qualifier and my Question is "Is there any way for query > all Data with an "*" in." > > DataSample : > > Mike > Chuck > Dav*id > Ken > >

Re: wildcard Query

2010-11-09 Thread Mike Schrag
unfortunately, that it doesn't work, at least not in 5.4. On Nov 9, 2010, at 9:58 AM, Stefan Klein wrote: > You need escape the character. Normal is the Backslash the escape sign. > > EOQualifier qualifier = M_User.NAME.contains("\\*"); <-- 2 Backslashes for > java > > Stefan > > Am 09.11.1

wildcard Query

2010-11-09 Thread ISHIMOTO Ken
Hi everyone, I am fighting with a Qualifier and my Question is "Is there any way for query all Data with an "*" in." DataSample : Mike Chuck Dav*id Ken Like code bellow but the "*" is a Wildcard and won't work. EOQualifier qualifier = M_User.NAME.contains("*"); I would love to find any Reco

Re: wildcard Query

2010-11-09 Thread Mike Schrag
it looks like underlying pattern scanner supports escaping, but it doesn't expose that state to the pattern matcher, so an escaped * appears to just be another * in the pattern . i'm not sure you can actually do this match without an _NSStringUtilities fix. ms On Nov 9, 2010, at 9:48 AM, F

Re: wildcard Query

2010-11-09 Thread Stefan Klein
You need escape the character. Normal is the Backslash the escape sign. EOQualifier qualifier = M_User.NAME.contains("\\*"); <-- 2 Backslashes for java Stefan Am 09.11.10 15:34, schrieb ISHIMOTO Ken: Hi everyone, I am fighting with a Qualifier and my Question is "Is there any way for query