close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Search Spaces

Thread began 6/19/2012 12:07 pm by eaw500250991 | Last modified 6/22/2012 3:53 pm by Jason Byrnes | 603 views | 5 replies |

eaw500250991

Search Spaces

I am using Power Store and when a search is entered it works unless you have a product that contains two words. if I were to search for Time Clocks the url will contain Time+Clocks which returns time, clocks and not Time Clocks where in Power Store can I edit to get this correct that the + could be an _ or "" thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

use double quotes around the search term:
"Time Clocks"

Sign in to reply to this post

eaw500250991

By the way the image verification is not working in any browser for apple computers I had to locate a pc to post this reply.

By Double quotes do you mean I have to tell customers on my site if your looking for time clocks please use "" if so this is crap. If you mean the code it does already contain "" and it does not seem to work or do I need to do """". If so what file should I be editing the product_results.php or helperPHP.php.

Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

Originally Said By: eaw500250991
  By the way the image verification is not working in any browser for apple computers I had to locate a pc to post this reply.  



I have updated your account to not require image verification.

Originally Said By: eaw500250991
  By Double quotes do you mean I have to tell customers on my site if your looking for time clocks please use "" if so this is crap.  



This is the way all searches work, even Google.

If you search for:
Time Clocks

it looks for all records where the ProductID, ProductSKU, ProductName, "ProductCartDesc", ProductShortDesc, ProductLongDesc columns contains Time OR Clocks.


if you search for "Time Clocks" it searches for the String "Time Clocks".

This is a very common way for searches to work.

Sign in to reply to this post

eaw500250991

I know what you mean

So if in google I type in gt400 or gt 400 it returns the same or similar results, but if I type gt400 or gt 400 in power store it will return numeric first and then on page 14 you will find the product containing gt 400 how do I stop this because in google if you type gt 400 or "gt 400" you get the same result. But in power store it will return different results not anything on the web containing 400 and then gt. Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

results form a Data Base search are a bit different than from a site search like Google.

The Database search of power store uses the Product Name column for ordering, in Ascending order.

if you type:
gt 400

it is searching for gt OR 400

The results will be returned in ascending order, meaning numeric first, then Alphabetically from A - Z

if you type:
"gt 400"

with quotes it will search the literal string "gt 400" and the results will be displayed alphabetily in ascending order by the Product Name column.


If you wanted to force quotes around the search, you could add the following code at line 1 of the product results page:

php:
<?php if(isset($_GET["S_ProductName"])) $_GET["S_ProductName"] = '"'.$_GET["S_ProductName"].'"'?>
Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...