help for fetch with LIKE required
help for fetch with LIKE required
- Subject: help for fetch with LIKE required
- From: Wolfram Stebel <email@hidden>
- Date: Wed, 29 Jun 2005 19:48:50 +0200
Hi all,
when i use a dictionary for a fetch with something like this:
aDict.takeValueForKey ( "%" + searchValue + "%", "searchValue" );
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:
This email sent to email@hidden