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.

Image 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.