With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
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
|Access importing CSV that has commas in currency and needs 2 cols formated for numbers to text||5||34|
|Format a Field AFTER UPDATE||5||29|
|Executing SSIS with a Stored Procedure Permissions||12||26|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!