WSP + PED causing search.asp issue

Author	« Topic »
isntworkdull Ecommerce Template Expert United Kingdom 900 Posts Pre-sales questions only (More Details...)	Posted - 05/10/2024 : 06:10:15 Hi Guys I noticed while messing around if i enable a logged in client to have "WSP+PED" (so wholesale prices and a percentage discount) everything works fine on product pages / cart etc... but get an error on the search.asp page Any ideas why that is? and is there an easy fix? thanks Edited by - isntworkdull on 05/10/2024 06:10:44
Vince Administrator 42766 Posts	Posted - 05/11/2024 : 10:47:21 Hi there I tried here and it all seems to be ok to tell the truth. Could you let me know the details of the error you get? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
isntworkdull Ecommerce Template Expert United Kingdom 900 Posts Pre-sales questions only (More Details...)	Posted - 05/14/2024 : 07:56:38 see error: Microsoft JET Database Engine error '80004005' The ORDER BY expression (0.95*pWholesalePrice) includes fields that are not selected by the query. Only those fields requested in the first query can be included in an ORDER BY expression. /vsadmin/inc/incsearch.asp, line 262
Vince Administrator 42766 Posts	Posted - 05/14/2024 : 08:57:25 Ok, I've tried here with a JET database connection and settings that would cause the ordering that is causing your problem and I still can't get this to go wrong. Could you possibly try a connection string of this form though to see if that helps? sDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\yourdbfolder\vsproducts.mdb;" Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
isntworkdull Ecommerce Template Expert United Kingdom 900 Posts Pre-sales questions only (More Details...)	Posted - 05/17/2024 : 05:08:44 that crashed my site... No big deal, it was just a feature I was thinking about... but in theory my site should support this even on my database good to know
Vince Administrator 42766 Posts	Posted - 05/22/2024 : 02:26:21 quote: but in theory my site should support this even on my database Yes, but I tried here with the database driver you are using and everything was ok. But did it work with the ACE.OLEDB driver? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
isntworkdull Ecommerce Template Expert United Kingdom 900 Posts Pre-sales questions only (More Details...)	Posted - 05/30/2024 : 04:59:22 no, as soon as i changed to your "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" i get the error in admin: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /inc/incloginfunctions.asp, line 13 strangely the website still seems to function - but that must be a cache issue as admin area crashes
	« Topic »