List Variable ToQueryParameter() doesn't work for MySQL/MariaDB

Stimulsoft Reports.JS discussion
Post Reply
AcidSlide
Posts: 8
Joined: Sat Aug 14, 2021 7:46 pm

List Variable ToQueryParameter() doesn't work for MySQL/MariaDB

Post 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.
Attachments
BookingList.mrt
(21.97 KiB) Downloaded 120 times
ListInQuery.mrt
(7.95 KiB) Downloaded 126 times
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB

Post by Lech Kulikowski »

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
#4770
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB

Post by Lech Kulikowski »

Hello,

Please try to set the following option:
StiOptions.Engine.escapeQueryParameters = false;

Thank you.
AcidSlide
Posts: 8
Joined: Sat Aug 14, 2021 7:46 pm

Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB

Post 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.
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: List Variable ToQueryParameter() doesn't work for MySQL/MariaDB

Post by Lech Kulikowski »

Hello

Ok.
Please let us know if you need any additional help.

Thank you.
Post Reply