I am having difficulty in displaying the total records in a repeat region. Actually, I successed to add the page numbers by dragging the [first record index], [last record index] and [total records] from the recordset, but only the total records shown in the table is not the actual total records in the database (SQL Server). It display "Record 1 to 5 of -1" where '1' is First Record, '5' is Last Record and '-1' is Total Records.

Please HELP!!

Thanks in advance...

Yuki

why don't you just use the Dreamweaver Recordset Navigation Status from the Applications tab on the menu bar, to display your records. If that doesn't work then post your code.

Cheers,

Javier

Ya. I know Dreamweaver has Recordset Navigation Status function, but I faced problem also. When I click on the Recordset Navigation Status icon from the Application tab on the menu bar, it's pop up a Setup Instructions window. Ask me to create a Recordset. But I already have created a recordset. Then I just follow the insruction, create a recordset again. But the OK button in the Setup Instruction can't function. So I can't use the Recordset Navigation Status icon and I wanna know why also. Any idea?

The code as below:
<tr>
<td colspan="3" class="style17">Records <%=(rsTravelSchedule_first)%> to <%=(rsTravelSchedule_last)%> of <%=(rsTravelSchedule_total)%></td>
</tr>

Output:
Records 1 to 3 of -1

Thanks in advance...

Yuki

Actually, I got the solution. I just uninstall and reinstall the dreamweaver. Then the problem had been resolved.

Yeah!!!