Aktionen - SQL Statement

Page / - last modified by gru on 30.04.2021, 16:12

SQL Statement

last modified by gru

on 30.04.2021, 16:12

Table of Contents

Options

Note

Actions of type Database query allow you to write custom SQL queries and execute them against a database. The database connection must have been setup in the database connection menu. The SQL statement may contain variables.

Options

Statement

The SQL statement to be executed.

Note

The statement will be executed as a so called prepared statement, which prevents SQL injection attacks. You do not need to use simple quotation marks (').

Correct

insert into test_tabelle (firstName, lastName) values ([%tfFirstName%], [%tfLastName%])

Wrong

insert into test_tabelle (firstName, lastName) values ('[%tfFirstName%]', '[%tfLastName%]')