Kryptronic Software Support Forum

I Have just tried the Demo store at wwwclickcartpro.com and that too does not work!

Thanks Dave for clearing that up!, can you answer the quick search question?

fishbite wrote:

Also a quick question regarding the "quick search" again if say someone is at my shop and wants to search for say "brown shoes" does the search, search the single words as well as both of them, so if i searched for say "brown snooooes" (spelt wrong) or even "brown hair" does the results still show for "brown"?

The quick search is done using  and  which means it will search for *brown*  *shoes* in any of the following fields:  name, prodnum, keywords descshort

If you were searching for brown snoooes it will still find things that have brown in any of those fields.

fishbite wrote:

In the advanced search form under search type "any word" does this mean any word will be searched? as this feature does not work?

The  option in advanced search functions the same way as described above.  The  options changes the search to use  instead of .

BTW, please send me some links, via PM or email, to the other carts that you say allow the use of the back button in the browser and don't report that the page is expired.

fishbite wrote:

Thanks Dave for clearing that up!, can you answer the quick search question?

Here's the exact database call that happens if you do a search from quick search.

name LIKE '%personal%' OR prodnum LIKE '%personal%' OR keywords LIKE '%personal%' OR descshort LIKE '%personal%'

The same search from advanced search with the Any Word search type.

((name LIKE '%personal%') OR (prodnum LIKE '%personal%') OR (keywords LIKE '%personal%') OR (descshort LIKE '%personal%')) AND (sortprice>'0')

Hi All,

Can you tell me where the queries for the quick search and advanced search are built. I'd like to experiment with modifying the queries to provide a result set more taylored to our specific needs. In particular I'd like to see if the sorting can be done using the regular price field in some way instead of the integer only sortprioce field which produces very poor results for us.

Thanks,

Bill

thanks - I've been looking at this. I'm now searching using the full values of pricemin and pricemax against the regprice instead of the searchprice. This may have legs but the initial results I'm getting are mixed.

One thing that would help greatly would be to know what the final query that is used when performing the search looks like. Do you happen to know where I could display this as the prodsearch function is only responsible for building the where clause?

thanks

Bill

You shouldn't need to pad with leading zeros.  One solution is to use a multiplication (or any mathmatical operation, really), like you suggested:

WHERE (regprice*1) >=1.00 AND (regprice*1) <=4.00

That should implicitly cast the regular price as a floating point in most databases.  Or else, you can use the CAST statement:

WHERE CAST (regprice as SIGNED) >=1.00 AND CAST (regprice as SIGNED) <=4.00

You'll need to check the exact syntax for the database type you're using and you might use a different variable type in the CAST statement, bu that's the general idea.

bill99 wrote:

One thing that would help greatly would be to know what the final query that is used when performing the search looks like. Do you happen to know where I could display this as the prodsearch function is only responsible for building the where clause?

Turn on debug and you'll see the exact query (and a whole lot more) which will let you see exactly what the statement looks like when it's passed to the "do" function.  See  in the Wiki for information on how to turn on debug (you do not want to do this on a production installation).

djm0219 wrote:

Someone sent me a link to another cart via mail and I just took a look at it.  With that cart one doesn't get a page expired message with IE because it is passing all of the parameters for the search in the URL itself.  This can be a dangerous thing to allow since it lets people pass anything they want to the program.  It also limits how much data may be passed back (4k).  I suspect that this will be the case for the other examples too.

IMNSHO this is NOT a change you want made to CCP (nor do I think Nick would go for it anyway).

I have to comment again that this is an IE "quirk" and it's the only browser, afaik, that exhibits this behavior.  Why is anyones guess.

Some additional information about this.  I've been corresponding with someone off-line and there's another cart that doesn't exhibit the problem and it is NOT passing the search data in the URL.  Looking at the response  headers compared to CCP the only difference I can see is that the other cart is using a session cookie and CCP uses a "persistent" cookie with an expiration date (way in the future).

It still doesn't make sense, to me, that that alone would cause the page expired error in CCP and not the other cart but it's the only difference I can see in the headers.  The other difference is in the action used for the searching form.  CCP uses a fully qualified URL with http: etc while the other cart only uses a reference to search.php.  Again this doesn't seem to explain why CCP gives the expired message but it is another difference.

Can we simply get rid of IE?

djm0219 wrote:

Someone sent me a link to another cart via mail and I just took a look at it.  With that cart one doesn't get a page expired message with IE because it is passing all of the parameters for the search in the URL itself.  This can be a dangerous thing to allow since it lets people pass anything they want to the program.  It also limits how much data may be passed back (4k).  I suspect that this will be the case for the other examples too.

IMNSHO this is NOT a change you want made to CCP (nor do I think Nick would go for it anyway).

I have to comment again that this is an IE "quirk" and it's the only browser, afaik, that exhibits this behavior.  Why is anyones guess.

And this is another good reason not to use IE!!

bumperty

ah cookie time, is it ok to change these?

I will have a look at this now. Thanks