I have an array I am trying to create and I am recieving a type mismatch error. can anyone tell me why I would see this. This is my first time working with arrays
<%
dbrs2.open ("Select * from timemonths where approval = 1"
, dbconn, 0, 1
i = 0
dbrs2.movefirst
Do until EOF
cal(i,0) = dbrs2("loginID"
----- This is the error line.
cal(i,dbrs2("monthnumber"
) = "X"
Movenext
if dbrs2("loginID"
<> cal(i,0) Then
i = i + 1
End if
loop
i = i + 1
cal(i,0) = "Done"
%>
<%
dbrs2.open ("Select * from timemonths where approval = 1"
i = 0
dbrs2.movefirst
Do until EOF
cal(i,0) = dbrs2("loginID"
cal(i,dbrs2("monthnumber"
Movenext
if dbrs2("loginID"
i = i + 1
End if
loop
i = i + 1
cal(i,0) = "Done"
%>