Using ProductCart - AdminFeatures.asp not show current featured prod

Print Page | Close Window

AdminFeatures.asp not show current featured prod

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3026
Printed Date: 27-July-2025 at 1:50am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: AdminFeatures.asp not show current featured prod

Posted By: BrianRoden
Subject: AdminFeatures.asp not show current featured prod
Date Posted: 10-September-2009 at 3:09pm

We're having a really weird issue. When going to the /cart/pcadmin/AdminFeatures.asp to manage featured products, the admin page is not showing the list of currently featured items. It says "No Featured Items Found". But the featured items are displaying on the storefront home page. And if I do a remote desktop session to the web server and run SQL Server Management Studio Express to execute the query

SELECT pcprod_OrdInHome,idproduct,sku,description FROM products WHERE active=-1 AND showInHome=-1 ORDER BY pcProd_OrdInHome

I get the list of 6 featured items. But for some reason, when the AdminFeatures.asp page executes that query, it is getting an EOF. I temporarily modified the source for that section to

rstemp.Open query, connTemp, adOpenStatic, adLockReadOnly

dontshow="0"

If rstemp.eof Then

dontshow="1"

response.Write "End of File on featured items"

end if

and the page is showing my diagnostic message right under the Featured Products header.

Why would the home page be able to see the records when running the query, but the contral panel page not?