Unknown column 'x' in field list or where clause
Posted: Sat Aug 11, 2012 3:28 am
Greetings,
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
X here is a string.
that gives me a
where Y is a string
which yields and error
cheers
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