> That cured 9 but it still freaks on 10. It returns the error for the
> entire
> loop count.
> [/snip]
>
> Because $paging might be turning the integer you need into text? Maybe?
I found it.
In that sql statement I'm using SELECT DISTINCT
In the sql statement that I'm using to get my recor
[snip]
> Try this
>
> $query = "SELECT DISTINCT q.questions
> FROM SG_Questions as q, SG_QuesRef as r
> WHERE r.pos_id = '$pos' AND r.sic_id = '$sic' AND
> r.cat_id
> = '$cat' AND r.ques_id = q.ques_id";
> $result = mssql_query($query) or die("Can not execute q
> Try this
>
> $query = "SELECT DISTINCT q.questions
> FROM SG_Questions as q, SG_QuesRef as r
> WHERE r.pos_id = '$pos' AND r.sic_id = '$sic' AND
> r.cat_id
> = '$cat' AND r.ques_id = q.ques_id";
> $result = mssql_query($query) or die("Can not execute query $q
[snip]
$query = "SELECT DISTINCT q.questions
FROM SG_Questions as q, SG_QuesRef as r
WHERE r.pos_id = '$pos' AND r.sic_id = '$sic' AND
r.cat_id
= '$cat' AND r.ques_id = q.ques_id";
$result = mssql_query($query) or die("Can not execute query $query. ");
for ($i =
> What does mssql_num_rows($query) return?
105
alex
**
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 vie
[snip]
$query = "SELECT DISTINCT q.questions
FROM SG_Questions as q, SG_QuesRef as r
WHERE r.pos_id = '$pos' AND r.sic_id = '$sic' AND
r.cat_id
= '$cat' AND r.ques_id = q.ques_id";
$result = mssql_query($query) or die("Can not execute query $query. ");
for ($i =
[snip]
> There is your problem. Return ALL of the records, then use
> mssql_data_seek to move about.
[snip]
OK, I'm returning all the rows and no change.
Code:
$query = "SELECT DISTINCT q.questions
FROM SG_Questions as q, SG_QuesRef as r
WHERE r.pos_id = '$pos'
[snip]
>PLEASE STOP TOP POSTING!
Sorry Didn't mean to don't even know exactly what it is
[/snip]
When you post a reply above a response.
[snip]
> Are you selecting all of the records at once, or just a few at a time?
I am returning a few records at a time.
[/snip]
There is your p
>PLEASE STOP TOP POSTING!
Sorry Didn't mean to don't even know exactly what it is
> Are you selecting all of the records at once, or just a few at a time?
I am returning a few records at a time.
alex hogan
*
[snip]
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)
[/snip]
PLEASE STOP TOP POSTING!
Are you selecting all of the records at once, or just a few at a time?
4 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 variabl
[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 off
12 matches
Mail list logo
