Forums

ASP

This topic is locked

Outputting Data...HELP!

Posted 22 May 2002 17:42:33
1
has voted
22 May 2002 17:42:33 carolus Holman posted:
Simple problem, after my customers fill in a 56 step form (12 Pages in paper) I need to output the Data from over 25 tables into a single comprehensive document. The only way I know how to do this is to use the Stored Procedures I have written to "Get" the data out of SQL2000 and then dump it section by section in to a page. The problem (I think) is having up to 12 Procedure calls per Section (7 sections in all) this would create a huge file. Some of the sections have repeating information like contacts, key personnel, these call the same tables but use a different "Key" like 1=Main Office, 2= Key Personnel etc. I have heard but not used XML, XSL is there any GOOD solutions out there? The total output could be (but not limited to) at minimum 250 fields.

Carolus Holman

Reply to this topic