PHP: sesam_seek_row - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

sesam_settransaction sesam_rollback

Last updated: Fri, 26 Jan 2007

view this page in

# sesam_seek_row

(PHP 3 CVS only)

sesam_seek_row -- Set scrollable cursor mode for subsequent fetches

## Description

bool sesam_seek_row ( string result_id, int whence [, int offset] )

`result_id` is a valid result id (select type queries only, and only if a "scrollable" cursor was requested when calling sesam_query()).

`whence` sets the global default value for the scrolling type, it specifies the scroll type to use in subsequent fetch operations on "scrollable" cursors, which can be set to the following predefined constants:

Таблица 1. Valid values for `"whence"` parameter

Value | Constant | Meaning
--- | --- | ---
0 | `SESAM_SEEK_NEXT` | read sequentially
1 | `SESAM_SEEK_PRIOR` | read sequentially backwards
2 | `SESAM_SEEK_FIRST` | fetch first row (after fetch, the default is set to `SESAM_SEEK_NEXT`)
3 | `SESAM_SEEK_LAST` | fetch last row (after fetch, the default is set to `SESAM_SEEK_PRIOR`)
4 | `SESAM_SEEK_ABSOLUTE` | fetch absolute row number given as `offset` (Zero-based. After fetch, the default is set to `SESAM_SEEK_ABSOLUTE`, and the offset value is auto-incremented)
5 | `SESAM_SEEK_RELATIVE` | fetch relative to current scroll position, where `offset` can be a positive or negative offset value (this also sets the default "offset" value for subsequent fetches).

`offset` is an optional parameter which is only evaluated (and required) if `whence` is either `SESAM_SEEK_RELATIVE` or `SESAM_SEEK_ABSOLUTE`.

add a note User Contributed Notes
sesam_seek_row
There are no user contributed notes for this page.
sesam_settransaction sesam_rollback

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST