Sorry, I can't see the problem off the top of my head. It's not a JSP
version issue; these tags do not have any JSP 1.2-specific traits.
- Morgan
On Mon, 14 May 2001, Bob Damato wrote:
> I'm having trouble with the the dbTags taglib. I've gotten everything to execute,
>but the results are not what I expected. I used the example code (changing just the
>url, driver and query) and the results are very odd. It outputs the data returned
>from the database query, but it's not mixed in with the HTML within the resultSet tag
>(see below).
>
> My guess is that it's a JSP1.1 vs. JSP1.2 issue. Can anyone verify? I'm confused as
>to why the taglib was coded using the 1.2 spec when it's not official and most
>commercial app servers only support the 1.1 spec.
>
>
> Here's my jsp page.
> ========================================================================
> <%@ taglib uri="/dbtags.tld" prefix="sql" %>
>
> <%-- open a database connection --%>
> <sql:connection id="conn1">
> <sql:url>jdbc:bitmechanic:pool:admin</sql:url>
> <sql:driver>com.sybase.jdbc2.jdbc.SybDriver</sql:driver>
> </sql:connection>
>
> <%-- open a database query --%>
> <table border=4>
> <sql:preparedStatement id="stmt1" conn="conn1">
>
> <sql:query>
> select super_cat, description, lastupd from super_cat
> </sql:query>
>
>
> <sql:resultSet id="rset1">
> <tr>
> <td><sql:getColumn position="1"/></td>
> <td><sql:getColumn position="2"/></td>
> <td><sql:getColumn position="3"/></td>
> </tr>
> </sql:resultSet>
>
>
> </sql:preparedStatement>
> </table>
>
> <%-- close a database connection --%>
> <sql:closeConnection conn="conn1"/>
> ========================================================================
>
>
>
>
>
>
>
>
> Here are the results:
> ========================================================================
> <table border=4>
> 0FIX1998-09-10 17:18:13.313101Auto/Transportation1999-09-30
>00:00:00.0102Beauty/Fitness1999-09-30 00:00:00.0103Entertainment/Leisure1999-09-30
>00:00:00.0104Home Services/Improvement1999-09-30 00:00:00.0105Medical
>Services1999-09-30 00:00:00.0106Professional Services1999-09-30
>00:00:00.0107Retail1999-09-30 00:00:00.0108Restaurants1999-09-30
>00:00:00.0109Technology/Communication1999-09-30 00:00:00.0<tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
>
> <tr>
> <td></td>
> <td></td>
> <td></td>
> </tr>
> </table>
> ========================================================================
>
>
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Bob Damato Cox Target Media
> Senior Internet Developer http://www.valpak.com
>
> If at first you don't succeed, skydiving is not for you.
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
