Problems with do Exception Occured error with an If statement in a Do While loop

• • Reply

  14 years ago

  by arobbo

  andy

  , United Kingdom

  Joined 14 years ago

  Hi guys this is my first time on this forum , sorry i couldn't work out how to format the code below to make it easier to read....

  Basically when i run this code i'm getting the error Exception Occured at the first If Then statement below.

  However if i remove the do while loop it works fine and will display the first weeks worth of data i have, however i really want it to loop through and display the data for the other three weeks below in subsequent rows...

  can anyone here see anything obviously wrong with the code below.....

  Many thanks for your help

  Andy

  
  <%
  do while NOT rsCalender.EOF
  numberofDay = 2
  %>
  <TR>
  <% while numberofDay < 8 %>
  <TD><%
  if datepart("w",rsCalender("wages_calc1_Date") ) = numberofDay Then
  response.write rsCalender("wages_calc1_type") & " <BR> "
  response.write rsCalender("job_name")
  response.write rsCalender("wages_calc1_Date")
  rsCalender.MoveNext
  else
  response.write "-"
  end if
  %>
  </td>
  <%
  numberofDay = numberofDay + 1
  wend %>
  <TD>
  <%
  if datepart("w", rsCalender("wages_calc1_Date")) = 1 Then
  response.write rsCalender("wages_calc1_type") & " <BR> "
  response.write rsCalender("job_name")
  rsCalender.MoveNext
  else
  response.write "-"
  end if
  %>
  </td>
  </tr>
  <% loop %>
  </table>
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  Report abuse
• • Reply

  14 years ago

  by chandrababu

  chandrababu

  New Jersey, United States

  Joined 15 years ago

  You are moving record in the while loop.

  You should exit the while loop instead of   Movenext.

  If not you have to check end of record before using the movenext.

  Report abuse