VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 Product Sort error message
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

junkmailforken
Starting Member

USA
26 Posts

Posted - November 28 2008 :  11:59:13  Show Profile  Visit junkmailforken's Homepage  Reply with Quote
It seems the only valid field that I can use to sort products is the catalogid field in the products table. When I try to use other fields in the product table I get the following error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

/shop$db.asp, line 618

madbug
VP-ASP New User

130 Posts

Posted - November 28 2008 :  23:38:11  Show Profile  Reply with Quote
Hi There,

The reason is because after changing the xsortproduct, your session is still the old xsortproduct variable. please ensure that you have cleared all session cookies after changing the xsortproducts setting.

Refreshing your browsers cache should resolve this issue for you. or you can try to run shopend.asp?end=1 and it will clear your session.

Hope that will resolve your issue
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000