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 29-Dec-2020 05:25 Halmágyi Árpád
png
compress_task.png 54.6 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
copy_task.png 135.1 kB 5 29-Dec-2020 05:25 Halmágyi Árpád
png
decompress_task.png 53.4 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
delete_task.png 118.0 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
email_task.png 72.3 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
exclude_task.png 44.2 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
execute_task.png 96.6 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
fileparser_task.png 64.9 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
find_task.png 129.1 kB 5 29-Dec-2020 05:25 Halmágyi Árpád
png
findcache_task.png 51.0 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
http_task.png 89.5 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
java_task.png 51.2 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
jump_task.png 77.4 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
kill_task.png 44.5 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
link_task.png 49.4 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
makedirectory_task.png 109.9 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
move_task.png 129.3 kB 4 29-Dec-2020 05:25 Halmágyi Árpád
png
pgp_task.png 61.2 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
popimap_task.png 115.0 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
preview_task.png 43.9 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
rename_task.png 59.7 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
sort_task.png 44.7 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
jpg
sql_task.jpg 141.0 kB 1 03-Jun-2021 17:24 Ada Csaba
png
sql_task.png 85.3 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
tunnel_task.png 54.2 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
unzip_task.png 59.1 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
userlist_task.png 68.3 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
userslist_task.png 31.9 kB 1 29-Dec-2020 05:25 Ben Spink
png
uservariable_task.png 68.3 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
wait_task.png 51.8 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
writefile_task.png 90.3 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
zip_task.png 58.4 kB 4 29-Dec-2020 05:25 Halmágyi Árpád

This page (revision-65) was last changed on 08-Oct-2021 12:22 by Ben Spink

This page was created on 29-Dec-2020 05:25 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
65 08-Oct-2021 12:22 15.959 kB Ben Spink to previous
64 17-Jul-2021 02:22 15.729 kB Ben Spink to previous | to last
63 03-Jun-2021 17:32 15.552 kB Ada Csaba to previous | to last
62 03-Jun-2021 17:25 15.369 kB Ada Csaba to previous | to last
61 03-Jun-2021 17:23 15.306 kB Ada Csaba to previous | to last
« This page (revision-65) was last changed on 08-Oct-2021 12:22 by Ben Spink
G’day (anonymous guest)
CrushFTP10 | What's New
JSPWiki v2.8.2