Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
strSQL = "SELECT SH_Products.Product_ID, "&_ "SH_Products.Product_ID, "&_ "SH_Products.Product_Name, "&_ "SH_Products.Product_Code, "&_ "SH_Products.Product_IconPic, "&_ "SH_Products.Product_ExMedia1, "&_ "SH_Products.Product_ExMedia2, "&_ "SH_Products.Product_ExMedia3, "&_ "SH_Products.Product_ExMedia4, "&_ "SH_Products.Product_Active, "&_ "SH_ProdGals.NumberOfImages "&_ "FROM SH_Products left outer join (select SH_ProdGals.ProdGals_PicID, COUNT(*) as NumberOfImages from SH_ProdGals group by SH_ProdGals.ProdGals_PicID) SH_ProdGals on SH_Products.Product_ID = SH_ProdGals.ProdGals_ProdID WHERE SH_Products.Product_SubSiteID = " & Session("Subsite_ID") & " Order By SH_Products.Product_ID;" Set rsData = MyConn.Execute(strSQL) If Not rsData.EOF Then ArrProds = rsData.GetRows() End If rsData.Close
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.