I try to customize the advanced search web part and form my own query which I add to ASB_ResType_Query.
the problem appear when with 1 text box value I need to look into several properties and I combine several field like that in my query.
My query can became very long like below:
Full Text Query:
SELECT Name, Title, Path, SiteName, CollapsingStatus, HitHighlightedSummary, HitHighlightedProperties, ContentClass, IsDocument, PictureThumbnailURL
where ("scope" = 'All Sites') And ((FREETEXT(DLName,'document') OR FREETEXT(DLfName, 'document') OR FREETEXT (DLTitle,'document')) AND ((DLCompName ='Town) OR (DLAirport = 'Town') OR (DLExtComp = 'Town') OR (DLComp = 'Town') OR (DLRelevantComp = 'Town')
OR (DLCorrespondent = 'Town')))
These always give me a no result or sometimes your query is malformed.
hope anybody can point me what is wrong with my query or which approach should I take to make it works.
Thank you all
-- Pingkan --
View Complete Post