Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bglodde
Starting Member
25 Posts |
 Posted - 2003-02-05 : 16:21:34
|
| I have a situation that I could use some advise on.On a clients site, I've implemented several search methods, one in particular is searching by selecting 2 criteria from 2 distinct drop down lists. The query executes...let's say "red" and "stripes". I do some dynamic SQL, execute it and then return 583 records. Wonderful!Another search is done via keyword(s) and the full-text engine. If the user enters "red stripes" as the criteria, the resultset is not similar. As I have it coded today using CONTAINS( table.column, 'red AND stripes'), it will return 1 record. Altering to FULLTEXT yields approximately 14,000 records.I am having tremendous difficulty explaining [to the client] the differences between these 2 queries results and also wondering why I cannot obtain even remotely similar resultsets when the queries are syntactically very much alike. Any help is greatly appreciated. |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-02-06 : 07:09:38
|
| How are you constructing your WHERE clause in the first query?Jay White{0} |
 |
|
|
bglodde
Starting Member
25 Posts |
Posted - 2003-02-07 : 00:53:33
|
| The strangest part is they were both very very close in syntax with the exception of using CONTAINS in the where clause rather than explicitly stated.The client cut off the full text query. :( |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
|
|
|
Full-text vs Normal Query