Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Moving to a specific row
Date: Aug 31 2000 5:17PM
Andrew Armstrong writes:
> All I want to do is mimic the following PHP function in perl
> int sybase_data_seek (int result_identifier, int row_number)
> Returns: true on success, false on failure
> sybase_data_seek() moves the internal row pointer of the Sybase
> result associated with the specified result identifier to pointer
> to the specifyed row number. The next call to sybase_fetch_row()
> would return that row.
> I can write my own function to do this but ff there is a way to do this in
> Sybase::CTlib I would love to know how.
I'd be interested in seeing the C code for that PHP function. AFAIK
the only way to do this is to actually fetch the rows...
> Quoting Michael Peppler :
> > Andrew Armstrong writes:
> > > I routinely have to report large numbers of database table rows to a
> > web page
> > > and was having a problem limiting the number of rows I display using
> > the
> > > standard CTlib methods. I can use set rowcount xxxx but this only
> > limits the
> > > resultset to the first xxxx rows. I want to be able to move the
> > resultset to a
> > > row that I choose. I can do this in PHP and was wondering how the
> > best way to do
> > > this in Perl would be.
> > >
> > > The only solution that i have found is to call ct_fetch() xxxx times
> > and ignore
> > > the results or to use ct_sql to move the results into an array and
> > start at the
> > > xxxx element. Neither of these seem very good for system performace.
> > >
> > I don't see how PHP could do this any better than perl. It is limited
> > by what Sybase understands, and in this particular case it is limited
> > by the way SQL works.
> > As SQL is set-based you can't say "get me rows x through y". Instead
> > you have to use an appropriately constructed where clause that will
> > give you the next x rows.
> > Michael
> > --
> > Michael Peppler -||- Data Migrations Inc.
> > firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
> > Int. Sybase User Group -||- http://www.isug.com
> > Sybase on Linux mailing list: email@example.com
> Andrew Armstrong firstname.lastname@example.org
> Chief E-Commerce Engineer http://www.qdebit.com
> AMIS , LLC.
Michael Peppler -||- Data Migrations Inc.
email@example.com -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: firstname.lastname@example.org