MACROMEDIA CONTRIBUTE 3-DEPLOYING CONTRIBUTE Betriebsanweisung Seite 65
- Seite / 142
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Database Query
Components User's Guide
65
Writing the Database Query Component
A simple Database Query Component is structured as follows:
<nexus:component classid="nexus/components/DBQuery"
code="$nexusComponents"
datasource="
path to data source asset
"
query="
SQL SELECT statement
">
$node.column("Column name")
</nexus:component>
It includes two sections:
1
The opening tag, which specifies the data source and the query to submit to the data
source.
2
The body section, which specifies which columns to display from the result set, and
how to format the results.
The following sections describe in detail how to write each part of the component,
followed by complete examples.
Writing the Database Query Opening Tag
The opening tag specifies the following:
The path to the data source asset (.nds file) which Collage should use to access the
database.
Either the name of the SQL query file (.sql) which Collage should pass to the
database, or a simple inline SQL SELECT statement which Collage should use to query
the database.
Optionally, a maximum number of rows to return.
Optionally, the number of initial rows to skip.
Optionally, the path to a layout file which will be used to generate details pages for
linked fields.
A complete opening tag might look something like:
<nexus:component classid="nexus/components/DBQuery"
code="$nexusComponents"
datasource="/System/Data%20Sources/Company%20Database.nds"
query="SELECT Name, Position, FROM Employee WHERE Salary > 4000">
In this example, you can optionally replace the
query
property with a
queryfile
property, which can then define a path to a SQL query file in Collage. For example:
<nexus:component classid="nexus/components/DBQuery"
code="$nexusComponents"
datasource="/System/Data%20Sources/Company%20Database.nds"
queryfile="/System/Data%20Sources/emp_name_positions.sql">
In this example, the linked query file, emp_name_positions.sql, may contain just the
same simple SELECT statement. You can also store much more complex queries in a
linked file.
- 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)MD Building Products 87684 manuály
Uživatelské manuály a uživatelské příručky pro ne MD Building Products 87684.
Poskytujeme 1 manuály pdf MD Building Products 87684 ke stažení zdarma podle typů dokumentů: Instalační příručka
Kommentare zu diesen Handbüchern