Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-27 : 08:55:45
|
| David writes "On http://www.mendips.biz/testtariff.asp are two tables. The larger table, created in asp, shows a sample of the options possible (Row Title) and the result for userID 2 is shown in Dynamic Data. If the actual list were shown it would involve scrolling down. With so many empty cells the data is "lost".I would prefer to display only the rows that contain live data. For userID 2 the result would look like the lower table. I have tried sp_makewebtask but that has two drawbacks. 1: Where the column is NULL the generated page contains "n/a" so I don't overcome the scrolling issue.2: I would like to display the data in two columns down the page where the first column contains column names and the second data but this does not appear possible.An alternative approach might be to generate a temporary table based upon the userID where column IS NOT NULL. I can do this for a single column but not where multiple NULLs are involved, which is always the case. The userID is passed from a previous page.Ideally I would like it all done in a stored prodcedureSQL 7 SP3NT4 SP6a" |
|
|
|
|
|
Displaying table data in an .asp page