Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Aug 24, 2016 2:30 pm**

Hi,

I'm trying to execute the following query,when creating new data source

SELECT LOWER(CONCAT('asset2_',REPLACE(AssetType,' ','_'))) FROM assettype2

However, I'm getting these errors.

Error #1088 and #1099

any help?

Posted: **Thu Aug 25, 2016 9:28 am**

Hello.

Did you try to run this query on your mysql database? Is it right?
Could you also specify which version of our product you use?

Thank you.

Creating reports and dashboards | Stimulsoft community forum

CONCAT / LOWER / REPLACE in MYSQL Query

CONCAT / LOWER / REPLACE in MYSQL Query

Re: CONCAT / LOWER / REPLACE in MYSQL Query