The <pagelinks> function is not working as expected in a particular database.
The function runs:
<sql row skip=$skip max=10 "select rec_id, firstname, middlename, lastname, birthplace, occupations, residence, birthdate from btv
where lastname like $lname and
birthplace like $bplace and
occupations like $occ and
residence like $res and
interviewers like $iviewers and
birthdate >= $lowyear and birthdate <= $highyear
order by lastname, firstname, middlename">
<results_row>
</sql>
<pagelinks>
The skip variable $skip is set to 0 in <main> and is exported url. The query works fine, but <pagelinks> is not calculating correctly. It only bumps up $skip by one for each link (instead of 10).
What could be going on?
Thanks,
David
The function runs:
<sql row skip=$skip max=10 "select rec_id, firstname, middlename, lastname, birthplace, occupations, residence, birthdate from btv
where lastname like $lname and
birthplace like $bplace and
occupations like $occ and
residence like $res and
interviewers like $iviewers and
birthdate >= $lowyear and birthdate <= $highyear
order by lastname, firstname, middlename">
<results_row>
</sql>
<pagelinks>
The skip variable $skip is set to 0 in <main> and is exported url. The query works fine, but <pagelinks> is not calculating correctly. It only bumps up $skip by one for each link (instead of 10).
What could be going on?
Thanks,
David
