What server do you use?... The code is correct and it should work.
Mihai Manuta
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bob Damato
Sent: Monday, May 14, 2001 7:21 PM
To: jakarta taglibs mailing list
Subject: DBTags Taglib
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.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
