List images and show thumbnails

For a better management of your gallery, follow the next steps in order to create a list with all your images:

1. Open the \admin\list_img page.

2. Create a recordset that retrieves data from the image_img database table.
   · Click on the Plus (+) button of the Bindings tab. If the Bindings tab is not visible, open it from Window -> Bindings.
   · From the pop-up menu that appears, select Recordset (Query). This will open the Recordset dialog window.
   
   
   
   · Name the recordset rsImages.
   · Select the database Connection (connGallery) and the Table that stores images (image_img).
   · Sort the images by date in descending order to list the most recent images first.
   
   
            

3. List all images using a dynamic table (Insert bar -> Application -> Dynamic Table):
   
   
         

4. Configure the dynamic table as seen in the following image:
   
   
    

5. Trim the generated table as follows:
   · Delete the first column containing the primary key.
   · Change the column headings to something more meaningful.
   · Remove the dynamic text labeled as rsImages.filename_img. You will replace this later with an actual preview of the image (an image thumbnail).

6. Your table should look like this by now:
   
   
    

7. In the empty cell, below insert a thumbnail view of the image, by applying the Show Thumbnail server behavior (Application panel -> Server Behaviors -> + -> MX Kollection -> File Upload -> Show Thumbnail).
   
   
    

8. An interface like the one below is displayed.
   
   
       

9. The Show Thumbnail icon will look like in the following image in your Dreamweaver Design View:
   
   
          

10. Save your page and preview it in the browser: