Re: getRowCount()

2001-03-30 Thread Ben Groeneveld 

yc, it's
funny you ask because I just went thru the same.  The answer is in your std
java doc 'jdbc getting started guide' under:

5.1.4Determining the Number of Rows in a 
Result Set

BenG.

mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] 
wrote:
[EMAIL PROTECTED]">mid:[EMAIL PROTECTED]">Additional Header Information:Received: from http://www.houseoffusion.com">www.houseoffusion.com ([207.31.122.140]) by 
inside.pgi.com (LotusSMTP MTA v4.6.6  (890.1 7-16-1999)) with SMTP id 
85256A1F.005B3AFA; Fri, 30 Mar2001 11:36:28 -0500Received: from 
houseoffusion.com ([207.31.122.140])  by http://www.houseoffusion.com">www.houseoffusion.com (Post.Office MTA 
v3.5.3release 223  ID# 0-54969U100L100S0V35) with ESMTP id com 
 for mailto:[EMAIL PROTECTED]"><[EMAIL PROTECTED]>;
  Fri, 30 Mar 2001 11:24:07 -0500Content-type: text/plainContent-type: 
text/plainDate: Fri, 30 Mar 2001 11:15:18 -0500From: Ed Apostol mailto:[EMAIL PROTECTED]"><[EMAIL PROTECTED]>Message-id:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]"><[EMAIL PROTECTED]>Subject:
 correctionReply-To: mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]To: 
JRun-Talk mailto:[EMAIL PROTECTED]"><[EMAIL PROTECTED]>-Hi
 Eveyone,Does anyone knows how to get getRowCount() after I ran a query?JRun 
tag, sql does support getRowCount(), If I don't use JRun's sql tag, how canI get 
the recordcount after i ran a query?Where can I find what else method does 
JRun sql tag support?Thank youYC
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: getRowCount()

2001-03-30 Thread cwong 

<%@ page import='allaire.taglib.*' %>




<%
QueryTable t = (QueryTable)pageContext.getAttribute("result");
out.print(t.getRowCount());
%>

In JRun 3.1 (currently in beta), you should be able to treat
the query object like javax.sql.RowSet.

-C

--
Clement Wong
JRun Engineer, Macromedia
http://www.macromedia.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 12:06 PM
To: JRun-Talk
Subject: getRowCount()





Additional Header Information:
Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com
(Lotus
SMTP MTA v4.6.6  (890.1 7-16-1999)) with SMTP id 85256A1F.005B3AFA; Fri, 30
Mar
2001 11:36:28 -0500
Received: from houseoffusion.com ([207.31.122.140])
  by www.houseoffusion.com (Post.Office MTA v3.5.3
release 223
  ID# 0-54969U100L100S0V35) with ESMTP id com
  for <[EMAIL PROTECTED]>;
  Fri, 30 Mar 2001 11:24:07 -0500
Content-type: text/plain
Content-type: text/plain
Date: Fri, 30 Mar 2001 11:15:18 -0500
From: Ed Apostol <[EMAIL PROTECTED]>
Message-id:
<[EMAIL PROTECTED]>
Subject: correction
Reply-To: [EMAIL PROTECTED]
To: JRun-Talk <[EMAIL PROTECTED]>


-





Hi Eveyone,
Does anyone knows how to get getRowCount() after I ran a query?
JRun tag, sql does support getRowCount(), If I don't use JRun's sql tag, how
can
I get the recordcount after i ran a query?

Where can I find what else method does JRun sql tag support?

Thank you

YC
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists