Searching a full name
Searching a full name
- Subject: Searching a full name
- From: "Jonathan Fleming" <email@hidden>
- Date: Sat, 25 Sep 2004 08:35:20 +0100
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:
This email sent to email@hidden