Making a field non-searchable??

I see there is also an includes/languages.asp - I assume you have both already got custom versions of that file in place. Just in case you hadn't spotted it :-)  

It seems to me the only one  I want to keep is tmpSQL2 since this is the Title? I only want to quary dbo.description.

So I am having problems figuring out what code to comment out to only search the description.

Hi Nathan, 
    I'll take another look  at the code.

OK - There's lots to this code & I'm certain it would be possible to amend it fairly radically to focus it on just the bits you want.

First thing some of the code runs via AJAX on the search page - to indicate the number of hits you will get - which is great, but maybe not for 18,000 prods - from memory (it's a few hrs since I looked, it's switched on/off depending on whether the AJAX Tooltip is enabled. I don't recall if this is the new or current version. That code will also need amending - if it IS enabld as it will give a different count from the actual search.

Anyway, onto code changes...

Look for Lines 394 & 485  :-

    strSQL=strSQL & tmpSQL
    strSQL=strSQL & " OR " & tmpSQL2
    if tIncludeSKU="true" then
        strSQL=strSQL & " OR " & tmpSQL3
        strSQL=strSQL & " OR " & tmpSQL4 & "))"
    else    
        strSQL=strSQL & " OR " & tmpSQL3 & "))"
    end if

And try :-

' HAM -    strSQL=strSQL & tmpSQL
' HAM -    strSQL=strSQL & " OR " & tmpSQL2
    strSQL=strSQL & tmpSQL2
    if tIncludeSKU="true" then
' HAM -        strSQL=strSQL & " OR " & tmpSQL3
        strSQL=strSQL & " OR " & tmpSQL4 & "))"
    else   
' HAM -        strSQL=strSQL & " OR " & tmpSQL3 & "))"
        strSQL=strSQL & "))"  ' HAM - Added line
    end if

- Where  'HAM are lines I commented out - Note the EXTRA line after the last commented out line.

tmpSQL  - Search of "Details"
tmpSQL2 - Search of "Description"
tmpSQL3 - Search of "Short  Description"
tmpSQL4 - Search by SKU

I've NOT tested this code change and, of course (by design) it limits the breadth of the search.