Re: Searching a full name
Re: Searching a full name
- Subject: Re: Searching a full name
- From: "Jonathan Fleming" <email@hidden>
- Date: Sat, 25 Sep 2004 18:48:56 +0100
forgive me but I have probably become brain dead in the last week and can
not think straight, however, I do already store first and last names in db
(no probs there), what I am probably not comprehending is how to add the
whitespace when doing a search in a single box.
This is the qualifiers with their respective container variables:
((companyName like $companyName) or (firstName like $tradingName) or
(lastName like $tradingName) or (metaKeywords like $metaKeywords) or
(tbAddress.country like $country) or (tbAddress.countryAbbr like
$countryAbbr) or (tbAddress.cityTown like $cityTown) or ((firstName like
$tradingName) and (lastName like $tradingName)))
it's this what is my problem:
((firstName like $tradingName) and (lastName like $tradingName)) but could
make it function correctly so started to add the whitespace column but I
know for sure that I'm doing something seriously back to front, I just cant
think so... I need someone's fresh head 'cause mine's is still awash with
sleep deprivationform this week.... silly me.
Jonathan :^)
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:
This email sent to email@hidden
_________________________________________________________________
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