Fast Uncompromising Discussions. FUDforum will get your users talking.
Tony, I'm trying to emulate what you have done with the mnu_control table as described in your article 'A flexible method of storing control data', and by looking at your code in the menu app. I've created a table of the structure you have suggested, and intend to use the field 'record_id' to identify an entity in the application for which I want to store configuration data. Each entity will then be able to store its own configuration, and each config item will be identified by its record_id, field_id primary key. The data is being inserted and updated fine, but I noticed that when retrieving the data, entries for ALL record_ids are coming back. I tried adding record_id into the _cm_filterWhere method, but that has not solved the problem. In debugging it seems to be getting removed in the qualifyWhere function. I tried debugging the menu app to see what happened there, and discovered that you have the same problem. The record_id='SYSTEM' in the $where clause is also being removed, effectively retrieving every record in the table. Fortunately, there aren't any different records in the table at the moment. I can't figure out how to resolve this. Graham
You are correct. The attached file contains a fix.