Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

sql editor mysql parameter issue

Hello,

 

I want to use a parameter in my mysql source query. I've created a parameter (Power query Editor) "start" (in my tests it doesn't matter if type is date or text) and trying to retrieve some records. In my mysql query I used: DATE(voorstelling.`aanvangstijd`) >= '" & start & "' ( start has a value of 2022-02-28).

 

It does show me all the records though and not only the records greater or equal then 2022-02-28. After al lot of testing I opend the advanced editor and it showed me the following for the parameter: DATE(voorstelling.`aanvangstijd`) >= '"" & start & ""'

 

Notice there is twice a double quote on both sides, I changed this to:  >= '" & start & "' and suddenly all works well.

 

However, by doing this I'm not able to edit the mysql query anymore, the icon to edit the query has gone.

before:

after:

 

Is this a bug? How can I correct the mysql query so all works well? Ive tested with different variations of quotes to no avail.

 

Thnx Remco

 

1 Reply