Welcome, Guest ( Customer Panel | Login )




 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
0 Item(s)
$0.00