Using a MySQL variable in a data query throwing me an error

Ignition (and JDBC) doesn’t like any database’s variables. Because they are all vendor specific scripts, not standard SQL. JDBC expects you to execute one and only one statement per call.

3 Likes