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
 Wish Lists
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

carfin
VP-ASP Expert

United Kingdom
948 Posts

Posted - March 28 2012 :  12:00:36  Show Profile  Reply with Quote
Hi all,

I'm stumped. How would I change shopwishlist.asp to show the listed products sorted by ccode and not catalogid. I've tried and tried but cannot get this to work.

Thanks in advance,

Carrol
www.deanston-electrical.co.uk

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - March 28 2012 :  22:18:25  Show Profile  Reply with Quote
easy enough i think.

open that file shopwishlist.asp and spot to code :

sql = "select * from savedcarts where customerid=" & customerid
sql = sql & " and cartname is null"

trying to replacing the code to :

sql = "select * from savedcarts a, products b where a.customerid=" & customerid
sql = sql & " and a.cartname is null"
sql = sql & " and a.catalogid = b.catalogid"
sql = sql & " ORDER BY b.ccode"

and you ll also need to update code ( on line 125 maybe) :

CatalogId = rs("CatalogId")

trying to replacing it with :

CatalogId = rs("a.CatalogId")

hopefully what i have shared for you is useful/

Diego.
Go to Top of Page

carfin
VP-ASP Expert

United Kingdom
948 Posts

Posted - March 29 2012 :  04:11:43  Show Profile  Reply with Quote
Yes Diego it was very useful.

Works perfectly :)

Thank you very much.

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

diegomilito
VP-ASP Expert

Argentina
723 Posts

Posted - May 24 2012 :  05:24:27  Show Profile  Reply with Quote
carfin, just a place where we can share something good:D

diego
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000