InterMedia 'NEAR' operator

From: Eugene Ng <eugeneng_at_asiansources.com>
Date: Mon, 21 Feb 2000 15:49:52 +0800
Message-ID: <88qqnb$ths$1@clematis.singnet.com.sg>

Hi all,

I've encountered an abnormal behaviour using NEAR (;) in Intermedia....here's the problem....

SELECT score(1), adv_prod_id, prod_name, prod_description from adv_products where (contains (prod_description, '$SYN(Mobile Phone,mythes);$SYN(Battery Charger,mythes)',1) > 1) order by score(1) desc

Apparently this query will return an error, but ....

SELECT score(1), adv_prod_id, prod_name, prod_description from adv_products where (contains (prod_description, '$SYN(Mobile,mythes);$SYN(Phone Battery Charger,mythes)',1) > 1) order by score(1) desc

This appears to work properly.
IMHO, it seems like the first term cannot be a phrase.......

Anyone out there can help??? Received on Mon Feb 21 2000 - 01:49:52 CST