Do While Loop Problems

gmoney060 · August 8th, 2004, 08:22 PM

This is part of the code i have and i keep getting the following error with my Loops:

Microsoft VBScript compilation error '800a040e'

'loop' without 'do'

/default.asp, line 72

Loop
^

This is the SCRIPT:

    Do While Not Cat.EOF
        If Session("CatID"&Cat("CatID")) = "Y" Then
            Display = "N"
            Image = "images/icon_minus.gif"
        Else
            Display = "Y"
            Image = "images/icon_plus.gif"
        End If
        If Session("CatID"&Cat("CatID")) = "Y" Then
        SubCat.Open "Select * from SubCategories Where CatID="&Cat("CatID"),ObjConn,1,2
        Response.Write("<tr bgcolor=#CCCCCC>")
            Response.Write("<td colspan=6><a href=default.asp?CatID="&Cat("CatID")&"&Display="& Display&"><img src="&Image&" border=0></a> "&Cat("CatName")&"</td>")
            Response.Write("<td> </td>")
        Response.Write("</tr>")
        Do While Not SubCat.EOF
            Response.Write("<tr>")
                Response.Write("<td> </td>")
                Response.Write("<td><a href=forum.asp?ForumID="&SubCat("SubCat")&">"&SubC at("SubCatName")&"</a><br>"&SubCat("SubCatDesc")&"<td>")
                Response.Write("<td>"&SubCat("TotalTopics")&"</td>")
                Response.Write("<td>"&SubCat("TotalPosts")&"</td>")
                Response.Write("<td> </td>")
                Response.Write("<td> </td>")
                Response.Write("<td> </td>")
            Response.Write("</tr>")
        SubCat.MoveNext
        Loop
        SubCat.Close
        Set SubCat = Nothing
    Cat.MoveNext
    Loop
    Cat.Close
    Set Cat = Nothing

rajanikrishna · August 8th, 2004, 08:31 PM

Hello,

You forgot END IF for the seconf IF statement.

happygv · August 8th, 2004, 08:52 PM

Hi gmoney060,

When such errors are shown, it is always a good practice to check for the code around/within construct(for/while/if) so as to check if you have missed something/forgot to close the other construct. Sometimes the entire code has to be looked into. It is not that always the error would be related to the line it shows up for such CONSTRUCT related errors.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection