Is there a reason that you can not use rawSQL? Then you could do what ever you wanted.
Ted ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 10 Nov 2010 10:49:24 +0100 > From: ISHIMOTO Ken <[email protected]> > Subject: Re: wildcard Query > To: Amedeo Mantica <[email protected]> > Cc: WebObjects Development <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-2022-jp" > > 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 Accessor Methods in the EO > <<EntiryName>>.Java files for > replace the Data at saving and getting Time. > > Because that DB has so many Columns with Data, also it is a > Oracle DB at the Customer and it is not allowed to make new > Columns. > > I will try that to and write what happens. > > Thanks > > On 2010/11/10, at 10:40, Amedeo Mantica wrote: > > > 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 on the column NAME with "*" replaced by: > "--replacementForAsterisk--" (for example) > > > > For new data you van do this in the validateForSave() > method that will set the value for the newcolumn, for > existing data you have to write a simple code that fetch all > data and update the newcolumn... > > > > So, when you have to do the query for the NAME column > replace the wildcard with "--replacementForAsterisk--" in > your search string and do the search on the new column. > > > > My 2$B!q(B > > > > Regards > > Amedeo > > > > > > > > On 09/nov/2010, at 15.34, 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 > >> > >> Like code bellow but the "*" is a Wildcard and > won't work. > >> > >> EOQualifier qualifier = > M_User.NAME.contains("*"); > >> > >> I would love to find any Record with "*". > >> > >> > >> Is there any trick or command to get all Objects > with an "*" ? > >> > >> > >> Thank you > >> > >> > -------------------------------------------------------- > >> K's ROOM (ISHIMOTO Ken) > >> > -------------------------------------------------------- > >> [E-Mail] <[email protected]> > >> [iChat:] <[email protected]> > >> [HP] http://www.ksroom.com/ > >> > _____________________________________________________________________ > >> This e-mail has not been scanned for viruses > because it was written on an Mac, > >> and there are NO Viruses on an Apple Computer. > >> For further information visit http://www.apple.com > >> > >> > >> _______________________________________________ > >> Do not post admin requests to the list. They will > be ignored. > >> Webobjects-dev mailing list > ([email protected]) > >> Help/Unsubscribe/Update your Subscription: > >> http://lists.apple.com/mailman/options/webobjects-dev/amedeomailing%40insigno.it > >> > >> This email sent to [email protected] > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://lists.apple.com/pipermail/webobjects-dev/attachments/20101110/07383511/attachment.html _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
