Bob Schneider
asked on
GetRows(), Part 2
Is there a way to use GetRows() on this...I am concerned with filtering out the records that are blank but not null:
i = 0
ReDim AsgndBibs(0)
Set rs = New ADODB.Recordset
sql = "SELECT pr.Bib FROM PartRace pr INNER JOIN RaceData rd ON pr.RaceID = rd.RaceID WHERE rd.EventID = "
sql = sql & lEventID & " AND pr.Bib IS NOT NULL ORDER BY pr.Bib"
rs.Open sql, conn, 1, 2
Do While Not rs.EOF
If Not rs(0).Value & "" = "" Then
AsgndBibs(i) = rs(0).Value
i = i + 1
ReDim Preserve AsgndBibs(i)
End If
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER