Setup Recordset Navigation: First, Pre, Next and Last.

A displaying function is done , now I move on next step which is to create recordset navigation. It contains 4 navigated texts such as First, Previous , Next and Last. This technique is called Recordset Paging.

A table with 1 row will be set up below multiple record displaying. In each cell, I fill in all the texts.

Firstly, I make a function for "First" navigation. My aim is when users click on the "First" navigation, they will move to the first record of database as product ID : 1.

I hightlight the text then move to Server Behavior tab, this time, I choose Recordset Paging then Move to First Record.

Applying "Move to Previous Record" of Repeat Paging to "Previous" navigation and "Move to next record" for "Next:" navigation and "Move to last record" for "Last" navigation.

The "Previous" and "Next" navigation help customers go back or go on their research on catalogue of product, the "Last" navigation help customer quickly go to the last item of database.

After setting up all functions, I preview my page for testing

However, when I am testing the page, there is a error



I check on the image path of 11th product in database, the extension of image is JPEG and the image is out of image folder. these are reasons that cause image can not be stored.

I open my database and change extension of my image from JPEG to JPG, save my database then upload to hosting. I go to my Local View, drop the image of product ID: 11 to image folder.

After fixing them, the result comes up.



for last moment now, I already finish my work on displaying multiple records and recordset navigation