Hi,
I've only just noticed this but when performing a product search using the 'Name,Description' index (set up from another mod), the $numMerchants and $min,$maxPrice values are incorrect. Now I can see why they are as if you search for a particular name you'll get all the products with this name grouped and counted, but if you are searching the Description field too, you only get products grouped with similar values in the Description field. This resolves itself correctly on the Products page as the $q variable is used to find all the products.
e.g. if I search for a particular model number like F35085vi I'll get the correct number of merchants listed (say, 11) as this model number is in the name field of all the matching products, whereas if I search for 'dishwasher' it will list the F35085vi available from 4 merchants because in 4 feeds it has dishwasher in the description field but in the other 7 it doesn't.
Does this make sense?!
So, I was wondering if you had any ideas on resolving this? The only way I can think of is by running a query against each search result to find all matching product names but this would add a massive overhead. There must be an easier more elegant solution?!
Cheers.
Keeop
Hi David,
My limited knowledge has meant that I haven't been able to come up with a good solution for this. So, I've had to use the dodgy one whereby a separate query is run against each search result to build a complete list. To be fair, this doesn't seem to have made too much of a performance impact so I'm happy to use it for now.
Thanks.
Keeop
Hi Keeop;
That sounds strange as the SQL completes with "GROUP BY name". Could you perhaps email me a link to an example so that I can see what's going on in context and then i'll have a look at what can be done about it...
I think you have my email but if not; just reply to your reg code or forum registration email or use the email address on this page.
Cheers,
David.