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

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

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

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

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