Hi, I am using DBtag in tomcat with Mysql, one of the fields of a table in
the database is a TEXT field, I want to display only the three first word of
that field as a link, here is what I did :
<sql:preparedStatement id="stmt6" conn="conn1">
<sql:query>
select * from reward
</sql:query>
<sql:resultSet id="rset4">
<%
StringTokenizer st = new StringTokenizer(<sql:getColumn position="6"/>);
StringBuffer sb = new StringBuffer();
int i = 0;
while (st.hasMoreTokens()) {
if (i >= 3)
break;
i++;
sb.append(st.nextToken());
}
%>
<pg:item>
<tr bgcolor="#eeeeff">
<td><sql:getColumn position="2"/></td>
<td><sql:getColumn position="6"/></td>
<td> <a href="nominee.jsp"> <%= sb %></a></td>
</tr>
</pg:item>
</sql:resultSet>
Please could you tell me what's wrong here ?
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
