AdminFeatures.asp not show current featured prod

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Topic: AdminFeatures.asp not show current featured prod 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?