Making a field non-searchable??

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Well I am sure you guys can figure out what is wrong with the link above, how about this. 

http://shop.rings-things.com/cart/pc/viewCategories.asp

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
njessen42 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-November-2007 Location: Spokane, WA Status: Offline Points: 0	Post Options Post Reply Quote njessen42 Report Post Thanks(0) Quote Reply Posted: 02-June-2008 at 4:13pm
	Well I am sure you guys can figure out what is wrong with the link above, how about this. http://shop.rings-things.com/cart/pc/viewCategories.asp

njessen42 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-November-2007 Location: Spokane, WA Status: Offline Points: 0	Post Options Post Reply Quote njessen42 Report Post Thanks(0) Quote Reply Posted: 02-June-2008 at 4:11pm
	I think its the products.details. The field in my dbo.products table that I don't want searchable is details. This might help a ton, thanks a bunch. Here is our site with over 18,000 products if you want to check it out, any suggestions would also be helpful. http://https://shop.rings-things.com/cart/pc/viewCategories.asp

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 02-June-2008 at 4:07pm
	If your happy to do this yourself that's great - please post the definitive answer here - just in case others wish to do so. Actually - I think the best line to comment out is a touch further down - strSQL=strSQL & " OR " & tmpSQL2 Line 475 in my copy. Or perhaps the line above that one. I'll have to look elsewhere to confirm which one. - Or you could just try it & see :-)

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 02-June-2008 at 4:01pm
	Yep - No problem - Look for code like : tmpSQL="(products.details LIKE " tmpSQL2="(products.description LIKE " tmpSQL3="(products.sDesc LIKE " It occurs a few times & I don't recall off the top of my head which one you need to knock out - I would think it's products.description.

njessen42 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-November-2007 Location: Spokane, WA Status: Offline Points: 0	Post Options Post Reply Quote njessen42 Report Post Thanks(0) Quote Reply Posted: 02-June-2008 at 3:57pm
	That is exactly what I want to do Hammish. Hide the long description from the built in search. We of course still want customers to still see it and google to index it. So the file to edit would be the SearchResults.asp. Thank you very much.

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 02-June-2008 at 3:51pm
	Hi, I just re-read your post - I think I misunderstood it last time. Do you just wish to "hide" the long description field from the built in search facility? If so a mildly customized version of SearchResults.asp will be needed to drop that field. It won't stop Google etc from finding & indexing that text - or customers from copying the words etc though of course.

njessen42 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-November-2007 Location: Spokane, WA Status: Offline Points: 0	Post Options Post Reply Quote njessen42 Report Post Thanks(0) Quote Reply Posted: 12-May-2008 at 6:27pm
	Is there a way to make the [Details]/long description field non-searchable? We use this field for a lot of information and want to make sure customers aren't grabbing KW's out of it.