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
 Problems and bugs
 product sort problem (xsortproducts)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cabc
Starting Member

United Kingdom
3 Posts

Posted - February 06 2009 :  10:01:55  Show Profile  Visit cabc's Homepage  Reply with Quote


when I try to set the product sort to a field other than cname I get an SQL error which indicates that because a distinct select query is being used the sort field must be included in the select fields list. I turned on debug and sure enough there's only one other field in the selected fields catalogid. Selecting this as xsortproducts works. nothing else does eg. pother.

I think this is a problem, or did I miss some way of changing the selected fields list?

(Vpasp 6.5)
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000