Noticed that a number of records in the documents table have NULL for a value in the doc_coll_id field (e.g. 941 through 967). If my SQL includes a condition like "documents.doc_coll_id = collections.coll_id", that will not test true for records with values of NULL. The query SELECT * FROM `documents` where doc_coll_id > 0 returns 1296 records, which matches the number returned by queries which didn't behave has expected as posted before. Will look into creating a "[none]" value in the collections table and then pointing to that.
This entry was posted by and filed under Activity log.