What you can do is to put debug statement, i.e.,
boolean *isThereARow* = rs.last();
*isThereARow* variable should be true if there are records from your query.
If you are not getting any exceptions or stack trace, I would suppose that
everything is okay EXCEPT that your QUERY is not returning any records at
all.
hth
On Wed, Jul 2, 2008 at 4:39 PM, Joseph Bautista <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Thanks for the reply. I tried but to no avail (see below). Is there a way
> for me to dump the value of ${dtSet} in jsp like a Data::Dumper in CGI?
>
> dataset dtset = new dataset();
> ResultSet rs = dtset.getDataSet(this.conn, " Select * from oss_users
> ", "" , " order by id");
> ArrayList userList = new ArrayList();
> users user = new users();
> try {
>
> rs.last();
> int last = rs.getRow();
> int ctr = 0;
> rs.first();
>
> for (ctr = 0; ctr < last; 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);
> }
> Regards,
> Joseph
> On Wed, Jul 2, 2008 at 10:05 AM, Eduardo Dela Rosa <
> [EMAIL PROTECTED]> wrote:
>
>> 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
>>
>>
>
>
> --
> 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
