Question
Yet Another 8.0.2 bug
With 8.0.2 (at least with PHP/MySQL) you can no longer use a
variable in your custom SQL more than once. You must specify
"duplicate" variables. For example - I want to find all records
where either SCORE is equal to a passed URL parameter or PLACE is
equal to the same URL parameter. This will NOT work anymore:
SELECT * FROM mytable
WHERE score = varTheParam OR place = varTheParam
Define your varTheParam, try to test the results and you get yelled at because varTheParam is undefined. Your SQL must be like this:
SELECT * FROM mytable
WHERE score = varTheParam OR place = varTheSameParamAgain
Now, define your varTheParam and varTheSameParamAgain - setting them both equal to the same thing. A waste of resources here.
SELECT * FROM mytable
WHERE score = varTheParam OR place = varTheParam
Define your varTheParam, try to test the results and you get yelled at because varTheParam is undefined. Your SQL must be like this:
SELECT * FROM mytable
WHERE score = varTheParam OR place = varTheSameParamAgain
Now, define your varTheParam and varTheSameParamAgain - setting them both equal to the same thing. A waste of resources here.
AdChoices