Have a problem... hope to find a solution here :)
I have a strSQL line.. that basically does a SELECT * from many joined tables. The output is displayed into a table. What I'd like to do is, to have each table's field entries (say a Name field) displayed as a URL.
Clicking this URL will spawn an external viewer, which will open a predefined MS Word template. ASP code should then do a few SELECT statements, parse them, and write them to certain areas of the MS-Word document.
Practically, a user should be able to click on a name, and have MS-Word launch, filling in details on the Word document, such as Name, Address, ZipCode and so on, which are stored in SQL-Server 2k.
So. That's basically it.. any idea how I can get this to work? I know how to make the hyperlinks appear in each table cell, but after that it's a total blank :)