From: William Norris <email@hidden>
Reply-To: William Norris <email@hidden>
To: Jonathan Fleming <email@hidden>, "WebObjects (Group)"
<email@hidden>
Subject: Re: Searching a full name
Date: Sat, 25 Sep 2004 13:19:17 -0500
On Sat, 25 Sep 2004 18:48:56 +0100, Jonathan Fleming
<email@hidden> wrote:
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.
(I'm guessing you have a single input box where the user can enter
their full name). When the form is submitted, $tradingName
potentially holds two pieces of information -- both the user's
firstname as well as their last name. The easiest (and probably most
logical) thing to do would be to split $tradingName wherever their is
a whitespace and treat each substring as an individual token. They
might have entered last name first, so you'll want to check each token
against each database field.
for example, if $tradingName had one space in it, and you split it
into two strings, $tn1 and $tn2, your qualifier would look something
like... (((firstName like $tn1) or (lastName like $tn1)) and
((firstName like $tn2) or (lastName like $tn2))).
This could (and probably should) be expanded a bit to account for
multiple spaces, commas between last and first name, etc.
