Re: help for fetch with LIKE required
Re: help for fetch with LIKE required
- Subject: Re: help for fetch with LIKE required
- From: Chuck Hill <email@hidden>
- Date: Wed, 29 Jun 2005 10:52:35 -0700
On Jun 29, 2005, at 10:48 AM, Wolfram Stebel wrote:
Hi all,
when i use a dictionary for a fetch with something like this:
aDict.takeValueForKey ( "%" + searchValue + "%",
"searchValue" );
aDict.takeValueForKey ( "*" + searchValue + "*", "searchValue" );
Is how this is usually written in EOF. Does that work for you?
Chuck
and serching with
list = EOUtilities.objectsWithFetchSpecificationAndBindings
( ec,
"News", "searchNews", aDict );
with mysql 4.0.21 it creates an invalid statement like:
select * from news where news_title like "|%xyz|" escape '|'
It does not produce an exception but an empty result set.
Interactive: select * from news where news_title like "%xyz" gives
a result
set.
In the mysql documentation i have, this is listed as a known bug.
I did not find a "bug fixed" message at mysql-website.
I need urgently a way to select like this LIKE :-)
Any pointers or workarounds?
TIA
Wolfram
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - a book for intermediate WebObjects developers
who want to increase their overall knowledge of WebObjects, or those
who are trying to solve specific application development problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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