---

Date Posted: 1/12/10

I have made a lot of progress tonight.  Now is a good stopping point.  In short the checkboxes do not work yet, but much of the framework for them has been set up.  Somewhere around 40% of the framework I would say.

Here is what I have learned about this bug.  Results are not displayed if any aspect of the result contains a NULL value.  For example if no rating was given for an anime review, or if a memo blog has no image stored in the database, which is the case with most of the older memo blogs, the result will not be displayed.

Here is an example of the old query:
CODESELECT ID, summary, image FROM memoblog WHERE (lcase( concat(cast(ID as char), summary, image)) LIKE '%yoo%' )CODE
here is the revised query:
CODESELECT ID, summary, image FROM memoblog WHERE (lcase( concat(cast(ID as char), summary, IFNULL(image,''))) LIKE '%yoo%' )CODE

The updated query has not been implemented yet either.  Maybe I can finish this update tomorrow.  If I continue on tonight I fear I will do more harm than good.



TAGS: none