From: James Cicenia <email@hidden>
To: "Jonathan Fleming" <email@hidden>
Subject: Re: Searching a full name
Date: Sat, 25 Sep 2004 12:16:17 -0500
Why are you doing it that way? Just store first and last name in database
and when displaying
the name add the white space.
-James Cicenia
On Sep 25, 2004, at 2:35 AM, Jonathan Fleming wrote:
Hi Guys,
what's the best way to do a search for first and last names including
whitespace? eg.
"jonathan fleming" or "*atha emin* or "*jona* *eming*" etc, etc.
I'm using qualifiers in an EOModel fetchSpec and have tested this in
DBEdit which works fine if I include a whiteSpace column in the db but
that seems like i'm overdoing it:
(firstName LIKE "*jona*" AND lastName LIKE "*eming*") works but no
space
(firstName LIKE "*jona*" AND whiteSpace=' ' AND lastName LIKE
"*eming*") works too but a column for this can't be right
So what's the best way to get what I'm after here?
TIA
Jonathan :^)
_________________________________________________________________
Express yourself with cool new emoticons
http://www.msn.co.uk/specials/myemo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/ email@hidden
This email sent to email@hidden
