RE: [PHP] mssql_data_seek offset error
| From: | Alex Hogan | Date: | Tue, 09 Mar 2004 21:00:57 +0000 |
| Subject: | RE: [PHP] mssql_data_seek offset error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-179922@lists.php.net to get a copy of this message | ||
There are 10+ rows of data.
Actually I should say there are over 100 rows of data returned and broken up
into sets of 10 records each. (approx. 103 total records)
alex hogan
> -----Original Message-----
> From: Jay Blanchard [mailto:jay.blanchard@niicommunications.com]
> Sent: Tuesday, March 09, 2004 2:52 PM
> To: Alex Hogan; PHP General list
> Subject: RE: [PHP] mssql_data_seek offset error
>
> [snip]
> I am using mssql_data_seek() to move the cursor to a particular row for
> paging.
>
> $cnt = mssql_data_seek($result, $i);
>
> This works fine until the variable $i reaches a value of 9 and seemingly
> higher. (at least 10, I haven't gone higher)
>
> Then I get this error;
>
> mssql_data_seek(): Bad row offset in [snip] on line: x
>
> The line in question is the one above.
>
> Why does it work fine until it reaches 9?
>
> Why can't the offset go above 8?
> [/snip]
>
> How many rows of data do you have? I would have to bet 9 rows.
******************************************************************
The contents of this e-mail and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom it is addressed. The views stated herein do not
necessarily represent the view of the company. If you are not the
intended recipient of this e-mail you may not copy, forward,
disclose, or otherwise use it or any part of it in any form
whatsoever. If you have received this e-mail in error please
e-mail the sender.
******************************************************************