much easier query is: "select count(1) as totalRecordsField from foo"
>From: "Matthew L. Wright" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: JRun-Talk <[EMAIL PROTECTED]>
>Subject: Re: Re[2]: getRowCount()
>Date: Fri, 30 Mar 2001 16:45:06 -0800
>
>Also, in case you have many records you're pulling up yo may not want to
>cycle through all of them.
>
>Use: "Select count(*) as totalRecordsField from foo" and then pull the
>value of the "totalRecordsField". This is a easier query on the DB as you
>need not deal with the cursor as much.
>
>Matt
>
>Matthew L. Wright
>Java Internet Programmer
>Jupiter One
>Web World Studios West Coast
>www.jupiterone.com
>(818) 763-2927
>----- Original Message -----
>From: "Moore, Jim" <[EMAIL PROTECTED]>
>To: "JRun-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, March 30, 2001 12:36 PM
>Subject: RE: Re[2]: getRowCount()
>
>
> > String sql = "SELECT * FROM foo";
> > Statement stmt = conn.createStatement();
> > ResultSet rs = stmt.executeQuery(sql);
> > int rowcount = rs.getRow();
> > rs.beforeFirst();
> > while (rs.next()) {
> > file://process resultset
> > }
> >
> > or
> >
> > String sql = "SELECT * FROM foo";
> > Statement stmt = conn.createStatement();
> > ResultSet rs = stmt.executeQuery(sql);
> > int rowcount = 0;
> > while (rs.next()) {
> > file://process resultset
> > rowcount++;
> > }
> >
> > --jim
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 30, 2001 3:13 PM
> > To: JRun-Talk
> > Subject: Re[2]: 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.006958EB; Fri,
>30
> > Mar
> > 2001 14:10:40 -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 13:56:17 -0500
> > Content-type: text/plain
> > Content-type: text/plain
> > Date: Fri, 30 Mar 2001 13:42:43 -0500
> > From: [EMAIL PROTECTED]
> > Message-id:
> > <3312CFEA8474D411BAB600508B9587B21CE785@S0001EXC0007>
> > Subject: RE: getRowCount()
> > Reply-To: [EMAIL PROTECTED]
> > To: JRun-Talk <[EMAIL PROTECTED]>
> >
> >
> > ---------------------------------
> >
> >
> >
> >
> > if I don't use allaire tag, how can I get the recordcount after I ran a
> > query?
> >
> >
> >
> >
> > thank you
> >
> > YC
> >
> >
> > <%@ page import='allaire.taglib.*' %>
> > <j:sql datasrc='...' id='result'>
> > ....
> > <j:sql>
> >
> > <%
> > 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
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
