MySQL - I get only 1 row in my output?

Question

This is my jsp page to execute a query. When I run it, I get only 1 row from the courses table in the output. I was getting the right output a while ago, then I started working with the interface and realised that I don't get the correct output anymore. Can anybody point out the mistake? Thank you.

rs = statement.executeQuery("select * from courses");

<TABLE cellpadding="15" border="1" style="background-color: #ffffcc;">
<%

while (rs.next()) {
%>
<TR>
<TD><%=rs.getString(1)%></TD>
<TD><%=rs.getString(2)%></TD>
<TD><%=rs.getString(3)%></TD>
<TD><%=rs.getString(4)%></TD>
<TD><%=rs.getString(5)%></TD>
<TD><%=rs.getString(6)%></TD>
<TD><%=rs.getString(7)%></TD>
</TR>
}

How many records are in the courses table? Make sure that it's more than one. — Trevor
– Trevor, Commented Apr 19, 2012 at 17:45
you may attach the name of the programming language used as a tag — Hajo
– Hajo, Commented Apr 19, 2012 at 17:58

ethrbunny · Accepted Answer · 2012-04-19 17:59:03Z

1

Assuming your paste is correct you are missing the

<%
}
%>

around the end of the loop.

answered Apr 19, 2012 at 17:59

ethrbunny

10.5k9 gold badges77 silver badges145 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1291453 Over a year ago

everything was right, i just restarted the tomcat server and it worked fine. thanks

Collectives™ on Stack Overflow

MySQL - I get only 1 row in my output?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related