I am trying to create an ASP page that displays two products per table row. Any ideas why I would be receiving a 'loop' without 'do' error based on the code I have attached??

          <%
              Dim counter
            counter = 0

              DO WHILE NOT objRS.EOF
                    IF counter = 0 THEN
                        Response.Write "<td width=""309"" class=""bodyText"">" & objRS("basketTitle") & "<br>" & objRS("basketDescription") & "</td>"
                        counter = 1
                    ELSE IF counter = 1 THEN
                        Response.Write "<tr><td width=""309"" class=""bodyText"">" & objRS("basketTitle") &"<br>" & objRS("basketDescription") & "</td>"
                        counter = 2
                    ELSE
                        Response.Write "<td width=""309"" class=""bodyText"">" & objRS("basketTitle") & "<br>" & objRS("basketDescription") & "</td></tr>"
                        counter = 1
                    END IF
                objRS.MoveNext
            LOOP

            %>

Try ELSEIF instead of ELSE IF.

What you code says is

DO WHILE ??
IF counter = 0 THEN
     'do something
ELSE
     IF counter = 1 THEN
     'do something
     ELSE
     'do Something
     END IF
     objRS.MoveNext
     LOOP

The loop above comes before the end of the first IF statement


======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

MORE:

Else if's are not really required for your situation

<%
    Dim counter
    counter = 0
    response.write("<TR>")
    DO WHILE NOT objRS.EOF
        Response.Write "<td width=""309"" class=""bodyText"">" & objRS("basketTitle") & "<br>" & objRS("basketDescription") & "</td>"
        if ((counter mod 2) > 0) then response.write("</TR><TR>")
        counter = counter + 1
        objRS.MoveNext
    LOOP
    response.write("</TR>")
%>


======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

Works like a charm... thanks Rod!