I mean all matching rows always happen to have the same score
and hence the result come ordered by the view FOGVW_SEARCHCUSTOMERS
ORDER BY clause (LAST_NAME, FIRST_NAME)
"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message
news:aof3m3$m2n1b$1_at_ID-114658.news.dfncis.de...
> Hello all,
>
> Why this kind of query always get the same scores?
>
> SELECT (.7*SCORE(1) + .3*SCORE(2)), FOGVW_SEARCHCUSTOMERS.*
> FROM FOGVW_SEARCHCUSTOMERS
> WHERE (CONTAINS(LAST_NAME, 'fuzzy(?Azua,65,100,weight)', 1) > 0
> OR CONTAINS(FIRST_NAME, 'fuzzy(?Giovanni,65,100,weight)', 2) > 0 )
> ORDER BY (.5*SCORE(1) + .3*SCORE(2)) DES
>
> TIA,
> Best Regards,
> Giovanni
>
>
>
>
>
Received on Mon Oct 14 2002 - 13:52:24 CDT
