financialcoder
Forum Replies Created
-
Thats amazing ! I will try the new features !
Thanks both of you for the messages !So, it is not clear how to tell the plugin to replace the variables in the MySQL query, with data received from the API that the plugin is creating… would you mind clarifying the syntax required by the plugin, please…. I couldn’t find it anywhere in the plugin documentation.
I have also attempted the Custom SQL Query with the following Sintax :
UPDATE zaqgutmy_WPUKX.NK_MKTSTATUS SET code = <Parameter1> WHERE instrument = “<Parameter2>”
But the plugin responds with this:{
“success”: false,
“data”: “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘<Parameter1> WHERE instrument = “<Parameter2>”’ at line 1”
}
I am writing a simple Custom MySQL Query, as follows:
UPDATE zaqgutmy_WPUKX.NK_MKTSTATUS SET code = $signal WHERE instrument = $symbol
I want the plugin to replace the 2 variables started with $, by the actual Custom Parameters…. But it is not being accepted… What would be the expected format to write this snipped to replace the Custom Parameter by its value coming from the http request ?