parallon
08-22-2006, 06:31 PM
Hello all. I have the following scenario in which I need help with:
rs1
Do Until rs1.EOF
rs2
loop
So, here is what is going on. I am basically getting a list of labor and their work days which belong to a specific Project (rs1), and rs2 will check all other projects and check it against the results of rs1 and make sure that this labor is not on them. So basically, to make sure that this person is not double booked. Well, the problem I am running into is that if rs2 is empty, I get the following error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/Rpts/Project/IndivConfRpt_Labor.asp, line 160
... where line 160 is the closing statement of rs2.
I am assuming that I need the following statement between rs1 and rs2:
IF (NOT rs1.BOF) AND (NOT rs1.EOF) THEN
but where would the END IF go? Or is there a better way to do this?
Thanks in advance,
Parallon
rs1
Do Until rs1.EOF
rs2
loop
So, here is what is going on. I am basically getting a list of labor and their work days which belong to a specific Project (rs1), and rs2 will check all other projects and check it against the results of rs1 and make sure that this labor is not on them. So basically, to make sure that this person is not double booked. Well, the problem I am running into is that if rs2 is empty, I get the following error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/Rpts/Project/IndivConfRpt_Labor.asp, line 160
... where line 160 is the closing statement of rs2.
I am assuming that I need the following statement between rs1 and rs2:
IF (NOT rs1.BOF) AND (NOT rs1.EOF) THEN
but where would the END IF go? Or is there a better way to do this?
Thanks in advance,
Parallon