calculation loop problem

[jordan11]

I have another problem with getting the correct results in my counter.

what I would like to happen is if the questionid in one table matches the questionid in a second table then i want to add 2 to the counter and then get the total at the end of the loop.
But what is actually happening is I am getting the total count of the actual questionid.
so i am getting 1+2+3+4 instead of 2+2+2+2

this is my code below

QUESTIONS=0
DO While not rt.EOF
O_questionID = cint(trim(rt("oQuestionID")))
if O_questionID = P_questionID then
question=question+2
else
question = question+2
end if
rt.movenext
loop

thanks

 

[vbkris]

hm,
i dont see any error in the code that u have given.

but i do have one suggestion:
why not try an inner join?

Known is handfull, Unknown is worldfull

 

[jordan11]

I found mistake had my counter set to questions and was looking for question
ignore this post

 

[DotNetGnat]

if CINT(O_questionID) = CINT(P_questionID) then

-DNG