MACROMEDIA CONTRIBUTE 3-DEPLOYING CONTRIBUTE Betriebsanweisung Seite 64
- Seite / 142
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
64
Serena® Collage® 5.1.3
Chapter 3 Design-Time Component Reference
How to Create and Store Structured Queries in
Collage
You can create new, blank SQL (
.sql
) files in Collage, which you can then edit in an
external editing tool to define your database queries. If you already have SQL query files
that you want to use to retrieve data for the Database Component, you can also upload
them to Collage. Collage lists all SQL files in the Project | Data Sources view, under
Queries
. This provides a short-cut to all of the queries that are currently stored in
Collage.
To create and store a structured query in Collage:
1
Do one of the following:
2
To see a list of all SQL queries stored in Collage, go to the Project | Data Sources
view, then select the
Queries
sub-view. From here, you can select and edit the SQL
files just as you would any other asset.
NOTE
If you will use the Database Query component to process a very simple query statement,
you can simply add the statement to the component itself, later on. You do not need to
store simple queries as .sql files in Collage.
If you want to... Then...
Create a new, blank
.sql file
a Go to the Project | Data Sources view.
b Select the
Queries
sub-view.
c Click the
New
button . The New structured query
dialog box appears.
d Enter a query name and description, then click
OK
.
Upload an existing
.sql query file to
Collage
a Go to the Content | Deploy Folders view.
b Select the folder to which you want to upload the query.
By default, all structured queries are stored in the
System \ Data Sources view. To keep all query files
together, select this folder.
c Click the
Upload
button .
d In the Upload dialog box, click the
Upload File
button
to browse to select the file to upload, then click
OK
.
NOTE
To check out and automatically open a .sql file in the appropriate editing tool, you must
set the
Content Editors
preference for the Structured Queries asset type.
- 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.052 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern