Displaying the result set

[Mary Wallace]

I am having difficulty in dispalying the result frm db.
this is my query which is working fine and in the page when i use <%=s%> this I am getting error. Is something wrong what i am doing

 try{
Driver myDriver = (Driver)Class.forName("weblogic.jdbc.pool.Driver").newInstance();
con = myDriver.connect("jdbc:***** :-P	 ool:WRRR", null); 
}catch(Exception e){
System.out.println("DB Connection Error: " + e);

}

int i = 0;
try{

   PreparedStatement qry = con.prepareStatement
("Select  decode(to_char(sysdate ,'Q') ,1 ,'First Quater' ,2 ,'Second Quarter',3 ,'Third Quarter' ,4,'Fourth Quarter') || ' of '|| to_char(sysdate,'YYYY') from dual");
         rs=qry.executeQuery();

  while(rs.next()){
String s = rs.getString(1);
System.out.println(s);
if(s.equals(""))
{
s = "No information at this time. This section is under construction.";
}
i++;
  }
rs.close();

}catch(Exception e){
System.out.println("DB Connection Error: " + e);
}
%> 

<%=s%> giving me an error. How should i display s . System.out.println printed s correctly/
Thanks in advance

[Tim Baker]

well it depends where you are trying to use s. because s is declared in that while loop, you can only use s in that while loop, because it takes on many values you would only want to anyway. so lets see the actual bit where you use s.
if you are going to use it within the while loop it is much easier to do:
out.println(s);
rather than
%> <%=s %> <%
which may be what you were doing?
you probably also want to put some HTML either side of s so it's probably more like
out.println("<blah>" + s + "</blah>");
etc etc

[steve souza]

Look at the open source FormattedDataSet API for an easy way generating this type of dynamic text. A live demo is available at http://www.fdsapi.com that allows you to enter any query and return it as an html table. The html table also has clickable/sortable column headers. The direct link to the sort demo is http://www.ssouza.com/fdsapi/sortdemo.jsp
steve - http://www.fdsapi.com - The easiest way to generate dynamic text including HTML and XML.