ProductCart Shopping Cart Software Forums : AdminFeatures.asp not show current featured prod https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 06:55:33 +0000 Thu, 10 Sep 2009 15:09:58 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3026 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[AdminFeatures.asp not show current featured prod : We&#039;re having a really weird...]]> https://forum.productcart.com/adminfeatures-asp-not-show-current-featured-prod_topic3026_post11317.html#11317 Author: BrianRoden
Subject: 3026
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?]]> Thu, 10 Sep 2009 15:09:58 +0000 https://forum.productcart.com/adminfeatures-asp-not-show-current-featured-prod_topic3026_post11317.html#11317