Thread

Oops...

Mike Frisch <mfrisch@saturn.tlug.org> — 1999-04-10T16:33:27Z

With respect to my previous query, I'd like to clarify that the FETCHes I
am doing are subsets of the full results (hence I cannot use PQntuples).
For instance, I am FETCHing 25 records out of a possible 1000, so
PQntuples() is returning 25.  I need some way of knowing there's a 1000
total.

Thanks,

Mike.

======================================================================
  Mike Frisch                         Email: mfrisch@saturn.tlug.org
  Northstar Technologies        WWW: http://saturn.tlug.org/~mfrisch
  Newmarket, Ontario, CANADA
======================================================================

Re: [GENERAL] Oops...

Brett W. McCoy <bmccoy@lan2wan.com> — 1999-04-10T16:55:06Z

On Sat, 10 Apr 1999, Mike Frisch wrote:

> With respect to my previous query, I'd like to clarify that the FETCHes I
> am doing are subsets of the full results (hence I cannot use PQntuples).
> For instance, I am FETCHing 25 records out of a possible 1000, so
> PQntuples() is returning 25.  I need some way of knowing there's a 1000
> total.

Why can't you get the number of the initial results before fetching them
page by page?  If you create an initial query and save it as a view, why
can't you grab the number out of that first result set (via a ntuples
function call or by executing an SQL statement), then page through it with
your cursor?  Or can cursors not be created from views?

Brett W. McCoy           
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
If the human brain were so simple that we could understand it,
we would be so simple we couldn't.

Re: [GENERAL] Oops...

Marcin Grondecki <ojciec@mtl.pl> — 1999-04-12T18:33:50Z

simple - first try "select count(*) from ...",
and then "declare ..." and subsequent fetches.

Mike Frisch napisał(a):
> 
> With respect to my previous query, I'd like to clarify that the FETCHes I
> am doing are subsets of the full results (hence I cannot use PQntuples).
> For instance, I am FETCHing 25 records out of a possible 1000, so
> PQntuples() is returning 25.  I need some way of knowing there's a 1000
> total.
> 
> Thanks,
> 
> Mike.
> 
> ======================================================================
>   Mike Frisch                         Email: mfrisch@saturn.tlug.org
>   Northstar Technologies        WWW: http://saturn.tlug.org/~mfrisch
>   Newmarket, Ontario, CANADA
> ======================================================================

-- 
Marcin Grondecki
ojciec@mtl.pl
(604)468725

*** I'm not a complete idiot - some parts are missing