ProductCart Shopping Cart Software Forums : Making a field non-searchable?? https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 10 Apr 2026 17:33:30 +0000 Thu, 12 Jun 2008 20:23:46 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=1621 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Making a field non-searchable?? : Hamish wrote:Cool!!! Is that...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5508.html#5508 Author: nathan
Subject: 1621
Posted: 12-June-2008 at 8:23pm

Originally posted by Hamish Hamish wrote:

Cool!!! Big%20smile
Is that a comparison of the new patch with the modified new patch?

I was expecting that there would probably be more modifications required to cut back the search code even further. Smaller changes are great as there is less to modify when new versions are released.

Do you have the AJAX enabled so that it calculates the number of hits as you type the search options in?  If so, is the number correct?


 
Ajax is enabled and displays the correct search number!
]]> Thu, 12 Jun 2008 20:23:46 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5508.html#5508 <![CDATA[Making a field non-searchable?? : Hi Qwijybo, That&#039;s pretty...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5409.html#5409 Author: Hamish
Subject: 1621
Posted: 05-June-2008 at 3:23pm

Hi Qwijybo,
     That's pretty similar to my "fix" - Your just leaving one extra field in  place (the short description).

Personally I always use an unusual word, usually the client companies name or sometimes "Hamish" to flag areas of amended code as searching for all occurances of a word such as edit gives to many hits in the full source code.

Please let us know the comparative improvement in your search times, natan had a very great improvement & it would be nice to see some other figures as well.
]]> Thu, 05 Jun 2008 15:23:53 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5409.html#5409 <![CDATA[Making a field non-searchable?? : To eliminate the details from...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5405.html#5405 Author: Qwijybo
Subject: 1621
Posted: 05-June-2008 at 2:40pm

To eliminate the details from being searched I edited the parts of the code dealing with adding the string tmpSQL to strSQL. There are two locations in viewsearchresults.asp that need editing.
 
I commented these two lines then copied the first line and changed the variable to tmpSQL2. Search for "strSQL=strSQL & tmpSQL" and make the following edits.
 
 ' EDIT strSQL=strSQL & tmpSQL
 ' EDIT strSQL=strSQL & " OR " & tmpSQL2
  strSQL=strSQL & tmpSQL2
 
The ' is all you need. I put in ' EDIT so I can search qucikly and easily for any edits I have made to the code.
]]> Thu, 05 Jun 2008 14:40:23 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5405.html#5405 <![CDATA[Making a field non-searchable?? : Cool!!! Is that a comparison of...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5391.html#5391 Author: Hamish
Subject: 1621
Posted: 04-June-2008 at 8:28pm

Cool!!! Big%20smile
Is that a comparison of the new patch with the modified new patch?

I was expecting that there would probably be more modifications required to cut back the search code even further. Smaller changes are great as there is less to modify when new versions are released.

Do you have the AJAX enabled so that it calculates the number of hits as you type the search options in?  If so, is the number correct?


]]> Wed, 04 Jun 2008 20:28:57 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5391.html#5391 <![CDATA[Making a field non-searchable?? : When both files are Mod... search...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5390.html#5390 Author: nathan
Subject: 1621
Posted: 04-June-2008 at 8:12pm

When both files are Mod... search goes from 25 to 3 sec!]]> Wed, 04 Jun 2008 20:12:38 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5390.html#5390 <![CDATA[Making a field non-searchable?? : Hi, There is identical code in...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5388.html#5388 Author: Hamish
Subject: 1621
Posted: 04-June-2008 at 7:40pm

Hi,
   There is identical code in there as well, so I would say so.
]]> Wed, 04 Jun 2008 19:40:38 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5388.html#5388 <![CDATA[Making a field non-searchable?? : Ill give it a try... does anything...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5386.html#5386 Author: nathan
Subject: 1621
Posted: 04-June-2008 at 7:30pm

Ill give it a try... does anything need to be done to inc_srcPrdQuery.asp ?]]> Wed, 04 Jun 2008 19:30:36 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5386.html#5386 <![CDATA[Making a field non-searchable?? : OK - There&#039;s lots to this...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5385.html#5385 Author: Hamish
Subject: 1621
Posted: 04-June-2008 at 7:14pm

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.

 ]]> Wed, 04 Jun 2008 19:14:16 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5385.html#5385 <![CDATA[Making a field non-searchable?? : Thanks ]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5382.html#5382 Author: nathan
Subject: 1621
Posted: 04-June-2008 at 2:18pm

Thanks]]> Wed, 04 Jun 2008 14:18:42 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5382.html#5382 <![CDATA[Making a field non-searchable?? : Hi Nathan, I&#039;ll take another...]]> https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5381.html#5381 Author: Hamish
Subject: 1621
Posted: 04-June-2008 at 1:42pm

Hi Nathan, 
    I'll take another look  at the code.
]]> Wed, 04 Jun 2008 13:42:05 +0000 https://forum.productcart.com/making-a-field-nonsearchable_topic1621_post5381.html#5381