Poorvesh
Starting Member
USA
6 Posts |
Posted - August 27 2003 : 20:06:48
|
How can i change asp shopproductcreatesql.asp to add intelligent search
When any body tries to find some product eg. cameera.
It should give all the products sounding like camera, even though there is spelling mistake.
I know This could be accomplished by using soundex function.
When i go in sql and do sql querry as follows
SELECT * FROM products WHERE (SOUNDEX(cdescription) = (SELECT soundex('cameera')))
It returns all the product that are camera.
Because Select sound ('cameera') produces a unique value that is same for camera or camerra.
So on this basis it would return all the products that sounds like camera.
I want to translate this functionality to vpasp search.
So when any body misspells words like cameera it would still show him camera products.
To translate to vpasp, i am not so good at asp. I was trying to figure out what would be changes required to add this functionaity.
Your prompt help would be appreciated
saumil Thakkar [email protected]
Poorvesh Thakkar [email protected] |
|