Page 1 of 1
List Variable ToQueryParameter() doesn't work for MySQL/MariaDB
Posted: Mon Aug 23, 2021 2:32 am
by AcidSlide
Hello,
I'm not sure if this is a bug when using MySQL/MariaDB type database, we get errors.
https://pasteboard.co/Kh9vAL6.png
Code: Select all
(var1.Count == 0 ? "(' ')" : "(" + var1.ToQueryString("'") + ")")
We tried based on the comment on this thread:
viewtopic.php?t=55467#p146159 (attached file ListInQuery.mrt)
We attached a test MRT file.
Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB
Posted: Wed Aug 25, 2021 7:24 pm
by Lech Kulikowski
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
#4770
Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB
Posted: Wed Sep 15, 2021 9:39 am
by Lech Kulikowski
Hello,
Please try to set the following option:
StiOptions.Engine.escapeQueryParameters = false;
Thank you.
Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB
Posted: Wed Sep 15, 2021 12:23 pm
by AcidSlide
Lech Kulikowski wrote: ↑Wed Sep 15, 2021 9:39 am
Hello,
Please try to set the following option:
StiOptions.Engine.escapeQueryParameters = false;
Thank you.
Thanks Lech, we will try that settings.
Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB
Posted: Wed Sep 15, 2021 1:13 pm
by Lech Kulikowski
Hello
Ok.
Please let us know if you need any additional help.
Thank you.