Hi fellows,
I'm trying to use DATASRC attribute in jsp, but it doesn't work. What I mean
is
there's no data displayed on the page. But, when I change the value
"query.jsp"
to "datasrc.txt" where datasrc.txt contains all the records from such table,
it
worked.
Please help me on this. The purpose I want to do this is to make user life
easier when they want to sort the data on the html page. Because this
technique
of sorting is really fast and no need to do re-query.
Here is the code of mine,
--result.html--
<html>
<body>
<OBJECT id=elem_list CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83">
<PARAM NAME="DataURL" VALUE="query.jsp">
<PARAM NAME="UseHeader" VALUE="True">
</OBJECT>
<TABLE datasrc=#elem_list>
<THEAD> <TR>
<TD> <b> Title </b> </TD>
<TD> <b> Owner </b> </TD>
<TD> <b> Date </b> </TD>
</TR>
<TR>
<TD> <b> <a href="javascript:elem_list.Sort =
'+Title';elem_list.Reset();"> +
</a>
<a href="javascript:elem_list.Sort = '-Title';elem_list.Reset();"> -
</a> </b>
</TD>
<TD> <b> <a href="javascript:elem_list.Sort =
'+Owner';elem_list.Reset();"> +
</a>
<a href="javascript:elem_list.Sort = '-Owner';elem_list.Reset();"> -
</a> </b>
</TD>
<TD> <b> <a href="javascript:elem_list.Sort =
'+Date';elem_list.Reset();"> +
</a>
<a href="javascript:elem_list.Sort = '-Date';elem_list.Reset();"> - </a>
</b>
</TD>
</TR>
</THEAD>
<TBODY>
<TR>
<TD> <SPAN DATAFLD="Title"> </SPAN> </TD>
<TD> <SPAN DATAFLD="Owner"> </SPAN> </TD>
<TD> <SPAN DATAFLD="Date"> </SPAN> </TD>
</TR>
</TBODY>
</TABLE>
</body>
</html>
--query.jsp--
<%@ page import="java.sql.*, java.text.*" %>
<jsp:useBean id="db"
scope="request"
class="com.jspdb.jdbcBean"
/>
<%
db.openConn();
String sqlQuery = "SELECT title, owner, date FROM tb_books";
ResultSet rs = db.getResults(sqlQuery);
out.print("Title,Owner,Date\n");
while (rs.next())
{
String title = rs.getString("urltitle");
String owner = rs.getString("urlowner");
Timestamp date = rs.getTimestamp("urldate");
SimpleDateFormat dateformatter = new SimpleDateFormat("MM/dd/yyyy");
String stringdate = dateformatter.format(date);
out.print(title+","+owner+","+stringdate+"\n");
}
db.CloseStmt();
db.CloseConn();
%>
--datasrc.txt--
Title,Owner,Date
title1,maumul,10/23/2000
title300,maumul,10/28/2000
title2,maumul,10/24/2000
title5,maumul,10/23/2000
title6,maumul,10/23/2000
title4,maumul,10/28/2000
title110,maumul,10/23/2000
Thanks & regards,
Muliawan
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
