Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exlcude Search Result Where directly related

Status
Not open for further replies.
Mar 17, 2005
147
US
I have a recordset, or sql statement that searches through a table based on the value of a request.query string.

I want the results to exclude the actual direct hit find.

For example searching for John Alexander Interview, could show

John Alexander Interview
John Alexander Photos
A Day with John Alexander

I want to exclude the John Alexander Interview because the details page already will have information in the details about the John Alexander Interview item because it is its detail page so I want to exclude it from.

SELECT *
FROM admin.src_cache_cah "+tfm_SQLstr+"
ORDER BY eventdate_cah ASC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top