But in this case I'm looking for a duplicate and getting "every matching record regarless of address" doesn't help there. I'd want #2.
> > But if I don't do the address part of the clause, then I'd get all
> of the "World B. Free"s out there whether they're at 1101 Palace Place,
> or 2104 Cremola Blvd.
>
> Well, you'd only not do the address part of the clause if they didn't
> put in an address.
>
> Basically, if they don't put in an address, you have two options:
>
> 1) Get every matching record, regardless of address
> 2) Get every matching record where the address is an empty string.
>
> My code assumes you'd want #1. Usually, when people leave a field
> blank, they're not looking for records where that field is blank in
> the database.
>
> Scott
>
> ---------------------------
> Scott Brady
> http://www.scottbrady.net/
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
