I just found ChronoConnectivity tonight. I think it is just what I need. We were about to write some custom code to all our church secretary to be able to update a table of our classes and small groups. This looks like it will fill the need, and we won't have to write the custom code.
The install and a first, very quick attempt at a simple display worked fine. The problem comes when we click on "show data" in the back end. The following error is displayed.
DB function failed with error number 1054
Unknown column 'id' in 'order clause' SQL=SELECT * FROM jos_ctsmallgroups ORDER BY id LIMIT 0,20
I do not have an ID field in the table we are using, and I can not find where to eliminate it from the ORDER BY clause in the back end. (I haven't looked at the code yet.) Could the ORDER BY clause be made configurable like there WHERE BY clause?
George
The install and a first, very quick attempt at a simple display worked fine. The problem comes when we click on "show data" in the back end. The following error is displayed.
DB function failed with error number 1054
Unknown column 'id' in 'order clause' SQL=SELECT * FROM jos_ctsmallgroups ORDER BY id LIMIT 0,20
I do not have an ID field in the table we are using, and I can not find where to eliminate it from the ORDER BY clause in the back end. (I haven't looked at the code yet.) Could the ORDER BY clause be made configurable like there WHERE BY clause?
George
