Ok
Im trying to get full text searching to work with parameterised stored procedures.
basicly the proc is
SELECT IndustrySector.title, BiblioHeadings.BiblioHeading, ReferenceTypes.ReferenceType, Bibliographies.Authors, Bibliographies.PublishDate, Bibliographies.BiblioTitle,
Publishers.Publisher, Bibliographies.Journal, Bibliographies.Issue, Bibliographies.BiblioKeyWords, Bibliographies.BiblioAnnotation, Bibliographies.Note,
Bibliographies.BiblioURL, IndustrySector.id
FROM Bibliographies INNER JOIN
BiblioHeadings ON Bibliographies.BiblioHeadingID = BiblioHeadings.BiblioHeadingID INNER JOIN
Publishers ON Bibliographies.PublisherID = Publishers.PublisherID INNER JOIN
ReferenceTypes ON Bibliographies.Reference = ReferenceTypes.ReferenceTypeID INNER JOIN
IndustrySector ON Bibliographies.SectorID = IndustrySector.id
WHERE CONTAINS(BiblioAnnotation, @.SearchFor_txt )
this works as long as only one word is in the @.SearchFor_txt parameter.
How to I get it to work with more than one word?
can I put the parameters in quote marks such as '" @.SearchFor_txt "' ? (I know this dosnt work with parameters but I need to contain the string)
any know how to resolve this issue please
jim
Books on line says
CONTAINS can search for:
A word or phrase.The prefix of a word or phrase.
A word near another word.
A word inflectionally generated from another (for example, the word drive is the inflectional stem of drives, drove, driving, and driven).
A word that is a synonym of another word using thesaurus (for example, the word metal can have synonyms such as aluminum and steel).
没有评论:
发表评论