Re: Webobjects-dev Digest, Vol 7, Issue 745
Re: Webobjects-dev Digest, Vol 7, Issue 745
- Subject: Re: Webobjects-dev Digest, Vol 7, Issue 745
- From: Theodore Petrosky <email@hidden>
- Date: Wed, 10 Nov 2010 10:12:36 -0800 (PST)
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@hidden>
> Subject: Re: wildcard Query
> To: Amedeo Mantica <email@hidden>
> Cc: WebObjects Development <email@hidden>
> Message-ID: <email@hidden>
> 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@hidden>
> >> [iChat:] <email@hidden>
> >> [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@hidden)
> >> Help/Unsubscribe/Update your Subscription:
> >>
> >> This email sent to email@hidden
> >
>
> -------------- 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden