Annex

RC Steve Sterling rcsteve at tcrcm.org
Sat Dec 14 14:07:37 AKST 2002


My guess it was a case problem. I just looked and its in the db ALLISON, all
caps. Using the EQUALS, if you put in allison or Allison it wouldn't match.

Maybe we should take out the EQUALS option, can't think of a reason to use
it anyway.

Steve

-----Original Message-----
From: discussion-request at nsrca.org
[mailto:discussion-request at nsrca.org]On Behalf Of Ron Van Putte
Sent: Saturday, December 14, 2002 2:37 PM
To: discussion at nsrca.org
Subject: Re: Annex




RC Steve Sterling wrote:

> Humm .... after your note below, I was worried that the system wasn't
> working, so I went in and did a search on allison, used the parameters:
> Last Name | Like | Allison <end> in the search criteria fields.
> He popped right up.
> Also tried Isaquah-- actually, I wasn't sure how to spell Isaquah, so I
used
> City | Like | Is% <end> (percent is a wild card)
> I got back every person in a city starting with "is", but in the list was
> both Rick and Joanie.
>
> One trick is to use the "Like" operator instead of the "Equals" operator.
> Equals is absolute, including case, has to match perfectly. "Like" is case
> independent, and will grab everything that is close.
>
> Try it again and see what you get. Also, if you have trouble, feel free to
> call me and I'll try and help out. There is also the reality that we might
> find a bug or two. Maureen, who uses more than anybody, finds one every
> month or two. We didn't spend multi-millions to find every bug, like
> Microsoft does!

That's interesting.  When I tried it the first time earlier today, last
name 'equals' Allison didn't yield a name.  I also got a bunch of Ricks,
but no Allison, similarly with Issaquah.  I just tried it again and it
worked. How'd that happen?

However, I will use 'like' instead of 'equals' in the future.  I will
now try the remaining names, but am relatively sure they will pop up
withn the same seven names that Tom Weedon reported.  Thanks.

Ron Van Putte

> -----Original Message-----
> From: discussion-request at nsrca.org
> [mailto:discussion-request at nsrca.org]On Behalf Of Ron Van Putte
> Sent: Saturday, December 14, 2002 11:22 AM
> To: discussion at nsrca.org
> Subject: Re: Annex
>
>
>
>
> Thomas C. Weedon wrote:
>
>>Kurt,
>>I'm sorry but you supplied the wrong information. Ron Lockhart is a member
>>of the NSRCA. So is Charlie Reed, Dave Von Linsowe, and Rick Allison. So 7
>>of the 11 CB members are all members of the NSRCA. Geoff Combs is a past
>>member, but is totally inactive at this time.
>
>
>
> That's interesting.  I did a search of the NSRCA member list on the
> NSRCA web site and only came up with the four I mentioned.  I searched
> several different ways and couldn't get any more.  I was particularly
> surprised that Rick Allison wasn't listed and did a search on last name
> (only), first name (only) and on Isaquah (only).
>
> Ron Van Putte
>
> =====================================
> # To be removed from this list, send a message to
> # discussion-request at nsrca.org
> # and put leave discussion on the first line of the body.
> #
>
>
>
> =====================================
> # To be removed from this list, send a message to
> # discussion-request at nsrca.org
> # and put leave discussion on the first line of the body.
> #
>


=====================================
# To be removed from this list, send a message to
# discussion-request at nsrca.org
# and put leave discussion on the first line of the body.
#



=====================================
# To be removed from this list, send a message to 
# discussion-request at nsrca.org
# and put leave discussion on the first line of the body.
#



More information about the NSRCA-discussion mailing list