I’m trying to write a custom query to “Insert into” a SQL table. However, I’m having trouble getting the parameters to work properly. As I try to bind the post parameters to the SQL query, it’s giving me errors - see below example.
However, I can somehow make it work when there is only one parameter/binding in my custom insert SQL query - see below (the error is only there because timestamp is a required field, but it does recognise the parameter):
I’ve tried other combinations of parameters but I just can’t make the full insert query work (I do need to use a custom query for my insert, as I’m intending to nest queries).
Is this a bug, or am I doing something wrong? Appreciate any help, thanks!