I am trying to run some reports based on a queries that include parameters. In the select statement of one, I have an IF statement
Code: Select all
IF(columnA= 'X', 123, 456)
that gives me a
Likewise, I have another query runningUnknown column 'X' in field list
Code: Select all
WHERE columnA = 'Y'
which yields and error
I'm not sure what this means, as my SQL seems legit. I thought it might have something to do with syntax or using ' compared to `, but I'm not sure. Kind of sucks too, because I was ready to go live today... now I have to submit a watered down version.Unknown column 'Y' in 'where clause
cheers