I have a routine that I can pass an SQL statement to and if produces an excel spreadsheet of the query results. The problem is that building the excel document is slow and takes up to 3 or 4 minutes depending on the set of the results. So, I got the idea that if I could take the resultset and convert it into an XML or HTML document I could display it in a browser and it would be much faster. In fact, some of the other folks here had done something similar and it worked very well, but was very complicated to set up. Of course, they did not us any of the Notes XML classes in their processes. I’m sure there must be a way to do what I’m wanting to do using the Notes XML Classes, but I have no experience with them at all. Is there a sample app or document someplace that would help? Is there anyone out there who has done something similar?
Any help would be greatly appreciated.
Thanks,
MJ