We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Function SingleItem(Category,RowNumber) SQL=" SELECT * FROM ( " SQL=SQL & " Select Description, PartNo, " SQL=SQL & " Row_Number() Over(Order By PartNo) as rownumber, " SQL=SQL & " Count(*) Over() as TotalRecordCount " SQL=SQL & " From Products " SQL=SQL & " where Category = '" & Category & "' ) T1 " SQL=SQL & " WHERE rownumber = '" & RowNumber & "' " SQL=SQL & " Order By partno asc " Set dbsecurecon = Server.CreateObject("ADODB.Connection") dbsecurecon = "PROVIDER=SQLOLEDB;DATA SOURCE=1xxx;DATABASE=xxx;User ID=sa;Password=xxx" Set RS = Server.CreateObject("ADODB.recordset") RS.open SQL, dbsecurecon,3,3 If Not RS.EOF Then PartNo = RS("PartNo") End If SingleItem=PartNo End Function
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.