7.0

ManualsBrandsObjectif Lune ManualsApplicationsPlanetPress Suite

161

162

163

164

165

166

167

168

169

170

Table Of Contents

Create data pages as follows: Select the option used to generate the data pages. Each data page created

using the table or query selected above (Table/Query box) can contain a single record, a fixed number of

records, or a variable number of records. To choose the last option, select one of the When [field name]

changes listed in this box.

Sort on conditional field: Select this option if you want the table to be sorted using the field selected in the

Create data pages as follows box before the data page creation process is started.

Data encoding: Select the encoding used in the generated XML file. By default, this option is set to the

default encoding of the computer used to create or edit the configuration. You may choose any encoding listed

in the drop-down list or enter your own.

Maximum records per page: Select this option if you want to limit the number of records per page. This

option is only available if you indicated that you wanted each data page to contain several records in the

Create data pages as follows box.

Data encoding: Select the encoding to be used in the generated XML file. By default, this option is set to the

default encoding of the computer used to create or edit the configuration. You may choose any encoding listed

in the drop-down list or enter your own.

Alternate syntax: Select this option if your query uses an alternate syntax.

Edit SQL: Click to create and test an advanced SQL query.

Import Config: If you previously created and exported a PlanetPress Database Connection configuration,

click this button to import it. This saves you the trouble of configuring the connection every time.

Include password in config: Select to save an encrypted version of the database password (if any) within

the exported configuration.

Export Config: Click to export the currently displayed properties of the PlanetPress Watch/Server action task.

The exported configuration can then be reused on other PlanetPress Watch/Server workstations.

Dynamic SQL tab

Use dynamic values at runtime group

Use dynamic values at runtime: Select to use a dynamic database connection string and/or SQL statement

at runtime. Check this box to enable the options included in this group (this disables the corresponding

options in the General tab).

Parse normally: Select to interpret any backslashes included in the database connection string as

backslashes. If this option is not selected, any backslash that is not doubled will be disregarded.

Database connection string: Enter a variable connection string in this box. To do this you may begin by

clicking to create an ODBC connection string to the data source and paste the string automatically to this box.

Note that if a login name and password are required to connect to the database, a dialog box is displayed and

the information you enter is saved in the configuration of the PlanetPress Database action task. Another

option, if a database connection string (not a database path and name) was already entered in the Database

Connection tab, is ti simply copy and paste it to this box. Bear in mind that if the Parse normally option is not

selected, any backslashes included in the connection string that is not doubled will be disregarded. Once your

connection string is displayed in this box, you can edit it by adding variables or data selections.

SQL statement: Enter your SQL statement. Remember that you may use variables and data selections in

your statement.