Create a List Page - Step II

10. Save the page by clicking File > Save.

11. Now save the same page as the listBy.asp page by clicking File > Save As and selecting the listBy.asp page.

NOTE: You should now have the listBy.asp page open and that is where we will continue working.

Next we will create a recordset that is filtered by the CategoryID so that it will only display the data for that Category.

12. Open the Bindings Panel (CTRL + F10) if it is not already open.

13. Click on the (+) sign in the Bindings Panel and select Recordset(Query) and use the following settings.

NOTE: Scroll down in the Columns and also select the UnitPrice field.

14. Click on the Test button in the Recordset window and you should see the image below. Enter 1 in the Test Value in the Please Provide a Test Value window and click OK.

15. Click OK in the Test SQL Statement and Recordset windows.

Click here to continue the tutorial.