ProductCart Shopping Cart Software Forums : Random Order featured Products https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 06:42:21 +0000 Sat, 09 Sep 2006 18:55:34 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=448 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Random Order featured Products : I replaced the &#034;order by...]]> https://forum.productcart.com/random-order-featured-products_topic448_post1327.html#1327 Author: dwatch
Subject: 448
Posted: 09-September-2006 at 6:55pm

I replaced the "order by pcprod_OrdInHome asc" with

order by NEW(ID)"

in the sql query that pulls featured products to display them on home.asp.  The goal of course is to randomly show featured products.  Anyone have an idea why i am getting an error?

 

Here is my new sql query:

 

query="SELECT distinct products.idProduct,products.sku,products.description,product s.price,products.listPrice,products.listHidden,products.serv iceSpec,products.listPrice,products.bToBPrice,products.small ImageUrl, products.pcprod_HideBTOPrice,products.noprices,products.stoc k,products.noStock,products.formQuantity,products.pcProd_Bac kOrder,pcprod_OrdInHome FROM products,categories_products,categories WHERE products.active=-1 AND products.showInHome=-1 AND products.configOnly=0 AND products.removed=0 AND formQuantity = 0 AND categories_products.idProduct=products.idProduct AND categories.idCategory=categories_products.idCategory AND categories.iBTOhide=0 " & query1 & " order by NEWID()"

]]> Sat, 09 Sep 2006 18:55:34 +0000 https://forum.productcart.com/random-order-featured-products_topic448_post1327.html#1327