Re: Using jrun:sql Recordset in custom TagLib?

Younas Aamir Tue, 22 Aug 2000 06:17:17 -0700

Hi Clement

Thanks for help. One more question.
Is there any method which can give me field data type?

Thanks

Younas Aamir
htt://advcomm.net

try this:
import allaire.taglib.*;
....
QueryTable rsnew = (QueryTable)pageContext.getAttribute("rs");
--
Clement Wong
JRun Engineer
< a l l a i r e >
-----Original Message-----
From: Younas Aamir [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 2:41 AM
To: [EMAIL PROTECTED]
Subject: Re: Using jrun:sql Recordset in custom TagLib?
--------------EFB6240806D268C5BCA837A7
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi Clement
Thanks for your reply.
I want to get resultset like this.
ResultSet rsnew = (ResultSet) pageContext.getAttribute("rs");
but its giving error. Could you tell me the right way to loop over on this
resultset like
while (rsnew.next()){
 pageContext.getOut().println(rsnew.getString("Color"));
 pageContext.getOut().println(" ");
}
Thanks.
Younas Aamir
http://advcomm.net
> You still use that while loop to traverse the recordset. You can use
> pageContext.getAttribute("rs") from within your tag handler class
> to get the recordset.
>
> --
> Clement Wong
> JRun Engineer
> < a l l a i r e >
>
> -----Original Message-----
> From: Younas Aamir [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 18, 2000 8:00 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Using jrun:sql Recordset in custom TagLib?
>
> --------------BE5706018BBA7A37F9B88955
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi Clement
>
> Sorry if I could not explain my problem, I am developing custom TagLib
that
> is test.java, I
> took the recordset rs in test.jsp
> and I wanted to use this taglib
> <test:test fields="Id,Color"/>
> and manipulate these table fields in test.java
>
> Hoping now you will be understand my problem.
>
> Thanks
>
> Younas Aamir
>
> > The QueryTable is a simplified version of ResultSet (but cached). You
can
> > do something like this:
> >
> > while (rs.next()) {
> > rs.getObject("Id");
> > rs.getObject("Color");
> > }
> >
> > You can find out the API in the JRun Tag Library Reference (taglib.pdf)
in
> > the JRun/docs directory.
> >
> > Hope this helps.
> >
> > --
> > Clement Wong
> > JRun Engineer
> > < a l l a i r e >
> >
> > -----Original Message-----
> > From: Younas Aamir [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 17, 2000 2:53 AM
> > To: [EMAIL PROTECTED]
> > Subject: Using jrun:sql Recordset in custom TagLib?
> >
> > Hi all
> >
> > I took recordset rs using the below jsp code:
> >
> > <%@ page import="allaire.taglib.*" %>
> > <%@ taglib uri="jruntags" prefix="jrun" %>
> > <%@ taglib prefix="test" uri="test.tld" %>
> >
> > <jrun:sql driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:test"
> > id="rs">
> > SELECT * FROM Colors
> > </jrun:sql>
> > <jrun:param id="rs" type="QueryTable"/>
> > <test:test fields="Id,Color"/>
> >
> > How could I use this recordset in a custom taglib for some fields
> > manipulation?
> > Could some one provide example code?
> >
> > Thanks.
> >
> > Younas Aamir
> >
> >
>
----------------------------------------------------------------------------
> > --
> > Archives: http://www.egroups.com/group/jrun-interest/
> > Unsubscribe:
> >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
> > or send a message to [EMAIL PROTECTED] with
> 'unsubscribe'
> > in the body.
> >
>
----------------------------------------------------------------------------
> --
> > Archives: http://www.egroups.com/group/jrun-interest/
> > Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
> > or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
> --------------BE5706018BBA7A37F9B88955
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Hi Clement
> Sorry if I could not explain my problem, I am developing custom TagLib
> that is test.java, I took the recordset  rs in test.jsp
> and I wanted to use this taglib
> <test:test fields="Id,Color"/>
> and manipulate  these table fields in test.java
> Hoping now you will be understand my problem.
>  
> Thanks
> Younas Aamir
>  
> <blockquote TYPE=CITE>The QueryTable is a simplified version of ResultSet
> (but cached). You can
> do something like this:
> while (rs.next()) {
>     rs.getObject("Id");
>     rs.getObject("Color");
> }
> You can find out the API in the JRun Tag Library Reference (taglib.pdf)
> in
> the JRun/docs directory.
> Hope this helps.
> --
> Clement Wong
> JRun Engineer
> < a l l a i r e >
> -----Original Message-----
> From: Younas Aamir [<a
> href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</a>]
> Sent: Thursday, August 17, 2000 2:53 AM
> To: [EMAIL PROTECTED]
> Subject: Using jrun:sql Recordset in custom TagLib?
> Hi all
> I took recordset rs using the below jsp code:
> <%@ page import="allaire.taglib.*" %>
> <%@ taglib uri="jruntags" prefix="jrun" %>
> <%@ taglib prefix="test" uri="test.tld" %>
> <jrun:sql driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:test"
> id="rs">
>  SELECT * FROM Colors
> </jrun:sql>
> <jrun:param id="rs" type="QueryTable"/>
> <test:test fields="Id,Color"/>
> How could I use this recordset in a custom taglib for some fields
> manipulation?
> Could some one provide example code?
> Thanks.
> Younas Aamir
>
-------------------------------------------------------------------------
> ---
> --
> Archives: <a
>
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
> oup/jrun-interest/</a>
> Unsubscribe:
> <a
>
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
>
alk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jru
> n_talk</a>
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe'
> in the body.
>
 ------------------------------------------------------------------------
> ------
> Archives: <a
>
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
> oup/jrun-interest/</a>
> Unsubscribe: <a
>
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
>
alk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jru
> n_talk</a>
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe'
> in the body.</blockquote>
> </html>
>
> --------------BE5706018BBA7A37F9B88955--
>
>
----------------------------------------------------------------------------
> --
> Archives: http://www.egroups.com/group/jrun-interest/
> Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
> or send a message to [EMAIL PROTECTED] with
'unsubscribe'
> in the body.
>
----------------------------------------------------------------------------
--
> Archives: http://www.egroups.com/group/jrun-interest/
> Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
> or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--------------EFB6240806D268C5BCA837A7
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi Clement
Thanks for your reply.
I want to get resultset like this.
 ResultSet   rsnew = (ResultSet)
pageContext.getAttribute("rs");
but its giving error.  Could you tell me the right way to loop
over on this resultset like
while (rsnew.next()){
     
pageContext.getOut().println(rsnew.getString("Color"));
      pageContext.getOut().println(" ");
 }
Thanks.
Younas Aamir
 <A HREF="http://advcomm.net">http://advcomm.net</A>
  
<blockquote TYPE=CITE>You still use that while loop to traverse the
recordset.
You can use
 pageContext.getAttribute("rs") from within your tag handler class
 to get the recordset.
--
 Clement Wong
 JRun Engineer
 < a l l a i r e >
-----Original Message-----
 From: Younas Aamir [<a
href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</a>]
 Sent: Friday, August 18, 2000 8:00 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Using jrun:sql Recordset in custom TagLib?
--------------BE5706018BBA7A37F9B88955
 Content-Type: text/plain; charset=us-ascii
 Content-Transfer-Encoding: 7bit
Hi Clement
Sorry if I could not explain my problem, I am developing custom TagLib
that
 is test.java, I
 took the recordset  rs in test.jsp
 and I wanted to use this taglib
 <test:test fields="Id,Color"/>
 and manipulate  these table fields in test.java
Hoping now you will be understand my problem.
Thanks
Younas Aamir
> The QueryTable is a simplified version of ResultSet (but cached).
You can
 > do something like this:
 >
 > while (rs.next()) {
 >     rs.getObject("Id");
 >     rs.getObject("Color");
 > }
 >
 > You can find out the API in the JRun Tag Library Reference
(taglib.pdf)
in
 > the JRun/docs directory.
 >
 > Hope this helps.
 >
 > --
 > Clement Wong
 > JRun Engineer
 > < a l l a i r e >
 >
 > -----Original Message-----
 > From: Younas Aamir [<a
href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</a>]
 > Sent: Thursday, August 17, 2000 2:53 AM
 > To: [EMAIL PROTECTED]
 > Subject: Using jrun:sql Recordset in custom TagLib?
 >
 > Hi all
 >
 > I took recordset rs using the below jsp code:
 >
 > <%@ page import="allaire.taglib.*" %>
 > <%@ taglib uri="jruntags" prefix="jrun" %>
 > <%@ taglib prefix="test" uri="test.tld" %>
 >
 > <jrun:sql driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:test"
 > id="rs">
 >  SELECT * FROM Colors
 > </jrun:sql>
 > <jrun:param id="rs" type="QueryTable"/>
 > <test:test fields="Id,Color"/>
 >
 > How could I use this recordset in a custom taglib for some fields
 > manipulation?
 > Could some one provide example code?
 >
 > Thanks.
 >
 > Younas Aamir
 >
 >
 ------------------------------------------------------------------------
----
 > --
 > Archives: <a
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
oup/jrun-interest/</a>
 > Unsubscribe:
 > <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
alk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jru
n_talk</a>
 > or send a message to [EMAIL PROTECTED] with
 'unsubscribe'
 > in the body.
 >
 ------------------------------------------------------------------------
----
 --
 > Archives: <a
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
oup/jrun-interest/</a>
 > Unsubscribe:
 <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
alk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jru
n_talk</a>
 > or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.
--------------BE5706018BBA7A37F9B88955
 Content-Type: text/html; charset=us-ascii
 Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
 <html>
 Hi Clement
 Sorry if I could not explain my problem, I am developing custom
TagLib
 that is test.java, I took the recordset&nbsp; rs in test.jsp
 and I wanted to use this taglib
 &lt;test:test fields="Id,Color"/>
 and manipulate&nbsp; these table fields in test.java
 Hoping now you will be understand my problem.
 &nbsp;
 Thanks
 Younas Aamir
 &nbsp;
 <blockquote TYPE=CITE>The QueryTable is a simplified version of
ResultSet
 (but cached). You can
 do something like this:
 while (rs.next()) {
 &nbsp;&nbsp;&nbsp; rs.getObject("Id");
 &nbsp;&nbsp;&nbsp; rs.getObject("Color");
 }
 You can find out the API in the JRun Tag Library Reference
(taglib.pdf)
 in
 the JRun/docs directory.
 Hope this helps.
 --
 Clement Wong
 JRun Engineer
 &lt; a l l a i r e >
 -----Original Message-----
 From: Younas Aamir [<a
 href="<a
href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</a>"><a
href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</a></a>]
 Sent: Thursday, August 17, 2000 2:53 AM
 To: [EMAIL PROTECTED]
 Subject: Using jrun:sql Recordset in custom TagLib?
 Hi all
 I took recordset rs using the below jsp code:
 &lt;%@ page import="allaire.taglib.*" %>
 &lt;%@ taglib uri="jruntags" prefix="jrun" %>
 &lt;%@ taglib prefix="test" uri="test.tld" %>
 &lt;jrun:sql driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:test"
 id="rs">
 &nbsp;SELECT * FROM Colors
 &lt;/jrun:sql>
 &lt;jrun:param id="rs" type="QueryTable"/>
 &lt;test:test fields="Id,Color"/>
 How could I use this recordset in a custom taglib for some fields
 manipulation?
 Could some one provide example code?
 Thanks.
 Younas Aamir
 ------------------------------------------------------------------
-------
 ---
 --
 Archives: <a
 href="<a
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
oup/jrun-interest/</a>"><a
href="http://www.egroups.com/gr">http://www.egroups.com/gr</a>
 oup/jrun-interest/</a>
 Unsubscribe:
 <a
 href="<a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
</a>
 alk"><a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jr
u">http://www.houseoffusion.com/index.cfm?sidebar=lists&amp;body=lists/j
ru</a>
 n_talk</a>
 or send a message to [EMAIL PROTECTED] with
 'unsubscribe'
 in the body.
 -----------------------------------------------------------------
-------
 ------
 Archives: <a
 href="<a
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
oup/jrun-interest/</a>"><a
href="http://www.egroups.com/gr">http://www.egroups.com/gr</a>
 oup/jrun-interest/</a>
 Unsubscribe: <a
 href="<a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
</a>
 alk"><a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jr
u">http://www.houseoffusion.com/index.cfm?sidebar=lists&amp;body=lists/j
ru</a>
 n_talk</a>
 or send a message to [EMAIL PROTECTED] with
 'unsubscribe'
 in the body.</blockquote>
 </html>
--------------BE5706018BBA7A37F9B88955--
-------------------------------------------------------------------------
---
 --
 Archives: <a
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
oup/jrun-interest/</a>
 Unsubscribe:
 <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
alk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jru
n_talk</a>
 or send a message to [EMAIL PROTECTED] with
'unsubscribe'
 in the body.
 ------------------------------------------------------------------------
------
 Archives: <a
href="http://www.egroups.com/group/jrun-interest/">http://www.egroups.com/gr
oup/jrun-interest/</a>
 Unsubscribe: <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_t
alk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jru
n_talk</a>
 or send a message to [EMAIL PROTECTED] with
'unsubscribe'
in the body.</blockquote>
</html>
--------------EFB6240806D268C5BCA837A7--
----------------------------------------------------------------------------
--
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Using jrun:sql Recordset in custom TagLib?

Reply via email to