View Attach (34) Info

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
png
 as2_task.png 91.3 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 compress_task.png 54.6 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 copy_task.png 135.1 kB 5 05-Dec-2023 05:32 Halmágyi Árpád
png
 decompress_task.png 53.4 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 delete_task.png 118.0 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 email_task.png 72.3 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 exclude_task.png 44.2 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 execute_task.png 96.6 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 fileparser_task.png 64.9 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 find_task.png 129.1 kB 5 05-Dec-2023 05:32 Halmágyi Árpád
png
 findcache_task.png 51.0 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 http_task.png 89.5 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 java_task.png 51.2 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 jump_task.png 77.4 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 jump_task_groupby.png 28.6 kB 1 05-Dec-2023 05:32 Ada Csaba
png
 kill_task.png 44.5 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 link_task.png 49.4 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 makedirectory_task.png 109.9 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 move_task.png 129.3 kB 4 05-Dec-2023 05:32 Halmágyi Árpád
png
 pgp_task.png 61.2 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 popimap_task.png 115.0 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 preview_task.png 43.9 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 rename_task.png 59.7 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 sort_task.png 44.7 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
jpg
 sql_task.jpg 141.0 kB 1 05-Dec-2023 05:32 Ada Csaba
png
 sql_task.png 85.3 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 tunnel_task.png 54.2 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 unzip_task.png 59.1 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 userlist_task.png 68.3 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 userslist_task.png 31.9 kB 1 05-Dec-2023 05:32 Ben Spink
png
 uservariable_task.png 68.3 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 wait_task.png 51.8 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 writefile_task.png 90.3 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 zip_task.png 58.4 kB 4 05-Dec-2023 05:32 Halmágyi Árpád

This page (revision-81) was last changed on 20-Nov-2024 04:21 by Ben Spink

This page was created on 05-Dec-2023 05:32 by Ben Spink

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 89 changed one line
!input:
!input/parameters:
At line 185 changed one line
This task can be used to run SQL statements or even full scripts against an SQL database server.
This task can be used to run SQL statements or even full scripts against an SQL database server. The DB driver class name and the URL syntax is usually specific to a certain DB family, need to find out from the documentation of the JDBC driver.
At line 189 changed 7 lines
!input/parameters:
*DB Driver: the JDBC driver class name.\\
*DB Driver: the list of arguments passed to Command, the list items separated by Separator character ";" (semicolon) by default. In case running scripts, here comes\\
the script file name followed by any arguments to be passed to
*Working directory: the parent path of the binary or script file, we do a change directory into this folder before invoking Command. In case running scripts, here comes\\
the full parent path of the script file
*Environment variables: leave it empty, rarely needed
!parameters:
*DB Driver: the JDBC driver class name.\\
*DB Driver File: the JDBC driver jar file path on server.\\
*DB URL: the SQL server URL we connect to.\\
*DB User, DB Password: the login credentials of the DB query account.\\
*Query: input field for the SQL statement or script.\\
\\
!input:
Generic list items passing from the previous task. Input fields also accept server variables, where it makes sense.
At line 197 changed one line
the task will feed it's output to the next task item, if any, can be referenced by the {execute_log} server variable
The SQL task will feed it's output to the next task item, if any. The DB table column names can be used as server variables, enclosed within curly brackets, to reference table cell values of a row. The next task will usually loop through the rows list.
Version Date Modified Size Author Changes ... Change note
81 20-Nov-2024 04:21 17.887 kB Ben Spink to previous
« This page (revision-81) was last changed on 20-Nov-2024 04:21 by Ben Spink
G’day (anonymous guest)
CrushFTP11 | What's New

Referenced by
Enterprise License Enhancements
Jobs
LeftMenu

JSPWiki