Case variable is not parsed on dependent field query

Case variable is not parsed on dependent field query#783229

By khoer52 - Thu May 28, 2015 5:53 am

- Thu May 28, 2015 5:53 am #783229

Dear all,

I am trying to make dropdown as dependent field and textbox as an independent field.
I have checked mysql log and i found that my query did not parse the variable on textbox.

Here is my query on dropdown as dependent field.

Code: Select all

SELECT USR_USERNAME FROM USERS WHERE USR_EMAIL='@#emailEndUser'

Can you explain what is my mistake? Or should i post it in mantis?

Attachments

In mysql log, variable in query is not parsed
Selection_073.png (17.55 KiB) Viewed 8113 times

I have made sure the variable is exist
Selection_074.png (14.48 KiB) Viewed 8113 times

Re: Case variable is not parsed on dependent field query#787240

By MickyRamirez - Mon Oct 31, 2016 9:53 am

- Mon Oct 31, 2016 9:53 am #787240

Hello khoer52,

You are parsing your string where it comes the email, into a float, you can use @@ or @= in order to execute the query. We already try this and it works. SELECT USR_USERNAME FROM USERS WHERE USR_EMAIL='@=emailEndUser'

Greetings.