Is it not possible SET a variable in a SQL query? This does not seem to work but works fine on my server directly. SELECT @foo :=1; SELECT @foo or SET @foo = 1; SELECT @foo [image]

MySQL JDBC drivers can only perform one “transaction” at once. I once tried to run an update query then a delete from query on the same table in one named query, but it would not work. I had to break them up into two separate named queries. I tried this and it works select @foo := 1, @foo2 :=3 I…

[image] 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. A similar issue was posted not too lon…

Thanks a lot, figured it was a JDBC driver issue.

[image] Using a MySQL variable in a data query throwing me an error Ignition If you add allowMultiQueries = true to the Extra Configuration Properties in the advanced database connection properties, you should be able to use MySQL variables in the query. The query, however…

Named Query - MySQL SET Variable Not Working

Ignition

mcgheeiv January 17, 2019, 10:39am 5