[thelist] SQL: Eliminating Duplicates with .getRows()

Ken Kogler ken.kogler at curf.edu
Mon Sep 2 20:22:01 CDT 2002


>>I want to return any sign where the search term is in the sign's
title,
>>or in the category of the sign.

>yes, but that's what i meant -- if the search term is found in the
>category, then you're saying you want all the signs in that
>category returned...

Yes. Strange, but my well-informed client wants it that way.

My problem is that if a search term is present in the sign's title and
in one of the sign's categories, then that sign comes back TWICE in the
search results. That's what I'm trying to avoid...

--Ken




More information about the thelist mailing list