ProductCart Shopping Cart Software Forums : Customized Store Search Code https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 08:28:28 +0000 Wed, 19 Aug 2009 12:58:27 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2721 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Customized Store Search Code : Glad I could helpJust keep in...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post11047.html#11047 Author: worldofrugs
Subject: 2721
Posted: 19-August-2009 at 12:58pm

Glad I could help Clap

Just keep in mind to clean up this code a little... (I learned the hard way)
I just changed them without taking the duplicates away, and while this went good 90% of the time, it did occasionally time out on the search (not to mention it took 4 ever for the results to come up!)
I then removed the duplicates and voila! Perfect going Wink
]]> Wed, 19 Aug 2009 12:58:27 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post11047.html#11047 <![CDATA[Customized Store Search Code : worldofrugs - you win! That worked...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post11046.html#11046 Author: roknrod12
Subject: 2721
Posted: 19-August-2009 at 12:48pm

worldofrugs - you win! That worked perfectly! Now I've got more refined searches on our site. Thanks a bunch! ]]> Wed, 19 Aug 2009 12:48:18 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post11046.html#11046 <![CDATA[Customized Store Search Code : What I did is I took the showsearchresults.asp,...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post11044.html#11044 Author: worldofrugs
Subject: 2721
Posted: 19-August-2009 at 10:44am

What I did is I took the showsearchresults.asp, made a copy (showsearchresultsB.asp) and refered to this new page when I needed it (for example your own form).

When looking at the code, you will see in this file line like:
tmpSQL=tmpSQL  & TestWord & " A.details LIKE "
tmpSQL2=tmpSQL2 & TestWord & " A.description LIKE "
tmpSQL3=tmpSQL3 & TestWord & " A.sDesc LIKE "

How I started on this file, was to change all thos lines to search only the ones I wanted...
Example, searching only in the Name (title) of the product:
tmpSQL=tmpSQL  & TestWord & " A.description LIKE "
tmpSQL2=tmpSQL2 & TestWord & " A.description LIKE "
tmpSQL3=tmpSQL3 & TestWord & " A.description LIKE "

I tested it and got the result I needed. Then I cleaned it up, removing the duplicate queries / string (or whatever you call them haha)...

As I am not a guru ASP coder, this is probably not the best way to go, but it works great!

(note: I'm using v3.12a, so look into the code with other versions)

Hope this is what you were looking for or maybe helps you on your way...


Edited by worldofrugs - 19-August-2009 at 10:45am]]> Wed, 19 Aug 2009 10:44:46 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post11044.html#11044 <![CDATA[Customized Store Search Code : Thanks, avalight! I&#039;ll check...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post11024.html#11024 Author: roknrod12
Subject: 2721
Posted: 18-August-2009 at 11:20am

Thanks, avalight! I'll check this out.]]> Tue, 18 Aug 2009 11:20:23 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post11024.html#11024 <![CDATA[Customized Store Search Code : Ah, right, sorry. I see the reason...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post11023.html#11023 Author: avalight
Subject: 2721
Posted: 18-August-2009 at 11:16am

Ah, right, sorry.  I see the reason for the question.  I think if I read this forum in the morning when I am fresh, vs. the late, late evening, things would be clearer...anyway, the post that I am referring to is this one: http://www.earlyimpact.com/forum/forum_posts.asp?TID=1979, which talks about how to make the search box only look for the SKU.  I followed those instructions, including the change in the showsearchqueary.asp, and made some further modifications shown below, mostly to help users know what they can type in the box.  

<!-- Start Search Box -->
   <form action="http://www.avalanche-ranch.com/rusticlighting/pc/showsearchresults.asp" name="search" method="get" class="pcForms">
   <input type="hidden" name="pageStyle" value="<%=bType%>">
   <SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 11pt; COLOR: rgb(0,161,0);">PRODUCT SEARCH:</span>
   <input type="hidden" name="resultCnt" value="10">
   <input type="Text" name="SKU" size="14" value="Enter Product No." onclick="this.value=''">
    <b><input type="image" name="submit" src="/rusticlighting/PC/images/btn_go_gray.gif" id="submit"></b>
    </form>
<!-- End Search Box -->

Hope this helps.
Best

]]> Tue, 18 Aug 2009 11:16:36 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post11023.html#11023 <![CDATA[Customized Store Search Code : avalight - Did you mean to put...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post11020.html#11020 Author: roknrod12
Subject: 2721
Posted: 18-August-2009 at 10:13am

avalight -

Did you mean to put a link to a post? You mentioned a post a couple of times, but no reference.]]> Tue, 18 Aug 2009 10:13:27 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post11020.html#11020 <![CDATA[Customized Store Search Code : Well, I just used the small search...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post9891.html#9891 Author: avalight
Subject: 2721
Posted: 08-May-2009 at 7:11pm

Well, I just used the small search box snippet that is in the Header.asp file.  Just like in the post.]]> Fri, 08 May 2009 19:11:04 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post9891.html#9891 <![CDATA[Customized Store Search Code : avalight - thanks for the reply....]]> https://forum.productcart.com/customized-store-search-code_topic2721_post9890.html#9890 Author: roknrod12
Subject: 2721
Posted: 08-May-2009 at 5:11pm

avalight - thanks for the reply. I thought the same thing, but according to EI support, 'it will require altering the complex query used by the the advanced search feature.' What exactly did you alter to limit yours?]]> Fri, 08 May 2009 17:11:37 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post9890.html#9890 <![CDATA[Customized Store Search Code : You can limit your search in the...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post9889.html#9889 Author: avalight
Subject: 2721
Posted: 08-May-2009 at 5:05pm

You can limit your search in the small search box by SKU, so I don't know why you couldn't do it for the Product Name too.  I think the field name is for the product is called "description", but under this post is the way to do it for the SKU.  I followed this plus a little tweaking and got it to work on my site http://www.avalanche-ranch.com.  Upper right corner.]]> Fri, 08 May 2009 17:05:11 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post9889.html#9889 <![CDATA[Customized Store Search Code : This is something we would like...]]> https://forum.productcart.com/customized-store-search-code_topic2721_post9882.html#9882 Author: whizzinpc
Subject: 2721
Posted: 08-May-2009 at 11:36am

This is something we would like to do also.]]> Fri, 08 May 2009 11:36:52 +0000 https://forum.productcart.com/customized-store-search-code_topic2721_post9882.html#9882