I know I'm coming late to the party... but if the right solution (and by right I mean, works best with least code) is a SQL Query, has there been any discussion with the client about backing their domino websites with something more robust for data? I know that means a lot more work than any solution identified, but where there is one clear need for this kind of data flexibility, there may be more. Perhaps their Admin or System Architect would be receptive to expanding the capabilities and you'd have yourself some work updating their templates. :-)
A tangent, but I try to consider all the possibilities when I start running into too many difficulites with a particular approach. While more involved, it seems cleaner.
Jake,
I know I'm coming late to the party... but if the right solution (and by right I mean, works best with least code) is a SQL Query, has there been any discussion with the client about backing their domino websites with something more robust for data? I know that means a lot more work than any solution identified, but where there is one clear need for this kind of data flexibility, there may be more. Perhaps their Admin or System Architect would be receptive to expanding the capabilities and you'd have yourself some work updating their templates. :-)
A tangent, but I try to consider all the possibilities when I start running into too many difficulites with a particular approach. While more involved, it seems cleaner.
Best of luck in any case!
Jerry