sybperl-l Archive

From: Andrew Armstrong <andrew at qdebit dot com>
Subject: Re: Moving to a specific row
Date: Aug 31 2000 3:11PM

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.

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.
> mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list@isug.com
> 



-------------------------------------------------------------------------------
Andrew Armstrong                                          andrew@qdebit.com
Chief E-Commerce Engineer                                 http://www.qdebit.com
AMIS , LLC.