v.satishbabu
New member
- Joined
- Nov 2, 2008
- Messages
- 1
- Programming Experience
- 1-3
Hello,
I have some problem with search a skills like c, c#, etc. by using Containstable .
My host provider does not change noise words. Due to this we are using below quarries
If users searching a keyword like C, then query is as follows…
select id,skills,[state],metroarea,designation,cname,jobtype,city,rank FROM peoplesurge_posting as posting INNER JOIN
containstABLE(peoplesurge_posting,(skills,[state],metroarea,designation,cname,jobtype,city),'ISABOUT ("c*")') as frees ON frees.[key]= posting.[id]
Note: 'ISABOUT (C)' for this it takes as a noice word then no rusults were displayed. Due to this we adding * to keyword c. this querry gives some results but it gives worng results i.e starting character of C
Like c, c++, c#......etc
Please resolve this problem ASAP. It’s very urgent for me.
Thanks,
Satish.
I have some problem with search a skills like c, c#, etc. by using Containstable .
My host provider does not change noise words. Due to this we are using below quarries
If users searching a keyword like C, then query is as follows…
select id,skills,[state],metroarea,designation,cname,jobtype,city,rank FROM peoplesurge_posting as posting INNER JOIN
containstABLE(peoplesurge_posting,(skills,[state],metroarea,designation,cname,jobtype,city),'ISABOUT ("c*")') as frees ON frees.[key]= posting.[id]
Note: 'ISABOUT (C)' for this it takes as a noice word then no rusults were displayed. Due to this we adding * to keyword c. this querry gives some results but it gives worng results i.e starting character of C
Like c, c++, c#......etc
Please resolve this problem ASAP. It’s very urgent for me.
Thanks,
Satish.
