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-Cart StoreFront Customer Forum

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

 All Forums
 VPCart Forum
 Problems and bugs
 Problem when using customer prices
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

11 Posts

Posted - July 06 2007 :  15:59:35  Show Profile  Reply with Quote
In shopproductsubs, the sql does not include all of the necessary fields when using customer pricing. When you define the field in products for the second price (such as price3), it is not included in the query. So, when Top Sellers are presented and customer prices are used, an error occurs:

Item cannot be found in the collection corresponding to the requested name or ordinal.

Here is the sql line with the missing fields.

psql="select hp.ccategory, hp.catalogid, hp.cimageurl, p.cprice, p.cname AS cname, p.cstock as cstock, hp.cname AS hpcname, hp.hide AS hphide, p.productmatch, p.customermatch, p.hide AS childhide, hp.cdescription from products p, products hp where p.highercatalogid = hp.catalogid AND p.catalogid =" & lngcatalogid


4305 Posts

Posted - July 09 2007 :  02:02:27  Show Profile  Visit support's Homepage  Reply with Quote

Thank you for alerting us to this - it will be addressed in a future release.

VP-ASP Support
Go to Top of Page

VP-ASP New User

94 Posts

Posted - November 11 2011 :  19:13:13  Show Profile  Reply with Quote
Has anyone updated this issue, i encounter that there are database open connections left by this issue, can some suggest a fix, here is an example of the open connections:

sleeping 9.713 11/11/2011 5:06:18 PM select *, hide AS hphide, hide AS childhide from products where catalogid=81208


Please Advice.

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