7.4

l Color
l Mapping: Select a mapping for the content of the script in the script editor—the mapping is used as well when
the script appears in the text box of the Run Script actions properties dialog. Each mapping (Default, Classic,
Ocean, Twilight) includes pre-set color values and attributes for each script element as listed in the Elements list
box. After selecting a mapping, you can edit individual elements to change their pre-sets by selecting them in
the Element list box and editing their values.
l Element list box: Select a script element in the Element list box, then edit the background and foreground
color with which it is displayed, and/or its formatting attributes. Each element recognized for each scripting lan-
guage, for example, a URL in a JavaScript script, is displayed with the properties you set.
l Foreground: Select the color that the element highlighted in the Element list box is displayed with in the Script
Editor.
l Background: Select the background color that the element highlighted in the Element list box is displayed with
in the Script Editor. The color is used to highlight the element as if it was selected with the cursor.
l Attributes group
l Bold: Select to bold the element highlighted in the Element list box when it is displayed in the Script
Editor.
l Italic: Select to italicize the element highlighted in the Element list box when it is displayed in the Script
Editor.
l Underline: Select to underline the element highlighted in the Element list box when it is displayed in the
Script Editor.
Other Dialogs
These dialogs are either accessible from the preferences or from different parts of PlanetPress Suite.
Advanced SQL Statement dialog
The AdvancedSQLStatement dialog is available by clicking the Edit SQLbutton from the Database Action Task. You can enter
a custom SQLquery in this dialog, using the language supported by the database you select in the Database Action Task.
The dialog is separated in two parts:
l The left part displays the available tables in your database. Click the Show Tables button to display them.
l The right part displays a default SQLstatement which you can modify at your leisure.
l The bottom part displays the following options:
l Alternate syntax:Select to prevent automatically enclosing the names of any database tables and fields that
appear in the SQL query in square brackets when it exits the advanced SQL Statement dialog box. The alternate
syntax may be required for some database types.
l Client-side Cursor:When this option is enabled, the complete result set is downloaded before processing
starts, and changing records is done by PlanetPress. This is generally faster for queries returning a small
number of results ; otherwise the start of the record processing can be delayed since the whole recordset must
be downloaded.
MySQL, using ODBC 5.0, must be set to use a client-side cursor.
Microsoft Access will always work better when using a Server-Side cursor.
l Expect record set:Check if you are expecting a result from the database after executing the SQLquery. If
the query is expecting a record set in return and does not return one, the task will trigger an error.
l Test SQLbutton:Verify the SQLstatement's validity.
The PlanetPress Suite Workflow Tools Configuration Program