Posted by J.O. Aho on 06/14/06 18:08

Chris wrote:
> Hi,
>
> I will give this a try, but FYI - the db doesn't accept duplicates, this is
> apparently an issue with the code itself. I have seen the same problem with
> this search code referred to on different forums, and it may be that the
> problem is with 'DISTINCT', and I will also look at other solutions that
> have been posted. As usual, my current priority has switched to something
> else, but will be concentrating on this again very soon and will let you
> know how it all worked for me.

From a hastily look on the code, I didn't notice anything that really should
generate duplicates, but then in the first place I wouldn't have written the
code the way the original author has chosen to use, the code can be simplified
a lot and make it a lot easier to see problems.

I hope things will get solved and you get it to work by your liking.


//Aho

[Back to original message]