Mike wrote:Huh? What table?> Hello,
> I wrote some code below to retrieve data from these tables:
> Stat corresponds to a table of variable names and MiniStatData
> corresponds to a table of variable values. Each Mini can have
> multiple stats, and each stat has a value.
> The first problem I ran into is that it is obviously not very robust-
> if I am missing a value for one of the stats, all the values that
> follow will be shifted by 1 column on the table.
Show us a few rows of sample data from each source table (in tabular format)
and then show us the desired results (again in tabular format). Please
include the data that causes the problem you are trying to solve in your
sample data, and show the incorrect results (in tabular format)
Same request as above: sample data, current results, desired results: all in>
> The second problem I ran into is how to sort by the column headings (I
> hyperlinked them so I can click on them to send a sort-by value back
> to the page). The second SQL statement below has two ORDER BY parts
> and I can't really figure out how to order the whole table by the
> values themselves given the way the database is layed out.
Only show us the minimum number of fields required to illustrate the
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the