cvandergriff
Starting Member
11 Posts |
Posted - July 06 2007 : 15:59:35
|
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 |
|
skynet104
VP-CART New User
94 Posts |
Posted - November 11 2011 : 19:13:13
|
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
VPASP 6.5 MS-SQL
Please Advice.
Thansk |
|
|