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!
counter = 0 limit = 5 Dim cConnection Set cConnection = CreateObject("ADODB.Connection") //setting variables here for connection string, username, password. cConnection.Open DBConString,DBUser,DBPass SQLstmt = "SELECT field1, field2 from Table1 WHERE Field1 IS NULL" Set RS = cConnection.Execute(SQLstmt) while (not RS.EOF) AND (counter < limit) msgbox("Field1: " & RS.Fields.Item("field1").value) //do other stuff counter = counter + 1 RS.Movenext() wend
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.