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