8.6

Table Of Contents
l Import Config: If you previously created and exported a PlanetPress Workflow Database
Connection configuration, click this button to import it. This saves you the trouble of
configuring the connection every time.
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 Workflow. 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 record set must be downloaded.
Note
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 Include password in config: Select to save an encrypted version of the database
password (if any) within the exported configuration.
l
Export Config: Click to export the currently displayed properties of the PlanetPress
Workflow action task. The exported configuration can then be reused on other
PlanetPress Workflow workstations.
Dynamic SQL tab
l Use dynamic values at run-time: Select to use a dynamic database connection string
and / or SQL statement at run-time. Check this box to enable the options included in this
group (this disables the corresponding options in the General tab).
l 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.
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 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 Workflow
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
Page 287