QuadComm e-commerce solutions
 |
Home |  |
|
Q-Shop | |
|
Forum | |
|
ASP | |
|
About us | |
QuadComm e-commerce solutions
|
|
|||||||||||||||||||
|
||||||||||||||||||||
|
Error in quick search for more than one wordSYMPTOMS When performing a search using the quick search box provided in the header of all pages for more than one word, the following error is displayed: Sorry, there was an error executing the query. (Invalid use of '.', '!', or '()'. in query expression '( (Products.Name LIKE '%df%' OR Products.Description LIKE '%df%') (Products.Name LIKE '%f%' OR Products.Description LIKE '%f%') ) AND (Products.Show = 1 AND Categories.Show = 1) AND ProductToCategory.IsMain = 1'.) VERSIONS AFFECTED Q-Shop Pro and Lite v3.5.0. CAUSE A hidden form field is missing. To add it, follow the instructions below to correct it. RESOLUTION Edit inc/layoutlib.asp and where it says:
<form action="search.asp" id=quicksearch><label for="searchtext">Search:</label> <input type="Text" name="srkeys" value="search" onFocus="if(this.value=='search')this.value='';" class="searchtext" id="searchtext"> <input type="submit" name="Search" value="Go" class="searchbutton"> </form>
Change it to:
<form action="search.asp" id=quicksearch><input type="hidden" name="Criteria" value="OR"> <label for="searchtext">Search:</label> <input type="Text" name="srkeys" value="search" onFocus="if(this.value=='search')this.value='';" class="searchtext" id="searchtext"> <input type="submit" name="Search" value="Go" class="searchbutton"> </form>
|
|
