Hello,
The great people of Tek-tips helped me create an awesome sql cross tab (with dynamic column headings), saving it as a stored procedure. I need to be able to display this crosstab in dreamweaver (Asp vb script) as is. A dynamice table would be great. I cannot figure out how to show the column headings, I tried creating a command that would return the sp, which worked when i click test but it would generate manual code of the column headings and then error out. I need to make it completely dynamic with everything the sp returns. Picture looking at the SP and wanting to display the whole thing on the web in a grid all dynamic.
Please any suggestions would be great.
sp is called spResults
The column headings are Username, Wins, then dynamice results to the right of this.
sql2000
asp vb script
DWMX 2004
best regards.
The great people of Tek-tips helped me create an awesome sql cross tab (with dynamic column headings), saving it as a stored procedure. I need to be able to display this crosstab in dreamweaver (Asp vb script) as is. A dynamice table would be great. I cannot figure out how to show the column headings, I tried creating a command that would return the sp, which worked when i click test but it would generate manual code of the column headings and then error out. I need to make it completely dynamic with everything the sp returns. Picture looking at the SP and wanting to display the whole thing on the web in a grid all dynamic.
Please any suggestions would be great.
sp is called spResults
The column headings are Username, Wins, then dynamice results to the right of this.
sql2000
asp vb script
DWMX 2004
best regards.
