Why don't you param it as an allaire.taglib.QueryTable object?
Drew Falkman
----- Original Message -----
From: "Bert" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 10:43 AM
Subject: Re: Sql tag rowset help
> 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
