
Well... a little progress today. Started with trying to combine 2 of the 'make' programs (inmemory and pending). I put the common stuff (at the end) into a subroutine which requires removing the 'my' declarations (I did it for everything...expedient...but I can probably restore the ones not needed across the subroutine boundary). Seems to work OK. At present it requires you to put 'pending' and 'inmemory' on the command line...but that can be changed if you think you'll only be running some of the 'makes'... or if you want the flexibility to do one (or more, but not all) on occassion. The 'makes' that can all go fairly easily into a single entity have the same code after the sth->execute command (that's what I put in a subroutine). This is a first cut...there are likely to be other ways to handle a few things that may enable more consolidation later. Some of it is pretty crude...but it works, including using a 'variable' inside the SQL string. Since each of these 'makes' has their very own little HTML statement, it may be difficult to combine everything...although having external text files that can be imported will make the 'final' combined 'make' file smaller. Yes...I saw your comment about making a 'variables' file to be imported...that is also on my list as we move forward. Cheers... -m-