![]() |
![]() |
![]() |
|
![]() |
|||
![]() |
|||
![]() |
GoLive 6 Dynamic Content Samples | ||
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
||||||
Main View | Administration View | How it Works | ||||||
![]() |
||||||||
![]() |
|
There are two tables: the Sections table contains information about catalog sections; the ProductData table contains information about products. The relationship between the two indicates that every product is in a section, and that a section can contain more than one product. SectionsThe Sections table lists all of the sections by name. The advantage of having these names in a separate table is that we can dynamically construct a table of contents in the Main View that shows the sections. Sections includes an empty string as the first row. This is used to help construct the popup menu for query-by-example on the Find Items page. ProductDataEach product has a name, a price, a description, a small and large image, and a catalog section in which it appears. There is also a unique ID field. GoLive automatically adds references to the ID field whenever a page uses Show Details of Current Record. Because the small and large images are related by a naming convention, the GL_Catalog_ProductData table only keeps track of a single image name. The Products query reconstructs the actual file names. |