Hi, I am using DBtag, and amongst the fields in the table I have a TEXT
field, I want to display all the fields and only the three words of the
column that is a TEXT field.
could you please help.
Thanks lot.

You should pass it (the sb object) to your text fields this way approximately:

StringTokenizer st = new StringTokenizer(String yourString);
StringBuffer sb = new StringBuffer();
int i = 0;
while (st.hasMoreTokens()) {
  if (i >= 2)
    break;
  i++;
  sb.append(st.nextToken());
}

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> <%= sb %></td>
   </tr>
</pg:item>
</sql:resultSet>

Here is the error I got :

Error: 500
Location: /abovebeyond/ThisMonth.jsp
Internal Servlet Error:

org.apache.jasper.JasperException: Unable to compile class for
JSPC:\tomcat323\work\localhost_8080%2Fabovebeyond\_0002fThisMonth_0002ejspThisMonth_jsp_33.java:321:
Missing term.
                                 StringTokenizer st = new StringTokenizer();
                                                                          ^
C:\tomcat323\work\localhost_8080%2Fabovebeyond\_0002fThisMonth_0002ejspThisMonth_jsp_33.java:321:
')' expected.
                                 StringTokenizer st = new StringTokenizer();

^
2 errors

thanks

Off course this is wrong. You should pass to the StringTokenizer constructor the String object - You know, java.lang.String, not any things like that:
new StringTokenizer(<sql:getColumn position="6"/>);
This is absolutely wrong. So You ought to create a String object first with the appropriate text You need.

See http://www.developerzone.biz/index.php?option=com_content&task=view&id=89&Itemid=36 Java StringTokenizer tutorial