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ยข
>
> 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] <k...@ksroom.com>
>> [iChat:] <ibase_...@mac.com>
>> [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 (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/amedeomailing%40insigno.it
>>
>> This email sent to amedeomail...@insigno.it
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
