I think this line
for (ctr = 0; ctr < *rs.getRow()*; ctr++ )
will keep your code from loading contents of your ResultSet into your List.
rs.getRow() returns the current row pointer (which is ZERO) and will never
be greater than your counter.
hth.
On Wed, Jul 2, 2008 at 2:42 PM, Joseph Bautista <[EMAIL PROTECTED]>
wrote:
> Hello,
>
> Can someone shed light please?
>
> Regards
>
> On Fri, Jun 27, 2008 at 8:58 AM, Joseph Bautista <
> [EMAIL PROTECTED]> wrote:
>
>> Hello Gurus,
>>
>> I've been fixing this "Nothing to display" problem for week now but to
>> no avail. Can somebody please help?? See code below...
>>
>> public void contextInitialized(ServletContextEvent sce) {
>>
>> dataset dtset = new dataset();
>> ResultSet rs = dtset.getDataSet(this.conn, " Select * from oss_users
>> ", "" , " order by id"); This returning the list
>> ArrayList userList = new ArrayList();
>> users user = new users();
>> try {
>>
>> rs.last();
>> int ctr = 0;
>> rs.first();
>>
>> for (ctr = 0; ctr < rs.getRow(); ctr++ ){
>> user.setId(rs.getString("ID"));
>> user.setPassword(rs.getString("PASSWORD"));
>> user.setUsername(rs.getString("USERNAME"));
>> user.setFname(rs.getString("FNAME"));
>> user.setMname(rs.getString("MNAME"));
>> user.setLname(rs.getString("LNAME"));
>> user.setEmail(rs.getString("EMAIL"));
>> user.setPosition(rs.getString("POSITION"));
>> user.setAge(rs.getString("AGE"));
>> userList.add(user);
>> rs.next();
>> }
>>
>> } catch (SQLException e){
>> e.printStackTrace();
>> }
>> sce.getServletContext().setAttribute("dtSet", userList);
>> }
>> In my jsp:
>>
>> <display:table name="${dtSet}" export="true" id="row" class="dataTable"
>> defaultsort="1" defaultorder="ascending"
>> pagesize="16" cellspacing="0" >
>> <display:column property="ID" title="ID"
>> class="hidden" headerClass="hidden" media="html" />
>> <display:column property="USERNAME"
>> title="Username" sortable="true" class="username" headerClass="username" />
>> <display:column property="PASSWORD"
>> title="password" class="hidden" headerClass="hidden" media="html" />
>> <display:column property="FNAME"
>> title="First Name" sortable="true" class="fname" headerClass="fname" />
>> <display:column property="LNAME"
>> title="Last Name" sortable="true" class="lname" />
>> <display:column property="MNAME"
>> title="Middle Name" sortable="true" class="mname" headerClass="mname" />
>> <display:column property="EMAIL"
>> title="Email Address" sortable="true" class="email" headerClass="email" />
>> <display:column property="POSITION"
>> title="Position" sortable="false" class="position" headerClass="position" />
>> <display:column property="AGE"
>> title="AGE" sortable="false" class="age" headerClass="age" />
>> </display:table>
>> In my web.xml,
>>
>> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee";
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
>> xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
>> http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd";>
>> <welcome-file-list>
>> <welcome-file>users.jsp</welcome-file>
>> </welcome-file-list>
>> <listener>
>> <listener-class>oss.service.dataloader</listener-class>
>> </listener>
>>
>> </web-app>
>>
>> Regards,
>>
>> Joseph
>> --
>>
>>
>
>
> --
> Joseph DC Bautista
>
> Senior Activation Analyst - OSS
> Tel +971 4 369 2063
> Mobile +971 55 953 1596
> www.du.ae
>
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> displaytag-user mailing list
> displaytag-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/displaytag-user
>
>
--
Eduardo Dela Rosa
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
