Alex,

I'm really trying to grasp how things are done in the program, but so much of this is new (including SQL) that I'm failing on several points.

One is how to use DBSQL.pm . It would be better for any modifications to use that interface, since they would survive upgrades better, and cause less conflicts (hopefully).

Could you explain the order of using your DBSQL.pm to handle calls to the database?
For example: When would I need to create a new object, vs using one that had been created? Can I create a new object in a subroutine, rather than using an existing one?) When is connect() called vs 'new' and what is the advantage of passing it parameters since most calls seem to be without them?

If I wanted to create a subroutine in one of the callable programs (add.cgi, search.cgi, etc) to do something extra, what would the order of operations be to connect to the database, prepare a query, execute it, and handle the results?

I had hoped by now there'd be some discussion here on how to start to modify it, but the silence is deafening.