[thelist] [JSP/MySQL] What the ---??? Output ending abruptly
Howard Cheng
thelist at lists.evolt.org
Tue Mar 5 13:34:00 2002
I've got a bizarre problem. I have a JSP page ending in the middle of a
while loop for no particular reason. The loop is printing out <OPTION>s for
a <SELECT> box, based off a query to a MySQL database.
CODE:
szSQL = "SELECT DISTINCT id, description FROM Groups ORDER BY description";
rs = statement.executeQuery(szSQL);
while (rs.next()) { %>
<option value="<%= rs.getString("id") %>"><%=
rs.getString("description") %></option>
<% }
rs.close();
%>
Seems simple enough and I've used the same exact query somewhere else on
the site and it works fine. Pasting the query directly into the database
returns the entire expected result set. But on this page, it just quits in
the middle of the loop -- always in the same place, to boot.
Any ideas?
Thanks in advance.
::::::::::::::::::::::
Howard Cheng
howcheng@ix.netcom.com
AIM: bennyphoebe
ICQ: 47319315