Okay, the only thing that's left for me to ask you to try is to remove the
${} in your display tag, i.e.
*<display:table name="${dtSet}" export="true" id="row" class="dataTable" *
to
*<display:table name="dtSet" export="true" id="row" class="dataTable"*
This should work regardless whether you use Struts/Struts2/plain JSP.
Beyond that, I can't think what the issue is as I have never encountered it
yet.
HTH.
On Wed, Jul 2, 2008 at 5:30 PM, Joseph Bautista <[EMAIL PROTECTED]>
wrote:
> Actually there is a record. If I will print the debug of
>
> ResultSet rs = dtset.getDataSet(this.conn, " Select * from oss_users ",
> "" , " order by id");
>
> It will return me something like this.... So I am really lost where is the
> problem;
>
> There is no need to check the value of rs.last because it will return an
> exception if no row has been fetch.
>
> SQL Statement : Select * from oss_users order by id
> Total record found :3
> Name : ID VALUE : 1
> Name : USERNAME VALUE : joseph
> Name : PASSWORD VALUE : 1234
> Name : FNAME VALUE : Joseph
> Name : LNAME VALUE : Bautista
> Name : MNANE VALUE : Dela Cruz
> Name : EMAIL VALUE : [EMAIL PROTECTED]
> Name : POSITION VALUE : Sr. ERTYUSD
> Name : AGE VALUE : 27
> Name : ID VALUE : 2
> Name : USERNAME VALUE : josephcb
> Name : PASSWORD VALUE : 1234
> Name : FNAME VALUE : Joseph
> Name : LNAME VALUE : Bautista
> Name : MNANE VALUE : Dela Cruz
> Name : EMAIL VALUE : [EMAIL PROTECTED]
> Name : POSITION VALUE : Sr. Analyst
> Name : AGE VALUE : 27
> Name : ID VALUE : 3
> Name : USERNAME VALUE : mrlynx
> Name : PASSWORD VALUE : 1234
> Name : FNAME VALUE : Joseph
> Name : LNAME VALUE : Bautista
> Name : MNANE VALUE : Dela Cruz
> Name : EMAIL VALUE : [EMAIL PROTECTED]
> Name : POSITION VALUE : Engineer
> Name : AGE VALUE : 27
>
>
>
> On Wed, Jul 2, 2008 at 11:11 AM, Eduardo Dela Rosa <
> [EMAIL PROTECTED]> wrote:
>
>> 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
>>
>>
>
>
> --
> 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
