I made to change to<%@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="q1" type="javax.sql.Rowset"/>
<jrun:foreach group="<%=q1%>">
<%=q1.getObject("Companyname")%>
</jrun:foreach>
And still same error I am going to go over this doc one more time.
----- Original Message -----
From: "Haseltine, Celeste" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 11:11 AM
Subject: RE: Sql tag rowset help
> 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
