MACROMEDIA CONTRIBUTE 3-DEPLOYING CONTRIBUTE Betriebsanweisung Seite 60
- Seite / 142
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
60
Serena® Collage® 5.1.3
Chapter 3 Design-Time Component Reference
Database Query
The Database Query component displays data from records which Collage retrieves from
an external SQL database. You can define and store data source information in Collage.
Collage then uses these definitions to access external databases. You can also store SQL
query files, which Collage runs when it connects to the data sources. The Database
Component can then display the records that the queries return, with HTML formatting
applied to them. Optionally, you can also automatically link fields from each row to detail
pages, which can display all of the fields which are returned to the component.
How the Database Query Component Works
The following table describes the process which Collage follows to retrieve external data
and display it via the Database Query component.
How to Define Data Sources in Collage
Before you can use the Database Query component to retrieve and display database
records, you must define a data source, or external database, in Collage. The data
sources are stored in Collage as
.nds
files. Once you have defined the data source, you
can define structured queries to that data source, which retrieve the data that is displayed
by the Database Query component.
Stage Description
1
Deploy the asset the contains that Database Query component. The
component includes a property which identifies the data source definition
asset (
.nds
) that Collage should use to connect to an external database.
The component also includes a property which either:
Identifies the SQL query file (
.sql
) that Collage should pass to the
database, or
If the query is very simple, includes the entire text of the query.
2
Collage connects to the external database, as defined in the data source
asset which the component specifies.
3
If Collage successfully connects to the database, it passes the query to the
database server.
4
If the database server successfully processes the query, it returns the query
results to Collage.
5
Collage passes the query results (a set of database rows) to the
component.
6
The component displays fields from the returned rows, as defined in the
component HTML. Unique HTML can be defined for each returned row or
even each field, or the component can apply the same HTML to all records
in the result set.
7
Optionally, the data can be linked to detail pages, which can display any of
the fields that are returned for a particular row. Detail pages are generated
from pre-defined contribution layout files. The layout files determine which
fields from the linked row to display, and how each field is formatted.
- Components User’s Guide 1
- Trademarks 2
- U.S. Government Rights 2
- Table of Contents 3
- . . . . . . . . . . . 121 5
- Welcome to Serena Collage 7
- Chapter 1 9
- About the Components 10
- About Design-Time Components 10
- Components and Master Pages 12
- Studying the Source Code 13
- Developing and Deploying 15
- Assets that Use Components 15
- Development Requirements 16
- Collage server name 17
- How to Test Components 18
- About Component Deployment 18
- Chapter 3 21
- Data Field Macro Reference 23
- "field_name" 24
- Asset Metadata Field 28
- URL Fields 28
- Formatting Date Fields 29
- "yy" 31
- "yyy" 31
- AssetQuery 32
- AssetQuery Properties 34
- $node.psurl 35
- $node.pdfurl 35
- $node.htmlurl 35
- About the AssetQuery body 45
- Data Fields Macro Section 46
- 'metadata_name' 47
- <nexus:next> 48
- <nexus:exit> 49
- <nexus:norecords> 49
- AssetQuery Examples 50
- Querying by Date 53
- Start and 54
- Image Banner 56
- Text Banner 56
- Conditional 57
- Conditional Parameters 58
- Conditional Properties 59
- Conditional Example 1 59
- Conditional Example 2 59
- Database Query 60
- SQL SELECT statement 65
- Database Query Properties 66
- queryfile 67
- The Database Records Section 68
- <nexus:next> 70
- How to Set Up a Layout File 71
- Example Layout File Code 72
- ForceReference 73
- ForceReference Properties 74
- Include Asset 75
- Include Asset Properties 78
- Masterpage Body 80
- Masterpage Body Properties 81
- MetaTag Properties 82
- MetaTag Example 1 83
- MetaTag Example 2 83
- Navigation Bar 84
- Components 85
- How the Navigation Bar Works 85
- About Image Buttons 86
- Node Options for Links 89
- Site Structure Node Options 90
- Deploy Folder Node Options 90
- Navigation Bar Properties 91
- Navigation Bar Examples 93
- Button text will display 94
- Inactive page 94
- Active page 94
- Writing the NavMap Component 97
- NavMap Properties 97
- Generating Node Level Numbers 98
- // children indent in pixels 99
- Generating Node Name 100
- Generating a Node URL 100
- Query Navigator 101
- Button Types 102
- What Buttons Can You Define? 103
- Dreamweaver 103
- Manually 104
- Button Tag Reference 105
- Component Tag 108
- Displaying Text on Images 110
- Complete Example 110
- Select Properties 111
- Multiple Languages 112
- Content at Preview Time 113
- WARFiler 114
- /Configuration 115
- /Content 115
- /WarContents 115
- 4: Define WARFiler Properties 118
- Reference 121
- How Collage Uses Layout Files 122
- Use Standard HTML Files 122
- Layout Contribution Field 124
- Layout Contribution Metadata 127
- Component Works 128
- Metadata Component 128
- Layout Contribution Property 130
- Property Component 131
- FileName 133
- Serena® Collage® 5.1.3 134
- Advanced Examples 135
- About the Examples 136
Verwandte Produkte und Handbücher für Software MACROMEDIA CONTRIBUTE 3-DEPLOYING CONTRIBUTE
(7 Seiten)© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.025 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern