Bert,
I don't know if you put the entire example code into your email below, but
if you did, you will notice that you are declaring an SQL statement and
assigning it to the variable q1 in this tag (<jrun:sql connection="<%=con%>"
id="q1">), yet you are executing the sql statement assigned to the variable
q3 in this tag(<jrun:param id="q3" type="javax.sql.Rowset"/>) and then
trying to retrieve the records within q3. If you do not have a second SQL
statement assigned to q3 that you have NOT included in the posting below,
try changing the execution tag to q1 (<jrun:param id="q1"
type="javax.sql.Rowset"/>) and change your for each loop to use the variable
q1.
Celeste
-----Original Message-----
From: Bert [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 12, 2001 4:00 PM
To: JRun-Talk
Subject: Sql tag rowset help
Im trying to run the sample in Jrun docs and I am using the latest Jdk but
still get error Rowset not found.
Bert
<%@page import="java.sql.*,javax.sql.*,allaire.taglib.*"%>
<%@taglib uri="jruntags" prefix="jrun" %>
<!doctype html public"-//w3c/Dtd Html 4.0 Transitional//EN">
<html><head><title>Sql Tag Example</title></head><body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:odbc:company","sa","");
%>
<jrun:sql connection="<%=con%>" id="q1">
select * from company_info
</jrun:sql>
<jrun:param id="q3" type="javax.sql.Rowset"/>
<jrun:foreach group="<%=q3%>">
<%=q3.getObject("Companyname")%>
</jrun:foreach>
Compilation error occured:
allaire.jrun.scripting.DefaultCFE:
Errors reported by compiler:C:/Program
Files/Allaire/JRun/servers/default/default-app/WEB-INF/jsp/jrun__Tagtest2ejs
pc.java:87:19:87:24: Error: Type javax/sql/Rowset was not found.
at
allaire.jrun.scripting.JavaCompilerService.compile(../scripting/JavaCompiler
Service.java:96)
at allaire.jrun.jsp.Translator.compilePage(../jsp/Translator.java:247)
at allaire.jrun.jsp.Translator.translate(../jsp/Translator.java:399)
at allaire.jrun.jsp.Translator.translate(../jsp/Translator.java:92)
at allaire.jrun.jsp.JSPTranslator.translate(../jsp/JSPTranslator.java:75)
at allaire.jrun.jsp.JSPTranslator.translate(../jsp/JSPTranslator.java:67)
at allaire.jrun.jsp.JSPServlet.service(../jsp/JSPServlet.java:216)
at allaire.jrun.jsp.JSPServlet.service(../jsp/JSPServlet.java:196)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1416)
at
allaire.jrun.session.JRunSessionService.service(../session/JRunSessionServic
e.java:1082)
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1270)
at
allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDis
patcher.java:89)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1552)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1542)
at allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:364)
at allaire.jrun.http.WebEndpoint.run(../http/WebEndpoint.java:115)
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272)
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
